Issue Details (XML | Word | Printable)

Key: DERBY-3321
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Minor Minor
Assignee: Thomas Nielsen
Reporter: Jørgen Løland
Votes: 1
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Derby

NullPointerException for 'NOT EXISTS' with nested subquery

Created: 16/Jan/08 10:42 AM   Updated: 25/Apr/08 09:07 PM
Return to search
Component/s: SQL
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

Time Tracking:
Not Specified

File Attachments:
  Size
File Licensed for inclusion in ASF works d3321.diff 2008-03-05 12:52 PM Thomas Nielsen 3 kB
File Licensed for inclusion in ASF works d3321.stat 2008-03-05 12:52 PM Thomas Nielsen 0.2 kB
Text File derby.log 2008-01-16 10:47 AM Jørgen Løland 3 kB
Environment: Committed revision 651700 to 10.3
Issue Links:
Reference
 

Resolution Date: 06/Mar/08 04:51 PM


 Description  « Hide
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----------------

 All   Comments   Work Log   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Jørgen Løland made changes - 16/Jan/08 10:47 AM
Field Original Value New Value
Attachment derby.log [ 12373258 ]
Jørgen Løland made changes - 18/Jan/08 08:06 AM
Link This issue relates to DERBY-3301 [ DERBY-3301 ]
Kathey Marsden made changes - 13/Feb/08 10:27 PM
Affects Version/s 10.0.2.1 [ 10991 ]
Affects Version/s 10.2.2.0 [ 12312027 ]
Affects Version/s 10.1.3.1 [ 12311953 ]
Thomas Nielsen made changes - 05/Mar/08 12:47 PM
Assignee Thomas Nielsen [ thomanie ]
Thomas Nielsen made changes - 05/Mar/08 12:52 PM
Attachment d3321.stat [ 12377165 ]
Attachment d3321.diff [ 12377164 ]
Thomas Nielsen made changes - 05/Mar/08 07:48 PM
Derby Info [Patch Available]
Dyre Tjeldvoll made changes - 06/Mar/08 03:52 PM
Derby Info [Patch Available]
Thomas Nielsen made changes - 06/Mar/08 04:51 PM
Resolution Fixed [ 1 ]
Fix Version/s 10.4.0.0 [ 12312540 ]
Status Open [ 1 ] Resolved [ 5 ]
Jørgen Løland made changes - 13/Mar/08 07:59 AM
Status Resolved [ 5 ] Closed [ 6 ]
Kathey Marsden made changes - 25/Apr/08 09:07 PM
Environment Committed revision 651700 to 10.3
Fix Version/s 10.3.2.2 [ 12312885 ]