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

["ASF GitHub Bot (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TRAFODION-3276?focusedWorklogId=198300&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-198300 ]

ASF GitHub Bot logged work on TRAFODION-3276:
---------------------------------------------

                Author: ASF GitHub Bot
            Created on: 13/Feb/19 20:07
            Start Date: 13/Feb/19 20:07
    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
 
 
   In the fix for TRAFODION-3270, I did not take into account the possibility that a null value might be used as a key value in a primary key predicate. (Of course, such a value results in no rows, but nevertheless it is a valid predicate.)
   
   This change corrects the fix for TRAFODION-3270.
 
----------------------------------------------------------------
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:
users@infra.apache.org


Issue Time Tracking
-------------------

            Worklog Id:     (was: 198300)
            Time Spent: 10m
    Remaining Estimate: 0h

> 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: 10m
>  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)