Re: Bitand Question
Date: Tue, 09 Mar 2004 17:20:49 GMT
Message-ID: <R1n3c.10259823$Of.1703273_at_news.easynews.com>
Hi Ron,
Do you know if information on this bug is available anywhere on the net?
I'm curios as to whether there was a suggested workaround.
Ron wrote:
> 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 Tue Mar 09 2004 - 18:20:49 CET