[
https://issues.apache.org/jira/browse/TRAFODION-1239?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Anuradha Hegde updated TRAFODION-1239:
--------------------------------------
Fix Version/s: (was: 2.0-incubating)
2.1-incubating
> 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.1-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)
