INSERT ... SELECT with wrong result in derived_view.test

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;

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