search

YongpingZhang / pyodbc

Automatically exported from code.google.com/p/pyodbc
MIT No Attribution
0 stars 0 forks source link

NULL NUMERIC on IBM iSeries #232

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Run select query where a column with a NUMERIC value is NULL. 
2. Fetch result(s)

What is the expected output? What do you see instead?
InvalidOperation: Invalid literal for Decimal: ''

What version of the product are you using? On what operating system?
pyodbc 2.1.11 on CentOS6

Please provide any additional information below.
When trying to run this against 3.0.3, it core dumps with a bus error.

Original issue reported on code.google.com by lewis.fr...@gmail.com on 19 Jan 2012 at 8:02

GoogleCodeExporter commented 9 years ago 
If this is still happening, can I get an ODBC trace?

I don't have access to this database to test.

Original comment by mkleehammer on 29 Sep 2012 at 7:56

GoogleCodeExporter commented 9 years ago 
This turns out to be a bug in the ODBC drivers from IBM where NULL is 
improperly handled in a 64-bit environment.  Here is a bug report that explains 
the problem: https://bugs.php.net/bug.php?id=54007

Long story short: this is IBM's fault, not yours, so can (and probably should) 
be closed.

Original comment by lewis.fr...@gmail.com on 12 Feb 2014 at 5:39