[DERBY-3321] NullPointerException for 'NOT EXISTS' with nested subquery

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.0.2.1, 10.1.3.1, 10.2.2.0, 10.3.2.1, 10.4.1.3
• Fix Version/s: 10.3.3.0, 10.4.1.3
• Component/s: SQL
• Environment: Committed revision 651700 to 10.3
• Assignee: Thomas Nielsen
• Reporter: Jorgen Loland
• Created: 16/Jan/08 10:42
• Updated: 25/Apr/08 21:07
• Resolved: 06/Mar/08 16:51

Description

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

Issue Links

• relates to: DERBY-3301 Incorrect result from query with nested EXIST