Debian Codegraph @

mysql-test/suite/binlog/r/binlog_parallel_replication_marks_stm_mix.result

raw
1 RESET MASTER;
2 CREATE 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;
31 connect 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;
37 disconnect tmp_con;
38 connection default;
39 FLUSH LOGS;
40 # server id 1 end_log_pos # CRC32 0x######## GTID #-#-# trans thread_id=#
41 START TRANSACTION
42 /* GTID */ INSERT INTO t1 VALUES (1,0)
43 COMMIT/*!*/;
44 # server id 1 end_log_pos # CRC32 0x######## GTID #-#-# trans thread_id=#
45 START TRANSACTION
46 /* GTID */ INSERT INTO t1 VALUES (2,0)
47 COMMIT/*!*/;
48 # server id 1 end_log_pos # CRC32 0x######## GTID #-#-# ddl thread_id=#
49 /* GTID */ ALTER TABLE t1 ADD c INT
50 # server id 1 end_log_pos # CRC32 0x######## GTID #-#-# trans thread_id=#
51 START TRANSACTION
52 /* GTID */ INSERT INTO t1 VALUES (3,0,0)
53 COMMIT/*!*/;
54 # server id 1 end_log_pos # CRC32 0x######## GTID #-#-# ddl thread_id=#
55 START 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
60 DROP TEMPORARY TABLE `t2` /* generated by server */
61 /* GTID */ INSERT INTO t1 VALUES (6, 3, 0)
62 COMMIT/*!*/;
63 # server id 1 end_log_pos # CRC32 0x######## GTID #-#-# ddl thread_id=#
64 /* GTID */ CREATE TEMPORARY TABLE t3 (a INT PRIMARY KEY) ENGINE=InnoDB
65 # server id 1 end_log_pos # CRC32 0x######## GTID #-#-# ddl thread_id=#
66 START 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
71 DROP TEMPORARY TABLE `t3` /* generated by server */
72 COMMIT/*!*/;
73 # server id 1 end_log_pos # CRC32 0x######## GTID #-#-# ddl thread_id=#
74 /* GTID */ CREATE TEMPORARY TABLE t4 (a INT PRIMARY KEY) ENGINE=InnoDB
75 # server id 1 end_log_pos # CRC32 0x######## GTID #-#-# trans thread_id=#
76 START TRANSACTION
77 /* GTID */ INSERT INTO t1 VALUES (8, 5, 0)
78 COMMIT/*!*/;
79 # server id 1 end_log_pos # CRC32 0x######## GTID #-#-# ddl thread_id=#
80 /* GTID */ ALTER TABLE t4 ADD b INT
81 # server id 1 end_log_pos # CRC32 0x######## GTID #-#-# trans thread_id=#
82 START TRANSACTION
83 /* GTID */ INSERT INTO t1 VALUES (9, 5, 1)
84 COMMIT/*!*/;
85 # server id 1 end_log_pos # CRC32 0x######## GTID #-#-# trans thread_id=#
86 START TRANSACTION
87 /* GTID */ INSERT INTO t1 VALUES (10, 6, 0)
88 COMMIT/*!*/;
89 # server id 1 end_log_pos # CRC32 0x######## GTID #-#-# ddl thread_id=#
90 START TRANSACTION
91 /* GTID */ CREATE TEMPORARY TABLE t5 (a INT PRIMARY KEY) ENGINE=InnoDB
92 /* GTID */ INSERT INTO t1 VALUES (11, 7, 0)
93 COMMIT/*!*/;
94 # server id 1 end_log_pos # CRC32 0x######## GTID #-#-# ddl thread_id=#
95 DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `t5`
96 DROP TABLE t1;