SET @@GLOBAL.GTID_MODE=OFF_PERMISSIVE; CREATE TABLE t2 (c1 INT); set @@autocommit=0; CREATE TEMPORARY TABLE t1(a INT key); COMMIT; SET SESSION GTID_NEXT='AAAAAAAA-BBBB-CCCC-DDDD-EEEEEEEEEEEE:1'; INSERT INTO t2 VALUES(1); COMMIT; SET SESSION GTID_NEXT=AUTOMATIC; DROP TABLE t2; SET GLOBAL GTID_MODE=OFF; SET GLOBAL server_id= NEW_SERVER_ID; USE test; CREATE TABLE t1 SELECT 1 a; BINLOG ' MfmqTA8BAAAAZwAAAGsAAAABAAQANS41LjctbTMtZGVidWctbG9nAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAx+apMEzgNAAgAEgAEBAQEEgAAVAAEGggAAAAICAgCAA== '; DROP FUNCTION IF EXISTS inexistent_function; DROP TABLE t1; SET SESSION GTID_NEXT=DEFAULT; SET GLOBAL server_id = OLD_SERVER_ID; SET GLOBAL GTID_MODE=OFF;