1RESET MASTER; 2CREATE TABLE t1 (a INT PRIMARY KEY, b INT) ENGINE=InnoDB; 3/* GTID */ INSERT INTO t1 VALUES (1,0); 4/* GTID */ BEGIN; 5/* GTID */ INSERT INTO t1 VALUES (2,0); 6/* GTID */ ALTER TABLE t1 ADD c INT; 7/* GTID */ INSERT INTO t1 VALUES (3,0,0); 8/* GTID */ COMMIT; 9/* GTID */ BEGIN; 10/* GTID */ UPDATE t1 SET b=1, c=1 WHERE a=2; 11/* GTID */ CREATE TEMPORARY TABLE t2 (a INT PRIMARY KEY, b INT) ENGINE=InnoDB; 12/* GTID */ INSERT INTO t2 VALUES (4,10), (5,20); 13/* GTID */ INSERT INTO t1 SELECT a, 2, b FROM t2; 14/* GTID */ DROP TEMPORARY TABLE t2; 15/* GTID */ INSERT INTO t1 VALUES (6, 3, 0); 16/* GTID */ COMMIT; 17/* GTID */ CREATE TEMPORARY TABLE t3 (a INT PRIMARY KEY) ENGINE=InnoDB; 18/* GTID */ BEGIN; 19/* GTID */ DELETE FROM t1 WHERE a=5; 20/* GTID */ INSERT INTO t3 VALUES (7); 21/* GTID */ INSERT INTO t1 SELECT a, 4, 0 FROM t3; 22/* GTID */ UPDATE t1 SET c=1 WHERE a=7; 23/* GTID */ DROP TEMPORARY TABLE t3; 24/* GTID */ COMMIT; 25/* GTID */ CREATE TEMPORARY TABLE t4 (a INT PRIMARY KEY) ENGINE=InnoDB; 26/* GTID */ BEGIN; 27/* GTID */ INSERT INTO t1 VALUES (8, 5, 0); 28/* GTID */ ALTER TABLE t4 ADD b INT; 29/* GTID */ INSERT INTO t1 VALUES (9, 5, 1); 30/* GTID */ COMMIT; 31connect tmp_con,localhost,root,,; 32/* GTID */ INSERT INTO t1 VALUES (10, 6, 0); 33/* GTID */ BEGIN; 34/* GTID */ CREATE TEMPORARY TABLE t5 (a INT PRIMARY KEY) ENGINE=InnoDB; 35/* GTID */ INSERT INTO t1 VALUES (11, 7, 0); 36/* GTID */ COMMIT; 37disconnect tmp_con; 38connection default; 39FLUSH LOGS; 40# server id 1 end_log_pos # CRC32 0x######## GTID #-#-# trans 41START TRANSACTION 42/* GTID */ INSERT INTO t1 VALUES (1,0) 43COMMIT/*!*/; 44# server id 1 end_log_pos # CRC32 0x######## GTID #-#-# trans 45START TRANSACTION 46/* GTID */ INSERT INTO t1 VALUES (2,0) 47COMMIT/*!*/; 48# server id 1 end_log_pos # CRC32 0x######## GTID #-#-# ddl 49/* GTID */ ALTER TABLE t1 ADD c INT 50# server id 1 end_log_pos # CRC32 0x######## GTID #-#-# trans 51START TRANSACTION 52/* GTID */ INSERT INTO t1 VALUES (3,0,0) 53COMMIT/*!*/; 54# server id 1 end_log_pos # CRC32 0x######## GTID #-#-# ddl 55START TRANSACTION 56/* GTID */ UPDATE t1 SET b=1, c=1 WHERE a=2 57/* GTID */ CREATE TEMPORARY TABLE t2 (a INT PRIMARY KEY, b INT) ENGINE=InnoDB 58/* GTID */ INSERT INTO t2 VALUES (4,10), (5,20) 59/* GTID */ INSERT INTO t1 SELECT a, 2, b FROM t2 60DROP TEMPORARY TABLE `t2` /* generated by server */ 61/* GTID */ INSERT INTO t1 VALUES (6, 3, 0) 62COMMIT/*!*/; 63# server id 1 end_log_pos # CRC32 0x######## GTID #-#-# ddl 64/* GTID */ CREATE TEMPORARY TABLE t3 (a INT PRIMARY KEY) ENGINE=InnoDB 65# server id 1 end_log_pos # CRC32 0x######## GTID #-#-# ddl 66START TRANSACTION 67/* GTID */ DELETE FROM t1 WHERE a=5 68/* GTID */ INSERT INTO t3 VALUES (7) 69/* GTID */ INSERT INTO t1 SELECT a, 4, 0 FROM t3 70/* GTID */ UPDATE t1 SET c=1 WHERE a=7 71DROP TEMPORARY TABLE `t3` /* generated by server */ 72COMMIT/*!*/; 73# server id 1 end_log_pos # CRC32 0x######## GTID #-#-# ddl 74/* GTID */ CREATE TEMPORARY TABLE t4 (a INT PRIMARY KEY) ENGINE=InnoDB 75# server id 1 end_log_pos # CRC32 0x######## GTID #-#-# trans 76START TRANSACTION 77/* GTID */ INSERT INTO t1 VALUES (8, 5, 0) 78COMMIT/*!*/; 79# server id 1 end_log_pos # CRC32 0x######## GTID #-#-# ddl 80/* GTID */ ALTER TABLE t4 ADD b INT 81# server id 1 end_log_pos # CRC32 0x######## GTID #-#-# trans 82START TRANSACTION 83/* GTID */ INSERT INTO t1 VALUES (9, 5, 1) 84COMMIT/*!*/; 85# server id 1 end_log_pos # CRC32 0x######## GTID #-#-# trans 86START TRANSACTION 87/* GTID */ INSERT INTO t1 VALUES (10, 6, 0) 88COMMIT/*!*/; 89# server id 1 end_log_pos # CRC32 0x######## GTID #-#-# ddl 90START TRANSACTION 91/* GTID */ CREATE TEMPORARY TABLE t5 (a INT PRIMARY KEY) ENGINE=InnoDB 92/* GTID */ INSERT INTO t1 VALUES (11, 7, 0) 93COMMIT/*!*/; 94# server id 1 end_log_pos # CRC32 0x######## GTID #-#-# ddl 95DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `t5` 96DROP TABLE t1; 97