[jira] Updated: (DERBY-4365) NullPointerException when preparing LEFT OUTER JOIN between VALUES statements

["Mamta A. Satoor (JIRA)" <ji...@apache.org>]

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

Mamta A. Satoor updated DERBY-4365:
-----------------------------------

    Attachment: DERBY4365_NULLinValues_stat_patch1.txt
                DERBY4365_NULLinValues_diff_patch1.txt

I have a patch which I am ready to commit if noone has any objection to it. Basically, for some reason, for JOIN, we were doing a no-op in the method bindUntypedNullsToResultColumns(ResultColumnList) rather than checking for untyped nulls for the left and right resultsets. I have made changes so that check is made. I have added couple more tests (including the one provided by Knut, where a CAST of NULL values should work fine). I will plan on committing the patch tomorrow if there is no feedback. The derbyall and junit suites ran fine with the exception of known intermittent (DERBY-3757) 'ASSERT FAILED transaction table has null entry when running new StressMultiTest

> NullPointerException when preparing LEFT OUTER JOIN between VALUES statements
> -----------------------------------------------------------------------------
>
>                 Key: DERBY-4365
>                 URL: https://issues.apache.org/jira/browse/DERBY-4365
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.5.3.0
>            Reporter: Knut Anders Hatlen
>            Assignee: Mamta A. Satoor
>         Attachments: DERBY4365_NULLinValues_diff_patch1.txt, DERBY4365_NULLinValues_stat_patch1.txt
>
>
> ij version 10.5
> ij> connect 'jdbc:derby:db;create=true';
> ij> select a.* from (values ('a'),('b'),(null)) a
>     left outer join (values ('c'),('d')) b on 1=1;
> ERROR XJ001: Java exception: ': java.lang.NullPointerException'.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.