RE: interesting floating point problem with oracle

From: Jon Baker <jcb_at_netsec.net>
Date: Tue, 25 Sep 2001 10:09:29 -0700
Message-ID: <F001.00397D71.20010925075526@fatcity.com>

I got
a big fat 1 from 8.1.7.
<FONT face=Arial color=#0000ff

size=2> 
Guess
I'll check the doc for affected version.
<FONT face=Arial color=#0000ff

size=2> 
<FONT face=Arial color=#0000ff

size=2> 

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Adams, Matthew (GEA, 088130)   [mailto:MATT.ADAMS_at_APPL.GE.COM]Sent: Tuesday, September 25, 2001   11:35 AMTo: Multiple recipients of list ORACLE-LSubject:   interesting floating point problem with oracle   ran across something interesting on metalink.   from Doc ID:  Note:1012478.7   

  Problem Description <FONT

  size=2>=================== 

  Doing floating point arithmetic involving multiplication and   division causes unpredictable results.  For   example, if you issue the following select statement   from a SQL*Plus session, the result would be "~" which <FONT   size=2>is incorrect.
  select 62.323/62.323 from dual;

• Matt Adams - GE Appliances - matt.adams_at_appl.ge.com "Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi."     - Larry Wall (creator of Perl)

Received on Tue Sep 25 2001 - 12:09:29 CDT