Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.11, 11.4, 11.8, 12.3, 12.1.2
-
Unexpected results
Description
CREATE TABLE b (id BIGINT); |
INSERT INTO b VALUES (1), (2); |
CREATE VIEW t AS SELECT * FROM b; |
 |
SELECT MIN(id) + id |
FROM t t1 |
WHERE t1.id >= ANY (SELECT t2.id FROM t t2) |
GROUP BY t1.id; |
-- Expected 2 rows (2), (4). Actual 0 rows. |
However, when selecting from the base table, the result is correct
SELECT MIN(id) + id |
FROM b t1 |
WHERE t1.id >= ANY (SELECT t2.id FROM t t2) |
GROUP BY t1.id; |
Attachments
Issue Links
- relates to
-
MDEV-40557 Window function + quantified (ANY/ALL) subquery predicate over a view returns missing rows
-
- Confirmed
-