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 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
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

Powered by Google Project Hosting