Issue 251: Inserting a null on any numeric column results in an error on Teradata
Status:  New
Owner: ----
Reported by dominick...@comcast.net, Apr 9, 2012
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.

SQL.LOG
65.8 KB   View   Download
Sep 29, 2012
Project Member #1 mkleehammer
(No comment was entered for this change.)
Labels: Driver-terradata