2015-05-15 22:48:27 |
Aruna Sadashiva |
description |
Using JDBC T4 driver, 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] |
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. |
|