BIGINT column returned as str type

GoogleCodeExporter commented 9 years ago

What steps will reproduce the problem?
1. selecting a bigint column from a table

What is the expected output? What do you see instead?
I expect python int/long type but i get str instead

What version of the product are you using? On what operating system?
ibm_db 0.2.5 - Suse Linux 9.3

Please provide any additional information below.
I fix it by adding in _fix_return_data_type (ibm_db_dbi.py) the code below
if type == 'INT':
    row[index] = int(row[index])

but in this way i will also convert INT and SMALLINT that don't need conversion

Original issue reported on code.google.com by gtsys...@gmail.com on 13 Mar 2008 at 2:17

GoogleCodeExporter commented 9 years ago

Original comment by apiti...@ca.ibm.com on 14 Mar 2008 at 8:10

GoogleCodeExporter commented 9 years ago

Thank you for pointing this out and giving a quick solution.
I have looked into the issue, and in new version this would be fixed.

Original comment by abhigyan...@in.ibm.com on 20 Mar 2008 at 7:06

GoogleCodeExporter commented 9 years ago

Original comment by apiti...@ca.ibm.com on 24 Mar 2008 at 8:56

GoogleCodeExporter commented 9 years ago

Original comment by apiti...@ca.ibm.com on 24 Mar 2008 at 8:57

Changed state: Started

GoogleCodeExporter commented 9 years ago

Fixed in ibm_db-0.2.8

Original comment by apiti...@ca.ibm.com on 28 Mar 2008 at 10:11

Changed state: Fixed

waliwali / ibm-db

BIGINT column returned as str type #5