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

["Anuradha Hegde (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/TRAFODION-1239?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14933767#comment-14933767 ] 

Anuradha Hegde commented on TRAFODION-1239:
-------------------------------------------

This issue has been addressed a while back. It is not an issue anymore

> 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)