Test case that works against maria-5.3
SET SESSION join_cache_level = 4; SET SESSION optimizer_switch = 'outer_join_with_cache=on';
CREATE TABLE t2 (f4 varchar(1024), KEY (f4)) ; INSERT IGNORE INTO t2 VALUES ('xcddwntkbxyorzdv'),('cnxxcddwntkbxyor'),('r'),('r'),('did'),('I'),('when'),('hczkfqjeggivdvac'),('e'),('okay'),('up');
CREATE TABLE t4 (f1 int(11), f3 varchar(10)) ; INSERT IGNORE INTO t4 VALUES ('8','n'),('9','nwzcerzsgx'),('10','c');
CREATE TABLE t3 (f4 varchar(1024), f1 int(11), f2 int(11)) ; INSERT IGNORE INTO t3 VALUES ('f','4','0'),('n','5','-996540416');
CREATE TABLE t1 (f1 int(11), PRIMARY KEY (f1)) ; CREATE TABLE t5 (f5 int(11), KEY (f5)) ;
SELECT alias2.f2 FROM t2 AS alias1 LEFT JOIN t3 AS alias2 LEFT JOIN t4 AS alias3 LEFT JOIN t1 AS alias4 ON alias3.f1 = alias4.f1 JOIN t5 AS alias5 ON alias3.f3 ON alias2.f1 = alias5.f5 ON alias1.f4 = alias2.f4 WHERE alias2.f2 ;
Test case that works against maria-5.3
SET SESSION join_cache_level = 4; join_with_ cache=on' ;
SET SESSION optimizer_switch = 'outer_
CREATE TABLE t2 (f4 varchar(1024), KEY (f4)) ; zdv'),( 'cnxxcddwntkbxy or'),(' r'),('r' ),('did' ),('I') ,('when' ),('hczkfqjeggi vdvac') ,('e'), ('okay' ),('up' );
INSERT IGNORE INTO t2 VALUES ('xcddwntkbxyor
CREATE TABLE t4 (f1 int(11), f3 varchar(10)) ; ),('9', 'nwzcerzsgx' ),('10' ,'c');
INSERT IGNORE INTO t4 VALUES ('8','n'
CREATE TABLE t3 (f4 varchar(1024), f1 int(11), f2 int(11)) ; ,'0'),( 'n','5' ,'-996540416' );
INSERT IGNORE INTO t3 VALUES ('f','4'
CREATE TABLE t1 (f1 int(11), PRIMARY KEY (f1)) ;
CREATE TABLE t5 (f5 int(11), KEY (f5)) ;
SELECT alias2.f2
FROM t2 AS alias1
LEFT JOIN t3 AS alias2
LEFT JOIN t4 AS alias3
LEFT JOIN t1 AS alias4 ON alias3.f1 = alias4.f1
JOIN t5 AS alias5
ON alias3.f3 ON alias2.f1 = alias5.f5 ON alias1.f4 = alias2.f4
WHERE alias2.f2 ;