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 Wed, 04 Nov 2009 06:54:32 GMT

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

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

I think the culprit here is the null value in values clause. A bit smaller repro is
select a.* from (values (null)) a 
    left outer join (values ('a')) b on 1=1; 


I tried without the left outer join
select a.* from (values (null)) a;
The above query actually gave an error
ERROR 42X07: Null is only allowed in a VALUES clause within an INSERT statement.

Maybe same error has to be thrown for the left outer join case since according to the above
error message, Null should not be allowed for our query since it is not an INSERT statement.

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