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