Comment 2 for bug 912795

Now fixed:

SET optimizer_switch = 'in_to_exists=on,semijoin=on,firstmatch=on,exists_to_in=on';
CREATE TABLE t1 ( a INT, b INT, c INT, KEY(a) ) ENGINE=MyISAM;
INSERT INTO t1 VALUES (9,1,1);
INSERT INTO t1 VALUES (3,2,2);
INSERT INTO t1 VALUES (2,3,3);
INSERT INTO t1 VALUES (5,4,4);
INSERT INTO t1 VALUES (3,5,5);
INSERT INTO t1 VALUES (1,6,6);
INSERT INTO t1 VALUES (3,7,7);
CREATE TABLE t2 ( d INT, KEY(d) );
INSERT INTO t2 VALUES (9),(7),(2);
CREATE ALGORITHM=MERGE VIEW v1 AS
SELECT * FROM t1, t2
WHERE b = d;
CREATE ALGORITHM=MERGE VIEW v2 AS
SELECT alias2.* FROM t1 AS alias1, t1 AS alias2
WHERE alias1.b = alias2.b AND alias2.a < 6;
SELECT * FROM v1, v2
WHERE v1.a = v2.a
AND EXISTS (
SELECT c FROM t1, t2
WHERE b = d
AND d = v2.c
);
a b c d a b c
3 7 7 7 3 2 2
3 2 2 2 3 2 2
3 7 7 7 3 7 7
3 2 2 2 3 7 7
drop view v1,v2;
drop table t1,t2;