2nd execution of PS fails with ""Operation not permitted" from storage engine MEMORY"

CREATE TABLE t1 (pk int);

INSERT INTO t1 VALUES (1),(2),(3),(4),(5);

prepare stmt from "(((SELECT *  FROM t1 order by pk ) order by rand()) UNION (SELECT * FROM t1) );";

execute stmt;

execute stmt;

MariaDB [test]> prepare stmt from "(((SELECT *  FROM t1 order by pk ) order by rand()) UNION (SELECT * FROM t1) );";

Query OK, 0 rows affected (0.007 sec)

Statement prepared

MariaDB [test]> execute stmt;

+------+

| pk   |

+------+

|    1 |

|    2 |

|    3 |

|    4 |

|    5 |

+------+

5 rows in set (0.002 sec)

MariaDB [test]> execute stmt;

ERROR 1030 (HY000): Got error 1 "Operation not permitted" from storage engine MEMORY