Temporary tables can not be dropped inside stored procedure

[Philip Stoev]

One of the innodb MTR tests contains the following frequent programming idiom:

DELIMITER |

CREATE FUNCTION f1() RETURNS INT
BEGIN
CREATE TEMPORARY TABLE t1(c1 iNT AUTO_INCREMENT PRIMARY KEY) ENGINE=InnoDB;
INSERT INTO t1 VALUES(NULL);
DROP TEMPORARY TABLE t1;
 RETURN 42;
END |

DELIMITER ;

SELECT f1();

DROP FUNCTION f1;
DROP TEMPORARY TABLE IF EXISTS t1;

In stock InnoDB, this work because the temporary tables are handled separately (there is no implicit commit-on-ddl). In Galera, this results in "Deadlock found when trying to get lock; try restarting transaction" even though no concurrent transactions are running.