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

["Alice Chen (JIRA)" <ji...@apache.org>]

Alice Chen created TRAFODION-1262:
-------------------------------------

             Summary: 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: Daniel Lu
            Priority: Critical
             Fix For: 2.0-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)