search

GoogleCodeArchives / pyodbc

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

Inserting a null on any numeric column results in an error on Teradata #251

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
Python 2.7.2; pyodbc 3.0.5; Teradata ODBC 13.00.00.09

The Teradata ODBC driver supports SQLDescribeParam, but inserting a null on any 
numeric column results in an error, such as "Error HY000: The source parcel 
length does not match data that was defined."

The table has these columns:
    a_text VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC,
    a_memo VARCHAR(16000) CHARACTER SET LATIN NOT CASESPECIFIC,
    a_long_integer INTEGER,
    a_byte BYTEINT,
    a_integer SMALLINT,
    a_single FLOAT,
    a_double FLOAT,
    a_decimal DECIMAL(18,0),
    a_date_time TIMESTAMP(0),
    a_currency DECIMAL(18,4),
    a_yes_no BYTEINT NOT NULL

I've attached the SQL.LOG.

Original issue reported on code.google.com by dominick...@comcast.net on 9 Apr 2012 at 4:38

Attachments:

GoogleCodeExporter commented 9 years ago

Original comment by mkleehammer on 29 Sep 2012 at 4:58