[ https://issues.apache.org/jira/browse/TRAFODION-1262?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15710555#comment-15710555 ]
ASF GitHub Bot commented on TRAFODION-1262: ------------------------------------------- Github user ryzuo commented on a diff in the pull request: https://github.com/apache/incubator-trafodion/pull/853#discussion_r90182437 --- Diff: core/conn/unixodbc/odbc/odbcclient/unixcli/cli/ctosqlconv.cpp --- @@ -646,12 +655,10 @@ unsigned long ODBC::ConvertCToSQL(SQLINTEGER ODBCAppVersion, if (Offset != 0) { //#ifndef MXSUN - if(DataLen>32767){ - *(int *)targetDataPtr = DataLen; + if(targetPrecision > 0x7fff){ --- End diff -- 0x7fff -> SHRT_MAX > 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.3.4#6332)