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.
