By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,919 Members | 1,047 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,919 IT Pros & Developers. It's quick & easy.

Bitand Question

P: n/a
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.

Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Ron

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_ad...isclaimer.html
"Terry Coccoli" <re*****@ifneeded.com> wrote in message
news:NF**********************@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.

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.