[DB-SIG] Returning floats in DCOracle2

Alexei Ustyuzhaninov alust@UralskyGSM.com
Fri, 29 Nov 2002 14:57:48 +0500


Hi!

I have ran into a silly problem with DCOracle2. It returns wrong float 
numbers from SELECT statement.

bash-2.04$ cat test.py
import DCOracle2
db = DCOracle2.connect("x/y@z")
c = db.cursor()
c.execute("SELECT 0.5 FROM DUAL")
print c.fetchone()

bash-2.04$ python test.py
[3.6097722056218853]

Unfortunately 0.5 is somewhat different from 3.6097722056218853.
The environment is:
HP-UX 11.11
python 2.2.2
DCOracle2 1.2

Could somebody give me a tip on the problem please?

-- 
Best regards,
Alexei Ustyuzhaninov