What steps will reproduce the problem?
1. Connect to Teradata system
2. Query for INT columns
3.
What is the expected output? What do you see instead?
I expect to see values other than 0
What version of the product are you using? On what operating system?
pyodbc 3.0.7
python 2.7
CentOS release 5.11
Please provide any additional information below.
If in my query I CAST the INT as BIGINT it works.
Here is my sample code
import os
import pyodbc
pyodbc.pooling = False
os.environ['ODBCINI'] = '/etc/odbc.ini'
tdConn = pyodbc.connect(dsn='td_app', uid='dse', pwd='*******', autocommit=True)
cursor = tdConn.cursor()
#stmt = "sel top 10 seg_batch_sk, cast(size_cnt as bigint) from seg_batch_f
where size_cnt > 0"
stmt = "sel top 10 seg_batch_sk, size_cnt from seg_batch_f where size_cnt > 0"
cursor.execute(stmt)
res = [row for row in cursor.fetchall()]
cursor.close()
print res
Here are the results
Not CAST
[(2374169535L, 0), (2379981746L, 0), (311410040985L, 0), (321391475642L, 0),
(311407867327L, 0), (311399737858L, 0), (2371418520L, 0), (321390910439L, 0),
(2372278387L, 0), (2381445989L, 0)]
CAST
[(311396260175L, 15363L), (2381968201L, 10801L), (311416800519L, 7L),
(2377688627L, 1875L), (2386825559L, 265L), (2377429912L, 21L), (311411011289L,
84L), (311413161989L, 6095L), (321413509615L, 13L), (2380870629L, 196L)]
Original issue reported on code.google.com by samah.so...@gmail.com on 9 Jan 2015 at 10:35
Original issue reported on code.google.com by
samah.so...@gmail.com
on 9 Jan 2015 at 10:35