Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Minor
-
Resolution: Unresolved
-
11.7.2
-
None
-
docker
Description
q1: SELECT * FROM TABLES CROSS JOIN VIEWS ON TRUE
q2: SELECT * FROM TABLES CROSS JOIN VIEWS ON NOT FALSE;
Since q1 is Semantically equivalent to q2, q1 EXCEPT q2 should always return an empty set and consume minimal execution time. However, the query returns a non-empty result (8670 rows in set ) and wastes some computation time (6.337 sec) compared to DBMSs without this bug.
MariaDB > use information_schema;
MariaDB [information_schema]> SELECT * FROM TABLES CROSS JOIN VIEWS ON TRUE EXCEPT SELECT * FROM TABLES CROSS JOIN VIEWS ON NOT FALSE;
...
8670 rows in set (6.337 sec)
Attachments
Issue Links
- relates to
-
MDEV-36673 The opposite WHERE clause intersects and is always an empty set.
-
- Confirmed
-