MySQL Error MY-013229 – ER_SERVER_GTID_UNSAFE_CREATE_DROP_TEMP_TABLE_IN_TRX_IN_SBR

MySQL 13 Views 0 Min Read

MySQL Error Message

Statement violates GTID consistency: CREATE TEMPORARY
TABLE and DROP TEMPORARY TABLE are not allowed inside a
transaction or inside a procedure in a transactional context when
@@session.binlog_format=STATEMENT.

Reason for the Error

ER_SERVER_GTID_UNSAFE_CREATE_DROP_TEMP_TABLE_IN_TRX_IN_SBR
was added in 8.0.13.

Tags: