java.sql.SQLException: Statement violates GTID consistency: CREATE TEMPORARY TABLE 解决

开发反馈存储过程程序报错

报错信息：java.sql.SQLException: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions.

 

mysql5.7

官方解释：CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE statements are not supported inside transactions, procedures, functions, and triggers when using GTIDs (that is, when the enforce_gtid_consistency system variable is set to ON). It is possible to use these statements with GTIDs enabled, but only outside of any transaction, and only with autocommit=1.

 

测试发现客户端call可以成功，于是思考和jdbc的区别

解决：存储过程增加set @@autocommit=1;