You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Anuradha Hegde (JIRA)" <ji...@apache.org> on 2016/05/12 23:53:12 UTC
[jira] [Updated] (TRAFODION-1262) LP Bug: 1461677 - Insert small
data into large varchar column(>32K) failed with error 8402- string
overflow
[ https://issues.apache.org/jira/browse/TRAFODION-1262?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Anuradha Hegde updated TRAFODION-1262:
--------------------------------------
Fix Version/s: (was: 2.0-incubating)
2.1-incubating
> 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.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)