Re: Bitand Question

From: Terry Coccoli <request_at_ifneeded.com>
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

Original text of this message