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