| Issue 251: | Inserting a null on any numeric column results in an error on Teradata | |
| 1 person starred this issue and may be notified of changes. | Back to list |
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.
Sep 29, 2012
Project Member
#1
mkleehammer
Labels:
Driver-terradata
|