Re: Bitand Question
From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Wed, 10 Mar 2004 22:22:06 +0100
Message-ID: <c2o0qb$mvd$1_at_news4.tilbu1.nb.home.nl>
Date: Wed, 10 Mar 2004 22:22:06 +0100
Message-ID: <c2o0qb$mvd$1_at_news4.tilbu1.nb.home.nl>
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.
>
Confirmed:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Oracle Data
Mining options
JServer Release 9.2.0.4.0 - Production
SQL> select bitand(power(2,31),power(2,30))+0 from dual 2 ;
BITAND(POWER(2,31),POWER(2,30))+0
0
-- Regards, Frank van BortelReceived on Wed Mar 10 2004 - 22:22:06 CET