Re: Odd math

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: 2000/07/12
Message-ID: <u5vomssgai59a6rl9dkkoqbis4fq3kp0vv@4ax.com>#1/1

Wow. I just upgraded from 8.1.5, so I can't go back and try this, but I think you've found a bug. There must be some internally buffered version of log(2,4) that doesn't quite work out to 2.0, and which is getting passed to trunc.

Jonathan

---

jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are

On Wed, 12 Jul 2000 04:11:57 GMT, steve.adams_at_ixora.com.au (Steve Adams) wrote:

>Hi All,
>
>Oracle 8.1.6 appears to think that ... trunc(log(2, 4)) = 1.
>
> SQL> select trunc(log(2,4)) from dual;
>
> TRUNC(LOG(2,4))
> ---------------
> 1
>
>Does it reproduce on earlier versions?
>Any comments?
>
>Regards,
>Steve Adams
>http://www.ixora.com.au/
>http://www.oreilly.com/catalog/orinternals/
>http://www.christianity.net.au/
Received on Wed Jul 12 2000 - 00:00:00 CDT