24 lines
687 B
Plaintext
24 lines
687 B
Plaintext
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;
|