Repeatable with maria-5.3 . Not repeatable with maria-5.3-mwl89
simplified test case:
SET SESSION optimizer_switch = 'partial_match_rowid_merge=off,partial_match_table_scan=off,semijoin=off,subquery_cache=off';
CREATE TABLE t1 ( f1 int(11), f2 varchar(1));
CREATE TABLE t2 ( f3 varchar(1));
CREATE VIEW v2 AS SELECT * FROM t2;
PREPARE st1 FROM "SELECT * FROM t1 JOIN v2 ON t1.f2 WHERE v2.f3 IN ( SELECT f2 FROM t1 ) ";
EXECUTE st1; EXECUTE st1;
Repeatable with maria-5.3 . Not repeatable with maria-5.3-mwl89
simplified test case:
SET SESSION optimizer_switch = 'partial_ match_rowid_ merge=off, partial_ match_table_ scan=off, semijoin= off,subquery_ cache=off' ;
CREATE TABLE t1 ( f1 int(11), f2 varchar(1));
CREATE TABLE t2 ( f3 varchar(1));
CREATE VIEW v2 AS SELECT * FROM t2;
PREPARE st1 FROM "SELECT *
FROM t1 JOIN v2 ON t1.f2
WHERE v2.f3 IN (
SELECT f2
FROM t1 ) ";
EXECUTE st1;
EXECUTE st1;