Re: Bitand Question

Hello Terry,

  Please check metalink - it has number of articles published on custom bitand functionality.

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: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 Thu Mar 11 2004 - 10:18:46 CET