示例代码:
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.csdn.net/hanbowu/article/details/82744699
https://blog.csdn.net/mingyundezuoan/article/details/78764443