sqlrelay-discussion

[Sqlrelay-discussion] Buggy Oracle numbers processing in python client

[Renat S. <sr...@st...>]

Hi!

There is a proble came up with 0.42. In this version python client for 
SQLRelay treats numbers as integers. It is completely wrong. Not only do 
numbers with fractions lose all after decimal point, but some numbers 
also do not fit to binary integers and got int64_max value.

Example:

from SQLRelay import PySQLRDB

con=PySQLRDB.connect('localhost',19000,'','ow_develop','ow_develop',0,1)
cur=con.cursor()

cur.execute('select 12345678901234567890123456789012345678, \
123.456 from dual')

print (cur.fetchall())


-------

$ python test.py
[[9223372036854775807L, 123L]]

N.B. Numbers in oracle have up to 38 digits

I suggest to return to string representation for numbers.

-- 
Renat Sabitov   e-mail: sr...@st...
Stack Soft         jid: sr...@ja...

Re: [Sqlrelay-discussion] Buggy Oracle numbers processing in python client

[Renat S. <sr...@st...>]

18.10.2011 18:21, Renat Sabitov пишет:

> I suggest to return to string representation for numbers.
>

Please take a look at the patch attached.

-- 
Renat Sabitov   e-mail: sr...@st...
Stack Soft         jid: sr...@ja...