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