Re: Bitand Question

From: Ron <support_at_dbainfopower.com>
Date: Sat, 6 Mar 2004 15:59:21 -0800
Message-ID: <PpOdnRkyqfG7-dfdRVn-jw@comcast.com>

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 Sat Mar 06 2004 - 17:59:21 CST