[jira] [Created] (DERBY-6408) EXISTS returns NULL instead of FALSE

[Knut Anders Hatlen (JIRA)]

Knut Anders Hatlen created DERBY-6408:
-----------------------------------------

             Summary: EXISTS returns NULL instead of FALSE
                 Key: DERBY-6408
                 URL: https://issues.apache.org/jira/browse/DERBY-6408
             Project: Derby
          Issue Type: Bug
          Components: SQL
    Affects Versions: 10.10.1.1
            Reporter: Knut Anders Hatlen


The reference manual topic on Boolean expressions - 
http://db.apache.org/derby/docs/10.10/ref/rrefsqlj23075.html - says that EXISTS 
should return FALSE if the subquery returns no rows. In reality, it returns 
NULL:

ij> create table t(x int);
0 rows inserted/updated/deleted
ij> values exists(select * from t);
1    
-----
NULL 

1 row selected

SQL:2011, part 2, 8.10 <exists predicate> also says that FALSE is the correct 
result if the cardinality is 0.



--
This message was sent by Atlassian JIRA
(v6.1#6144)