insert using params to varchar column of > 32k colsize fails

[Aruna Sadashiva]

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.

[Aruna Sadashiva (aruna-sadashiva)]

This fails from sqlci too.

[Anoop Sharma (anoop-sharma)]

When setting up input param values that are varchar (length followed by data), code
needs to set the length based on the returned length of param after describe.
In this case, the returned param len was 40000 but the length bytes of the varchar
was being set as a 2 byte prefix. But cli was expecting first 4 bytes as the length
prefix and that returned incorrect length which caused the overflow.

This change need to be done in both sqlci frontend as well as connectivity frontend.

I have made the change in sqlci.
Someone from conn need to make this change as well.

[Anuradha (anuradha-hegde)]

Code delivered
 https://review.trafodion.org/#/c/1715/1