search

google-code-export / ords

Automatically exported from code.google.com/p/ords
1 stars 0 forks source link

ORDS changes data if Double Precision data type is used #616

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Create a table with a field with the Double Precision data type
2. Add some records 
3.

What is the expected output? What do you see instead?
I've just added 1.2 and 3.4 to two records in an ORDS table. ORDS is displaying 
the data as 1.19999999999999996 and 3.39999999999999991 respectively.

We do warn people that using this data type might result in rounding of very 
small or very large or very precise numbers, but this un-rounding is rather 
odd...

(Haven't tried this yet with Single Precision.)

Please use labels and text to provide additional information.

Original issue reported on code.google.com by meriel.p...@gmail.com on 6 Feb 2015 at 5:10