CUBRID python driver returns NUMERIC object as float

Details

Description

Here is the test code for creating the database and the python code:

CREATE TABLE "tst2"(
"a" NUMERIC(38,12)
);
INSERT INTO tst2 values (5.3);

import CUBRIDdb
conn = CUBRIDdb.connect('CUBRID:localhost:30000:demodb', 'dba', '')
cur = conn.cursor()
cur.execute("SELECT * from tst2");
row = cur.fetchone()
print type(row[0])
cur.close()

The type returned for the NUMERIC field is (type 'float') which is incorrect. It should be returned as decimal.Decimal object.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
李林 added a comment -

There is Decimal module in Python, convert numeric type of CUBRID to decimal type in Python.

Show
李林 added a comment - There is Decimal module in Python, convert numeric type of CUBRID to decimal type in Python.
Hide
Permalink
欧明宝[Bom] added a comment - - edited

Test build : 9.1.0.0212
OS: Linux 64bit
python driver: 9.1.0.001 http://svn.cubrid.org/cubridapis/python/branches/RB-9.1.0 Revision: 1703
Test Result: pass

Show
欧明宝[Bom] added a comment - - edited Test build : 9.1.0.0212 OS: Linux 64bit python driver: 9.1.0.001 http://svn.cubrid.org/cubridapis/python/branches/RB-9.1.0 Revision: 1703 Test Result: pass

People

  • Assignee:
    欧明宝[Bom]
    Reporter:
    Veliscu Ovidiu
Vote (0)
Watch (3)

Dates

  • Created:
    Updated:
    Resolved: