[
https://issues.apache.org/jira/browse/TRAFODION-1262?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
liu ming closed TRAFODION-1262.
-------------------------------
Resolution: Fixed
> LP Bug: 1461677 - Insert small data into large varchar column(>32K) failed
> with error 8402- string overflow
> -----------------------------------------------------------------------------------------------------------
>
> Key: TRAFODION-1262
> URL: https://issues.apache.org/jira/browse/TRAFODION-1262
> Project: Apache Trafodion
> Issue Type: Bug
> Components: client-odbc-linux, client-odbc-windows
> Reporter: JiepingZhang
> Assignee: Zhang,Xiang
> Priority: Critical
> Fix For: 2.1-incubating
>
>
> 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.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
