Details
-
Bug
-
Status: Stalled (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.4(EOL)
-
None
-
None
Description
Those SELECTs must return NULL but they return 0.
CREATE TABLE s (s INT);
|
INSERT INTO s VALUES(1);
|
 |
SELECT (SELECT NULL, NULL) IN (SELECT 1, 2 FROM s) FROM s;
|
0
|
CREATE TABLE u(a INT, b INT);
|
INSERT INTO u VALUES (NULL, NULL);
|
SELECT (SELECT * FROM u) IN (SELECT 1, 2 FROM s) FROM s;
|
0
|