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@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

-- 

Regards,
Frank van Bortel

Received on Wed Mar 10 2004 - 15:22:06 CST