[
https://issues.apache.org/jira/browse/DERBY-3321?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jørgen Løland updated DERBY-3321:
---------------------------------
Attachment: derby.log
Attached derby.log.
This issue also applies to 'exists', i.e. the same query without 'not'
> NullPointerException for 'NOT EXISTS' with nested subquery
> ----------------------------------------------------------
>
> Key: DERBY-3321
> URL: https://issues.apache.org/jira/browse/DERBY-3321
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.3.2.1, 10.4.0.0
> Reporter: Jørgen Løland
> Priority: Minor
> Attachments: derby.log
>
>
> Queries with 'not exists' followed by a nested subquery results in NPE:
> -----------8<--------------
> connect 'jdbc:derby:testdb;create=true';
> create table a (aa int, bb int);
> -- 0 rows inserted/updated/deleted
> create table b (bb int);
> -- 0 rows inserted/updated/deleted
> insert into a values (1, 1), (1, 2), (2, 2);
> -- 3 rows inserted/updated/deleted
> insert into b values (1);
> -- 1 row inserted/updated/deleted
> select * from a
> where not exists
> (select bb from b where a.bb=b.bb);
> -- AA |BB
> -- ----------------------
> -- 1 |2
> -- 2 |2
> select bb from (select bb from b) p;
> -- BB
> -- -----------
> -- 1
> select * from a
> where not exists
> (select bb from (select bb from b) p where a.bb=p.bb);
> -- ERROR XJ001: Java exception: ': java.lang.NullPointerException'.
> ------------>8----------------
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
