Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
1.1.4, 1.1.5
-
None
-
2018-14, 2018-15, 2018-16
Description
The feature worked back in 1.3 and git bisect points to aa581b5dc3d88b4d0d07a224de4da5c96cf23aa3 (MCOL-1234)
Here are the steps to reproduce the issue:
MariaDB [test]> describe cs1
|
-> ;
|
+-------+------------+------+-----+---------+-------+
|
| Field | Type | Null | Key | Default | Extra |
|
+-------+------------+------+-----+---------+-------+
|
| t | varchar(2) | YES | | NULL | |
|
| i | int(11) | YES | | NULL | |
|
+-------+------------+------+-----+---------+-------+
|
2 rows in set (0.01 sec)
|
|
MariaDB [test]> describe cs2
|
-> ;
|
+-------+------------+------+-----+---------+-------+
|
| Field | Type | Null | Key | Default | Extra |
|
+-------+------------+------+-----+---------+-------+
|
| t | varchar(2) | YES | | NULL | |
|
| i | int(11) | YES | | NULL | |
|
+-------+------------+------+-----+---------+-------+
|
2 rows in set (0.00 sec)
|
|
MariaDB [test]> select * from cs1 inner join cs2 on (cs1.t = case cs2.t when NULL then 'MO' else cs2.t end);
|
ERROR 1815 (HY000): Internal error: IDB-1000: 'cs1' and 'cs2' are not joined.
|
WIth the commit previous to the above mentioned CS process the query just fine.
MariaDB [test]> select * from cs1 inner join cs2 on (cs1.t = case cs2.t when NULL then 'MO' else cs2.t end);
|
+------+------+------+------+
|
| t | i | t | i |
|
+------+------+------+------+
|
| SA | NULL | SA | NULL |
|
+------+------+------+------+
|
1 row in set (0.09 sec)
|
|