[jira] [Created] (TRAFODION-1239) LP Bug: 1455670 - insert using params to varchar column of > 32k colsize fails

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

Alice Chen created TRAFODION-1239:
-------------------------------------

             Summary: LP Bug: 1455670 - insert using params to varchar column of > 32k colsize fails
                 Key: TRAFODION-1239
                 URL: https://issues.apache.org/jira/browse/TRAFODION-1239
             Project: Apache Trafodion
          Issue Type: Bug
          Components: client-jdbc-t4
            Reporter: Aruna Sadashiva
            Assignee: Arvind Narain
            Priority: Blocker
             Fix For: 2.0-incubating


Using bound params, insert into varchar column of colsize >32k fails with string overflow error.

To reproduce using Trafci :

SQL>CREATE TABLE TAB3  ( A INT, B VARCHAR(40000));
--- SQL operation complete.
SQL>prepare s from insert into tab3 values(?a, ?b);
--- SQL command prepared.
SQL>set param ?a 100;
SQL>set param ?b 'aaaZZ';
SQL>execute s;
*** ERROR[8402] A string overflow occurred during the evaluation of a character expression. [2015-05-15 21:27:01]


Steps from sqlci:

>>create table a3(a int, b varchar(32000));
--- SQL operation complete.
>>prepare s1 from insert into a3 values(?a,?b);
--- SQL command prepared.
>>set param ?a 1;
>>set param ?b 'aaaZZ';
>>execute s1;
--- 1 row(s) inserted.

>>create table a4(a int, b varchar(40000));
--- SQL operation complete.
>>prepare s2 from insert into a4 values(?a,?b);
--- SQL command prepared.
>>set param ?a 1;
>>set param ?b 'bbbZZ';
>>execute s2;
*** ERROR[8402] A string overflow occurred during the evaluation of a character expression.

--- 0 row(s) inserted.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)