db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jørgen Løland (JIRA) <j...@apache.org>
Subject [jira] Updated: (DERBY-3321) NullPointerException for 'NOT EXISTS' with nested subquery
Date Wed, 16 Jan 2008 10:48:34 GMT

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


Mime
View raw message