[TRAFODION-1262] LP Bug: 1461677 - Insert small data into large varchar column(>32K) failed with error 8402- string overflow

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 2.1-incubating
• Component/s: client-odbc-linux, client-odbc-windows
• External issue URL: https://bugs.launchpad.net/bugs/1461677
• Assignee: Zhang,Xiang
• Reporter: JiepingZhang
• Created: 22/Jul/15 18:20
• Updated: 26/Jun/17 07:03
• Resolved: 26/Jun/17 07:03

Description

Test scenario:

Create table: CREATE TABLE ODBC32K.LargeColTbl ( C1 varchar (200000) NOT NULL, C2 CHAR(200000));
insert into ODBC32K.LargeColTbl values ('SaaaaaaaaaaaaaaaaE', 'SbbbbbbbbbbbbbbbbbE');

ODBC will return error below:
Inserting data using SQLBindParameter, SQLPrepare, SQLExecute
Function SQLExecute returned SQL_ERROR
Diagnostics associated with statmement handle:

SQL Diag 1
Native Error: 4294958894
SQL State: 22001
Message: [Trafodion ODBC Driver][Trafodion Database] SQL ERROR:*** ERROR[8402] A string overflow occurred during the evaluation of a character expression. [2015-06-03 17:36:41]

PS: If try from ODBCTest, insert will be successful, seems this only fails when done thru application.

Issue Links

• links to: GitHub Pull Request #838
• links to: GitHub Pull Request #853

Sub-Tasks

• Need to add odbc unit-test code for large varchar column issue: Open