Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3, 10.4, 10.8.5, 10.5, 10.6, 10.7, 10.8, 10.9
-
None
Description
CREATE TABLE `t1` (
|
`c0` int(11) NOT NULL,
|
`c1` varchar(117) NOT NULL
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
INSERT INTO `t1` VALUES
|
(-1163295139, ''),
|
(114582533, ' '),
|
(-1545545040, '');
|
|
|
|
|
CREATE TABLE `t2` (
|
`c0` int(11) NOT NULL,
|
`c1` varchar(23) NOT NULL
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
CREATE TABLE `t3` (
|
`c0` int(11) NOT NULL,
|
`c1` varchar(79) NOT NULL
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
INSERT INTO `t3` VALUES
|
(1444867772, '8'),
|
(1042894530, '');
|
|
|
MariaDB > SELECT t2.c0
|
FROM t2 RIGHT OUTER JOIN t1 ON t1.c1 = t2.c1
|
RIGHT OUTER JOIN t3 ON t1.c1 = t3.c1;
|
|
|
+------+
|
| c0 |
|
+------+
|
| NULL |
|
| NULL |
|
| NULL |
|
| NULL |
|
+------+
|
4 rows in set (0.000 sec)
|
|
|
MariaDB > SET SESSION join_cache_level = 7;
|
|
|
MariaDB > SELECT t2.c0
|
FROM t2 RIGHT OUTER JOIN t1 ON t1.c1 = t2.c1
|
RIGHT OUTER JOIN t3 ON t1.c1 = t3.c1;
|
+------+
|
| c0 |
|
+------+
|
| NULL |
|
| NULL |
|
| NULL |
|
+------+
|
3 rows in set (0.001 sec)
|
|
|
MariaDB > SET optimizer_switch='join_cache_incremental=off';
|
|
|
MariaDB > SELECT t2.c0
|
FROM t2 RIGHT OUTER JOIN t1 ON t1.c1 = t2.c1
|
RIGHT OUTER JOIN t3 ON t1.c1 = t3.c1;
|
|
|
+------+
|
| c0 |
|
+------+
|
| NULL |
|
| NULL |
|
| NULL |
|
| NULL |
|
+------+
|
4 rows in set (0.000 sec)
|
|
|
|
|
|
|
|