RE: interesting floating point problem with oracle

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Tue, 25 Sep 2001 08:54:26 -0700
Message-ID: <F001.00398031.20010925090023@fatcity.com>

I tried to find that document on Metalink and was unsuccessful. Can you suggest any search times that would return it? Do they mention any OS/RDBMS versions where you can duplicate the problem?

I tried that query on several versions of Oracle (7.3.4, 8.0.6, 8.1.5, 8.1.6, 8.1.7) on Windows NT, Windows 2000, SunOS and always got back a result of 1.

-----Original Message-----
From: Adams, Matthew (GEA, 088130) [mailto:MATT.ADAMS_at_APPL.GE.COM]

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; Received on Tue Sep 25 2001 - 10:54:26 CDT