My favorites | Sign in
Project Home Downloads Wiki
READ-ONLY: This project has been archived. For more information see this post.
Search
for
  Advanced search   Search tips   Subscriptions
Issue 232: NULL NUMERIC on IBM iSeries
1 person starred this issue and may be notified of changes. Back to list
Status:  Hold
Owner:  ----


 
Reported by lewis.fr...@gmail.com, Jan 19, 2012
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.
Sep 29, 2012
Project Member #1 mkleehammer
If this is still happening, can I get an ODBC trace?

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

Status: Hold
Feb 11, 2014
#2 lewis.fr...@gmail.com
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.

Powered by Google Project Hosting