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