Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.2(EOL)
-
10.2.4-2
Description
CREATE TABLE t1 (a INT); |
INSERT INTO t1 VALUES (0),(2); |
|
CREATE TABLE t2 (b INT); |
INSERT INTO t2 VALUES (1),(2); |
|
CREATE OR REPLACE ALGORITHM=TEMPTABLE VIEW v2 AS SELECT * FROM t2; |
|
SELECT * FROM t1 LEFT JOIN v2 ON a = b WHERE b IS NULL; |
Actual result, 10.2 82b974a1b6 |
MariaDB [test]> SELECT * FROM t1 LEFT JOIN v2 ON a = b WHERE b IS NULL;
|
+------+------+
|
| a | b |
|
+------+------+
|
| 0 | NULL |
|
| 2 | NULL |
|
+------+------+
|
2 rows in set (0.00 sec)
|
Expected result |
MariaDB [test]> SELECT * FROM t1 LEFT JOIN v2 ON a = b WHERE b IS NULL;
|
+------+------+
|
| a | b |
|
+------+------+
|
| 0 | NULL |
|
+------+------+
|
1 row in set (0.00 sec)
|