Prepared insert statement doesn't insert rows

#

# LP BUG#968720 crash due to converting to materialized and

# natural join made only once

#

SET @save968720_optimizer_switch=@@optimizer_switch;

SET optimizer_switch = 'derived_merge=on';

CREATE TABLE t1 (a int, INDEX(a));

INSERT INTO t1 VALUES (1);

CREATE TABLE t2 (a int, INDEX(a));

INSERT INTO t2 VALUES (1), (2);

INSERT INTO t1 SELECT a FROM (SELECT a FROM test.t1) AS s1 NATURAL JOIN

t2 AS s2;

SELECT * FROM t1;

a

1

1

DELETE FROM t1;

INSERT INTO t1 VALUES (1);

PREPARE stmt FROM "

INSERT INTO t1 SELECT a FROM (SELECT a FROM test.t1) AS s1 NATURAL JOIN

t2 AS s2;

";

EXECUTE stmt;

SELECT * FROM t1;

a

1

1

EXECUTE stmt;

SELECT * FROM t1;

a

1

1

drop table t1,t2;