| 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; |