Floating Bug in OI1.2

Floating Bug in OI1.2

Post by Oleg Moskalenk » Tue, 17 Sep 1996 04:00:00



I found very strange bug in OI 1.2 for SPARC/Solaris 2.x (with patch 4104).
It seems that OI1.2 can't correctly compare floating and integer numbers
when structure of table is "btree unique". This is example:

(output of the sql)

-------------------------------------------------

1.

create table qqq as select int4(1) as www
\g

* go
* * Executing . . .

(1 row)

2.

select * from qqq
\g
* * Executing . . .

+-------------+
|www          |
+-------------+
|            1|
+-------------+
(1 row)

3.

select * from qqq where www>0.5
\g

* * Executing . . .

+-------------+
|www          |
+-------------+
|            1|
+-------------+
(1 row)

4.

modify qqq to btree unique on www
\g

* * Executing . . .

(1 row)

5. Attention:

select * from qqq where www>0.1
\g

* * Executing . . .

+-------------+
|www          |
+-------------+
+-------------+
(0 rows) !!!!!!!!!!!!!!!!!!!!!!!!!!

6.

select * from qqq
\g

* * Executing . . .

+-------------+
|www          |
+-------------+
|            1|
+-------------+
(1 row)

----------------------------------------------------------

It was OK in OI1.1.

Oleg Moscalenko.

 
 
 

1. SQL Server 7.0 floating bug ...

For the following SQL executed in SQL Server 7.0 without
service pack 1.0,
================================================







=================================================

we have the result below obtained:

-----------------------------------------------------
64126.974999999991

(1 row(s) affected)

-----------------------------------------------------
64126.974999999999

(1 row(s) affected)

This bug sustains after the installation of the service pack
1 but it does appear in release 6.5.

Regards,

Jason

* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
The fastest and easiest way to search and participate in Usenet - Free!

2. variables in pl/sql

3. Float Column Bug ?

4. SP error handling

5. SQL Server 7.0 Bug with float an nulls?

6. Considering buying

7. Problem/bug with BDE aggregate calc and floating point numbers

8. US-CA-Sacramento Senior Technical Support Engineer, Unify Corporation - US-CA-Sacramento-Senior-Engineer.txt [01/01]

9. Float bug

10. VB Floating Point Bugs ??

11. Bug?mystery? TDBedit componet aware with float filed

12. IBM JVM bug found while retrieving floats from JDBC 1.0 ResultSet objects

13. float bug?