Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.4.5, 5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL)
-
MariaDB Docker (Bionic) on Ubuntu Linux 18.04
Description
Summary: The following query returns an entry ('1'), even if there is no matching columns.
CREATE SCHEMA A ; |
CREATE TABLE A.B ( C SMALLINT) ; |
INSERT INTO A.B VALUES (2); |
CREATE TABLE A.D ( E SMALLINT) ; |
SELECT 1 FROM (A.B LEFT OUTER JOIN (SELECT 2 AS G FROM A.D) I ON TRUE ) WHERE B.C = I.G ; |
I expect that an empty result set is returned because no query matches the given Condition. Postgres 11 doesn't return anything, which is correct.
MySQL 8.0.16 is also affected, I'm not sure about other mariadb or mysql versions.
Attachments
Issue Links
- relates to
-
MDEV-6892 WHERE does not apply
- Closed