RE: interesting floating point problem with oracle

From: Koivu, Lisa <lisa.koivu_at_efairfield.com>
Date: Tue, 25 Sep 2001 09:27:12 -0700
Message-ID: <F001.00397FAB.20010925085023@fatcity.com>

Well...   not on 8.1.7.  It's fine here.

(VIKING-SYSTEM)>select 62.323/62.323 from dual;

62.323/62.323

---

            1

Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
954-935-4117

-----Original Message-----

From:   Adams, Matthew (GEA, 088130) [SMTP:MATT.ADAMS_at_APPL.GE.COM]
Sent:   Tuesday, September 25, 2001 11:35 AM
To:     Multiple recipients of list ORACLE-L

Subject:        interesting floating point problem with oracle

ran across something interesting on metalink.

from
Doc ID:  Note:1012478.7

Problem Description

---

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 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 - 11:27:12 CDT