NULL NUMERIC on IBM iSeries

GoogleCodeExporter commented 8 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 8 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

Changed state: Hold

GoogleCodeExporter commented 8 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

sakuto29 / pyodbc

NULL NUMERIC on IBM iSeries #232