1RESET MASTER; 2CREATE TABLE t1 (c1 INT); 3SET @@GLOBAL.GTID_MODE = OFF_PERMISSIVE; 4SET SESSION autocommit = 0; 5CREATE TEMPORARY TABLE Temp1 SELECT RAND(); 6SET SESSION GTID_NEXT = '11111111-AAAA-2222-BBBB-000000000000:1'; 7ERROR HY000: The system variable gtid_next cannot be set when there is an ongoing transaction. 8COMMIT; 9CREATE TEMPORARY TABLE Temp2(c1 INT); 10SET SESSION GTID_NEXT = '11111111-AAAA-2222-BBBB-000000000000:2'; 11ERROR HY000: The system variable gtid_next cannot be set when there is an ongoing transaction. 12COMMIT; 13CREATE TEMPORARY TABLE Temp3 LIKE Temp2; 14SET SESSION GTID_NEXT = '11111111-AAAA-2222-BBBB-000000000000:3'; 15ERROR HY000: The system variable gtid_next cannot be set when there is an ongoing transaction. 16COMMIT; 17SET SESSION GTID_NEXT = '11111111-AAAA-2222-BBBB-000000000000:4'; 18DROP TABLE t1; 19SET SESSION GTID_NEXT = 'automatic'; 20DROP TEMPORARY TABLE Temp1,Temp2,Temp3; 21SET SESSION GTID_NEXT='11111111-AAAA-2222-BBBB-000000000000:5'; 22ERROR HY000: The system variable gtid_next cannot be set when there is an ongoing transaction. 23COMMIT; 24SET SESSION autocommit = 1; 25SET @@GLOBAL.GTID_MODE = OFF; 26