db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mamta A. Satoor (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4365) NullPointerException when preparing LEFT OUTER JOIN between VALUES statements
Date Fri, 06 Nov 2009 15:10:32 GMT

    [ https://issues.apache.org/jira/browse/DERBY-4365?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12774306#action_12774306
] 

Mamta A. Satoor commented on DERBY-4365:
----------------------------------------

Knut, thanks for reviewing the patch. I have committed into trunk using revision 833430. The
commit comments were as follows

DERBY-4365

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. The changes through
this commit now checks for untyped nulls for joins. Added couple more tests (including where
a CAST of NULL values should work fine). 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.


Mime
View raw message