MySQL 事务内创建/删除临时表报错，怎么解决？

示例代码：

START TRANSACTION;
DROP TEMPORARY TABLE IF EXISTS temp20200610;
ROLLBACK;

报错信息：

[HY000][1787] When @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1, the statements CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can be executed in a non-transactional context only, and require that AUTOCOMMIT = 1.

在示例代码中增加自动提交控制：

START TRANSACTION;
SET AUTOCOMMIT = 1;
# SET @@AUTOCOMMIT = 1;
# SET @@SESSION.AUTOCOMMIT = 1;
DROP TEMPORARY TABLE IF EXISTS temp20200610;
ROLLBACK;

执行后的报错信息依旧。

参考链接：

https://blog.youkuaiyun.com/hanbowu/article/details/82744699

https://blog.youkuaiyun.com/mingyundezuoan/article/details/78764443