Debian Codegraph @

mysql-test/suite/binlog_nogtid/r/binlog_gtid_next_temporary_table.result

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