[
https://issues.apache.org/jira/browse/TRAFODION-2719?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16190435#comment-16190435
]
ASF GitHub Bot commented on TRAFODION-2719:
-------------------------------------------
Github user zellerh commented on a diff in the pull request:
https://github.com/apache/incubator-trafodion/pull/1254#discussion_r142535910
--- 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 --
The non-unique index contains one row for each base table row, and it
contains the clustering key of that row. So, there is still a 1:1 match between
the non-unique index and the base table/clustering index, and a probe cache
would not have any cache hits.
> 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)
