[
https://issues.apache.org/jira/browse/TRAFODION-3276?focusedWorklogId=198946&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-198946
]
ASF GitHub Bot logged work on TRAFODION-3276:
---------------------------------------------
Author: ASF GitHub Bot
Created on: 14/Feb/19 21:24
Start Date: 14/Feb/19 21:24
Worklog Time Spent: 10m
Work Description: DaveBirdsall commented on pull request #1797:
[TRAFODION-3276] Fix regression introduced by [TRAFODION-3270]
URL: https://github.com/apache/trafodion/pull/1797
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
Issue Time Tracking
-------------------
Worklog Id: (was: 198946)
Time Spent: 40m (was: 0.5h)
> 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
> 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)
