[jira] [Commented] (TRAFODION-2719) Trafci insert with parameters can insert a string which length is larger than the column's length.

[ASF GitHub Bot (JIRA)]

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

ASF GitHub Bot commented on TRAFODION-2719:
-------------------------------------------

Github user DaveBirdsall commented on a diff in the pull request:

    
https://github.com/apache/incubator-trafodion/pull/1254#discussion_r142528667
  
    --- Diff: core/sql/optimizer/OptLogRelExpr.cpp ---
    @@ -2394,7 +2394,7 @@ Join::synthConstraints(NormWA * normWAPtr)
       (void) leftGA.hasCardConstraint(minLeft,maxLeft);
       (void) rightGA.hasCardConstraint(minRight,maxRight);
     
    -  if (maxLeft == 1)
    +  if (maxLeft == 1 || isIndexJoin_)
    --- End diff --
    
    What happens in the case of joining a non-unique index to a base table? 
Would we want to have probe caches then?


> Trafci insert with parameters can insert a string which length is larger than 
>  the column's length.
> ---------------------------------------------------------------------------------------------------
>
>                 Key: TRAFODION-2719
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-2719
>             Project: Apache Trafodion
>          Issue Type: Bug
>    Affects Versions: 2.1-incubating
>            Reporter: Yang, Yongfeng
>            Assignee: Hans Zeller
>             Fix For: 2.3-incubating
>
>
> step to reproduce:
> create table c30(id char(30 chars) character set utf8 not null primary key);
> prepare s from insert into c30 values (?);
> execute s using '09573c16-4dc1-4ba8-bc68-26adb1db7998';
> -- case #3 in the table below, no warning, error, or truncation!



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)