db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bernt M. Johnsen (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-4385) Comparision with ALL (subquery) may give wrong result if constant is selected
Date Tue, 22 Sep 2009 14:56:16 GMT
Comparision with ALL (subquery) may give wrong result if constant is selected
-----------------------------------------------------------------------------

                 Key: DERBY-4385
                 URL: https://issues.apache.org/jira/browse/DERBY-4385
             Project: Derby
          Issue Type: Bug
            Reporter: Bernt M. Johnsen
            Priority: Critical


Consider the following:

CREATE TABLE t1 (i INT PRIMARY KEY, j INT);
CREATE TABLE t2 (i INT);
INSERT INTO t1 VALUES (1,1),(2,2);
INSERT INTO t2 VALUES (81);

The two following queries should give the same result:

SELECT * FROM t1 WHERE i < ALL (SELECT i FROM t2);
SELECT * FROM t1 WHERE i < ALL (SELECT 81 FROM t2);


But, they don't:


ij> SELECT * FROM t1 WHERE i < ALL (SELECT i FROM t2);
I          |J          
-----------------------
1          |1          
2          |2          

2 rows selected
ij> SELECT * FROM t1 WHERE i < ALL (SELECT 81 FROM t2);
I          |J          
-----------------------

0 rows selected
ij> 


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