Debian Codegraph @

mysql-test/suite/binlog/r/binlog_parallel_replication_marks_row.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 #Q> /* GTID */ INSERT INTO t1 VALUES (1,0)
43 # server id 1 end_log_pos # CRC32 0x######## Table_map: `test`.`t1` mapped to number #
44 # server id 1 end_log_pos # CRC32 0x######## Write_rows: table id # flags: STMT_END_F
45 COMMIT/*!*/;
46 # server id 1 end_log_pos # CRC32 0x######## GTID #-#-# trans thread_id=#
47 START TRANSACTION
48 #Q> /* GTID */ INSERT INTO t1 VALUES (2,0)
49 # server id 1 end_log_pos # CRC32 0x######## Table_map: `test`.`t1` mapped to number #
50 # server id 1 end_log_pos # CRC32 0x######## Write_rows: table id # flags: STMT_END_F
51 COMMIT/*!*/;
52 # server id 1 end_log_pos # CRC32 0x######## GTID #-#-# ddl thread_id=#
53 /* GTID */ ALTER TABLE t1 ADD c INT
54 # server id 1 end_log_pos # CRC32 0x######## GTID #-#-# trans thread_id=#
55 START TRANSACTION
56 #Q> /* GTID */ INSERT INTO t1 VALUES (3,0,0)
57 # server id 1 end_log_pos # CRC32 0x######## Table_map: `test`.`t1` mapped to number #
58 # server id 1 end_log_pos # CRC32 0x######## Write_rows: table id # flags: STMT_END_F
59 COMMIT/*!*/;
60 # server id 1 end_log_pos # CRC32 0x######## GTID #-#-# trans thread_id=#
61 START TRANSACTION
62 #Q> /* GTID */ UPDATE t1 SET b=1, c=1 WHERE a=2
63 # server id 1 end_log_pos # CRC32 0x######## Table_map: `test`.`t1` mapped to number #
64 # server id 1 end_log_pos # CRC32 0x######## Update_rows: table id # flags: STMT_END_F
65 #Q> /* GTID */ INSERT INTO t1 SELECT a, 2, b FROM t2
66 # server id 1 end_log_pos # CRC32 0x######## Table_map: `test`.`t1` mapped to number #
67 # server id 1 end_log_pos # CRC32 0x######## Write_rows: table id # flags: STMT_END_F
68 #Q> /* GTID */ INSERT INTO t1 VALUES (6, 3, 0)
69 # server id 1 end_log_pos # CRC32 0x######## Table_map: `test`.`t1` mapped to number #
70 # server id 1 end_log_pos # CRC32 0x######## Write_rows: table id # flags: STMT_END_F
71 COMMIT/*!*/;
72 # server id 1 end_log_pos # CRC32 0x######## GTID #-#-# trans thread_id=#
73 START TRANSACTION
74 #Q> /* GTID */ DELETE FROM t1 WHERE a=5
75 # server id 1 end_log_pos # CRC32 0x######## Table_map: `test`.`t1` mapped to number #
76 # server id 1 end_log_pos # CRC32 0x######## Delete_rows: table id # flags: STMT_END_F
77 #Q> /* GTID */ INSERT INTO t1 SELECT a, 4, 0 FROM t3
78 # server id 1 end_log_pos # CRC32 0x######## Table_map: `test`.`t1` mapped to number #
79 # server id 1 end_log_pos # CRC32 0x######## Write_rows: table id # flags: STMT_END_F
80 #Q> /* GTID */ UPDATE t1 SET c=1 WHERE a=7
81 # server id 1 end_log_pos # CRC32 0x######## Table_map: `test`.`t1` mapped to number #
82 # server id 1 end_log_pos # CRC32 0x######## Update_rows: table id # flags: STMT_END_F
83 COMMIT/*!*/;
84 # server id 1 end_log_pos # CRC32 0x######## GTID #-#-# trans thread_id=#
85 START TRANSACTION
86 #Q> /* GTID */ INSERT INTO t1 VALUES (8, 5, 0)
87 # server id 1 end_log_pos # CRC32 0x######## Table_map: `test`.`t1` mapped to number #
88 # server id 1 end_log_pos # CRC32 0x######## Write_rows: table id # flags: STMT_END_F
89 COMMIT/*!*/;
90 # server id 1 end_log_pos # CRC32 0x######## GTID #-#-# trans thread_id=#
91 START TRANSACTION
92 #Q> /* GTID */ INSERT INTO t1 VALUES (9, 5, 1)
93 # server id 1 end_log_pos # CRC32 0x######## Table_map: `test`.`t1` mapped to number #
94 # server id 1 end_log_pos # CRC32 0x######## Write_rows: table id # flags: STMT_END_F
95 COMMIT/*!*/;
96 # server id 1 end_log_pos # CRC32 0x######## GTID #-#-# trans thread_id=#
97 START TRANSACTION
98 #Q> /* GTID */ INSERT INTO t1 VALUES (10, 6, 0)
99 # server id 1 end_log_pos # CRC32 0x######## Table_map: `test`.`t1` mapped to number #
100 # server id 1 end_log_pos # CRC32 0x######## Write_rows: table id # flags: STMT_END_F
101 COMMIT/*!*/;
102 # server id 1 end_log_pos # CRC32 0x######## GTID #-#-# trans thread_id=#
103 START TRANSACTION
104 #Q> /* GTID */ INSERT INTO t1 VALUES (11, 7, 0)
105 # server id 1 end_log_pos # CRC32 0x######## Table_map: `test`.`t1` mapped to number #
106 # server id 1 end_log_pos # CRC32 0x######## Write_rows: table id # flags: STMT_END_F
107 COMMIT/*!*/;
108 DROP TABLE t1;