RE: interesting floating point problem with oracle

From: Farnsworth, Dave <DFarnsworth_at_Ashleyfurniture.com>
Date: Tue, 25 Sep 2001 10:44:30 -0700
Message-ID: <F001.003981D3.20010925101023@fatcity.com>

<SPAN

class=964070417-25092001>>-<FONT color=#0000ff face=Courier>(VIKING-SYSTEM)>
<SPAN

class=964070417-25092001> 
<SPAN

class=964070417-25092001>Is this prompt pure coincidence???  ;o)
<SPAN

class=964070417-25092001> 
<SPAN

class=964070417-25092001>Dave

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Koivu, Lisa   [mailto:lisa.koivu_at_efairfield.com]Sent: Tuesday, September 25, 2001   11:50 AMTo: Multiple recipients of list ORACLE-LSubject:   RE: interesting floating point problem with oracle   Well...   not on 8.1.7. 
  It's fine here.
  (VIKING-SYSTEM)>select 62.323/62.323
  from dual;
  62.323/62.323 <FONT
  color=#0000ff face=Courier>------------- <FONT color=#0000ff   face=Courier>           
  1
  Lisa Koivu Oracle Database
  Administrator Fairfield Resorts, Inc.   954-935-4117   

    -----Original Message----- <FONT
    face=Arial size=1>From:   <FONT face=Arial     size=1>Adams, Matthew (GEA, 088130) [SMTP:MATT.ADAMS_at_APPL.GE.COM]     Sent:   <FONT face=Arial

    size=1>Tuesday, September 25, 2001 11:35 AM <FONT face=Arial 
    size=1>To:     <FONT face=Arial 
    size=1>Multiple recipients of list ORACLE-L <FONT face=Arial 
    size=1>Subject:        <FONT 
    face=Arial size=1>interesting floating point problem with oracle 

    ran across something interesting on     metalink.
    from<FONT
    face=Arial size=2>Doc ID:  Note:1012478.7     Problem Description<FONT
    face=Arial><FONT face=Arial

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

    Doing floating point arithmetic involving     multiplication and division<FONT
    face=Arial size=2>causes unpredictable results.  For example, if you     issue the following<FONT face=Arial     size=2>select statement from a SQL*Plus session, the result would be "~"     whichis
    incorrect.
    select 62.323/62.323 from dual;<FONT     face=Arial>
    ----<FONT
    face=Arial size=2>Matt Adams - GE Appliances -     matt.adams_at_appl.ge.com<FONT face=Arial     size=2>"Doing linear scans over an associative array is like<FONT     face=Arial>trying to club someone to     death with a loaded Uzi."<FONT face=Arial     size=2>    - Larry Wall (creator of Perl) Received on Tue Sep 25 2001 - 12:44:30 CDT