[jira] [Resolved] (TRAFODION-3276) Fix regression caused by [TRAFODION-3270]

["David Wayne Birdsall (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TRAFODION-3276?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

David Wayne Birdsall resolved TRAFODION-3276.
---------------------------------------------
       Resolution: Fixed
    Fix Version/s: 2.4

> Fix regression caused by [TRAFODION-3270]
> -----------------------------------------
>
>                 Key: TRAFODION-3276
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-3276
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: sql-cmp
>    Affects Versions: 2.4
>            Reporter: David Wayne Birdsall
>            Assignee: David Wayne Birdsall
>            Priority: Major
>             Fix For: 2.4
>
>          Time Spent: 40m
>  Remaining Estimate: 0h
>
> The following script demonstrates the issue.
> {quote}drop table if exists t1 cascade;
> drop table if exists t2 cascade;
> create table t1 (
> t1_pk integer,
> t1_na integer
> );
> insert into t1 values (1,1),(2,null);
> create table t2 (
> t2_pk integer not null,
> t2_na integer,
> primary key (t2_pk)
> );
> insert into t2 values (2,null),(3,3);
> create table t3 (
> t3_pk integer not null,
> t3_na integer
> );
> insert into t3 values (2,null),(3,3);
> select t1_na, t2_pk from t1 left join t2 on t1_na = t2_pk and t1_na is null;
> select t1_na, t3_pk from t1 left join t3 on t1_na = t3_pk and t1_na is null;
> {quote}
>  
> When run, we see this failure. This failure is due to the fix in -TRAFODION-3270.-
> {quote}>>select t1_na, t2_pk from t1 left join t2 on t1_na = t2_pk and t1_na is null;
> *** ERROR[4099] A NULL operand is not allowed in predicate (TRAFODION.SEABASE.T2.T2_PK = NULL).
> *** ERROR[4099] A NULL operand is not allowed in predicate (TRAFODION.SEABASE.T2.T2_PK = NULL).
> *** ERROR[2006] Internal error: assertion failure (vdesc) in file ../optimizer/ValueDesc.cpp at line 118.
> *** ERROR[8822] The statement was not prepared.
> >>
> {quote}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)