Re: Bitand Question

Hello Terri,

  This may be Oracle bug 1355836 - bitand() returns true for any bit position if bit 31 is set.

  Bug is fixed in Oracle9i.

Regards,

  Ron
  DBA Infopower
  http://www.dbainfopower.com
  Standard disclaimer:
http://www.dbainfopower.com/dbaip_advice_disclaimer.html

"Terry Coccoli" <request_at_ifneeded.com> wrote in message news:NF62c.1815811$9p3.336297_at_news.easynews.com...
> Can someone tell me if the following query:
>
> select bitand(power(2,31),power(2,30))+0
> from dual
>
>
> which returns 1073741824 is correct ? I'm thinking that the result
> should actually be 0.
>
>
>
> When I run
>
> select bitand(power(2,30),power(2,29))+0
> from dual
>
>
>
> I get 0, as expected. Am I running into a limitation of the bitand
> function ? Is there any documentation on this function?
>
>
> Thanks.
>
Received on Sun Mar 07 2004 - 00:59:21 CET