Wrong result (extra rows) on 2nd execution of PS with exists_to_in, MERGE view

CREATE TABLE t1 (a VARCHAR(3)) ENGINE=MyISAM;

INSERT INTO t1 VALUES ('foo'),('bar');

CREATE TABLE t2 (i INT, b VARCHAR(3)) ENGINE=MyISAM;

CREATE ALGORITHM=MERGE VIEW v2 AS SELECT * FROM t2;

INSERT INTO t2 VALUES (4,'foo'),(5,'baz');

PREPARE stmt FROM "SELECT * FROM t1 WHERE NOT EXISTS ( SELECT i FROM v2 WHERE b = a )";

EXECUTE stmt;

EXECUTE stmt;

EXECUTE stmt;

a

bar

EXECUTE stmt;

a

foo

bar

EXECUTE stmt;

a

bar

EXECUTE stmt;

a

bar

revision-id: knielsen@knielsen-hq.org-20140902120701-txesdmkczel84qgf

revno: 4369

branch-nick: 10.0