Debian Codegraph @

mysql-test/suite/atomic/rename_table_binlog.result

raw
1 RESET MASTER;
2 "engine: myisam crash point: ddl_log_rename_before_binlog position: 1"
3 "engine: myisam crash point: ddl_log_rename_after_binlog position: 1"
4 "engine: aria crash point: ddl_log_rename_before_binlog position: 1"
5 "engine: aria crash point: ddl_log_rename_after_binlog position: 1"
6 include/show_binlog_events.inc
7 Log_name Pos Event_type Server_id End_log_pos Info
8 master-bin.000002 # Gtid # # BEGIN GTID #-#-#
9 master-bin.000002 # Query # # use `test`; insert into t1 values(null)
10 master-bin.000002 # Query # # COMMIT
11 master-bin.000002 # Gtid # # BEGIN GTID #-#-#
12 master-bin.000002 # Query # # use `test`; insert into t2 values(null)
13 master-bin.000002 # Query # # COMMIT
14 master-bin.000002 # Gtid # # BEGIN GTID #-#-#
15 master-bin.000002 # Query # # use `test`; insert into t3 values(null)
16 master-bin.000002 # Query # # COMMIT
17 master-bin.000002 # Gtid # # BEGIN GTID #-#-#
18 master-bin.000002 # Query # # use `test`; insert into t4 values(null)
19 master-bin.000002 # Query # # COMMIT
20 master-bin.000002 # Gtid # # BEGIN GTID #-#-#
21 master-bin.000002 # Query # # use `test`; delete from t1 where a > 100
22 master-bin.000002 # Query # # COMMIT
23 master-bin.000002 # Gtid # # BEGIN GTID #-#-#
24 master-bin.000002 # Query # # use `test`; delete from t2 where b > 100
25 master-bin.000002 # Query # # COMMIT
26 master-bin.000002 # Gtid # # BEGIN GTID #-#-#
27 master-bin.000002 # Query # # use `test`; delete from t3 where c > 100
28 master-bin.000002 # Query # # COMMIT
29 master-bin.000002 # Gtid # # BEGIN GTID #-#-#
30 master-bin.000002 # Query # # use `test`; delete from t4 where d > 100
31 master-bin.000002 # Query # # COMMIT
32 master-bin.000002 # Gtid # # GTID #-#-#
33 master-bin.000002 # Query # # use `test`; flush tables
34 master-bin.000002 # Gtid # # GTID #-#-#
35 master-bin.000002 # Query # # use `test`; rename table t1 to t5, t2 to t1, t5 to t2, t4 to t5, t3 to t4
36 include/show_binlog_events.inc
37 Log_name Pos Event_type Server_id End_log_pos Info
38 master-bin.000003 # Gtid # # BEGIN GTID #-#-#
39 master-bin.000003 # Query # # use `test`; insert into t1 values(null)
40 master-bin.000003 # Query # # COMMIT
41 master-bin.000003 # Gtid # # BEGIN GTID #-#-#
42 master-bin.000003 # Query # # use `test`; insert into t2 values(null)
43 master-bin.000003 # Query # # COMMIT
44 master-bin.000003 # Gtid # # BEGIN GTID #-#-#
45 master-bin.000003 # Query # # use `test`; insert into t5 values(null)
46 master-bin.000003 # Query # # COMMIT
47 master-bin.000003 # Gtid # # BEGIN GTID #-#-#
48 master-bin.000003 # Query # # use `test`; insert into t4 values(null)
49 master-bin.000003 # Query # # COMMIT
50 master-bin.000003 # Gtid # # GTID #-#-#
51 master-bin.000003 # Query # # use `test`; DROP TABLE `t1`,`t2`,`t4`,`t5` /* generated by server */
52 master-bin.000003 # Gtid # # GTID #-#-#
53 master-bin.000003 # Query # # use `test`; create table t1 (a int not null) transactional=1
54 master-bin.000003 # Gtid # # GTID #-#-#
55 master-bin.000003 # Query # # use `test`; create table t2 (b int not null) transactional=1
56 master-bin.000003 # Gtid # # GTID #-#-#
57 master-bin.000003 # Query # # use `test`; create table t3 (c int not null) transactional=1
58 master-bin.000003 # Gtid # # GTID #-#-#
59 master-bin.000003 # Query # # use `test`; create table t4 (d int not null) transactional=1
60 master-bin.000003 # Gtid # # BEGIN GTID #-#-#
61 master-bin.000003 # Query # # use `test`; insert into t1 values(1)
62 master-bin.000003 # Query # # COMMIT
63 master-bin.000003 # Gtid # # BEGIN GTID #-#-#
64 master-bin.000003 # Query # # use `test`; insert into t2 values(2)
65 master-bin.000003 # Query # # COMMIT
66 master-bin.000003 # Gtid # # BEGIN GTID #-#-#
67 master-bin.000003 # Query # # use `test`; insert into t3 values(3)
68 master-bin.000003 # Query # # COMMIT
69 master-bin.000003 # Gtid # # BEGIN GTID #-#-#
70 master-bin.000003 # Query # # use `test`; insert into t4 values(4)
71 master-bin.000003 # Query # # COMMIT
72 master-bin.000003 # Gtid # # GTID #-#-#
73 master-bin.000003 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` trigger t1_trg before insert on t1 for each row
74 begin
75 if isnull(new.a) then
76 set new.a:= 1000;
77 end if;
78 end
79 master-bin.000003 # Gtid # # GTID #-#-#
80 master-bin.000003 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` trigger t2_trg before insert on t2 for each row
81 begin
82 if isnull(new.b) then
83 set new.b:= 2000;
84 end if;
85 end
86 master-bin.000003 # Gtid # # GTID #-#-#
87 master-bin.000003 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` trigger t3_trg before insert on t3 for each row
88 begin
89 if isnull(new.c) then
90 set new.c:= 4000;
91 end if;
92 end
93 master-bin.000003 # Gtid # # GTID #-#-#
94 master-bin.000003 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` trigger t4_trg before insert on t4 for each row
95 begin
96 if isnull(new.d) then
97 set new.d:= 8000;
98 end if;
99 end
100 master-bin.000003 # Gtid # # GTID #-#-#
101 master-bin.000003 # Query # # use `test`; flush tables
102 include/show_binlog_events.inc
103 Log_name Pos Event_type Server_id End_log_pos Info
104 master-bin.000004 # Gtid # # BEGIN GTID #-#-#
105 master-bin.000004 # Query # # use `test`; insert into t1 values(null)
106 master-bin.000004 # Query # # COMMIT
107 master-bin.000004 # Gtid # # BEGIN GTID #-#-#
108 master-bin.000004 # Query # # use `test`; insert into t2 values(null)
109 master-bin.000004 # Query # # COMMIT
110 master-bin.000004 # Gtid # # BEGIN GTID #-#-#
111 master-bin.000004 # Query # # use `test`; insert into t3 values(null)
112 master-bin.000004 # Query # # COMMIT
113 master-bin.000004 # Gtid # # BEGIN GTID #-#-#
114 master-bin.000004 # Query # # use `test`; insert into t4 values(null)
115 master-bin.000004 # Query # # COMMIT
116 master-bin.000004 # Gtid # # BEGIN GTID #-#-#
117 master-bin.000004 # Query # # use `test`; delete from t1 where a > 100
118 master-bin.000004 # Query # # COMMIT
119 master-bin.000004 # Gtid # # BEGIN GTID #-#-#
120 master-bin.000004 # Query # # use `test`; delete from t2 where b > 100
121 master-bin.000004 # Query # # COMMIT
122 master-bin.000004 # Gtid # # BEGIN GTID #-#-#
123 master-bin.000004 # Query # # use `test`; delete from t3 where c > 100
124 master-bin.000004 # Query # # COMMIT
125 master-bin.000004 # Gtid # # BEGIN GTID #-#-#
126 master-bin.000004 # Query # # use `test`; delete from t4 where d > 100
127 master-bin.000004 # Query # # COMMIT
128 master-bin.000004 # Gtid # # GTID #-#-#
129 master-bin.000004 # Query # # use `test`; flush tables
130 master-bin.000004 # Gtid # # GTID #-#-#
131 master-bin.000004 # Query # # use `test`; rename table t1 to t5, t2 to t1, t5 to t2, t4 to t5, t3 to t4
132 include/show_binlog_events.inc
133 Log_name Pos Event_type Server_id End_log_pos Info
134 master-bin.000005 # Gtid # # BEGIN GTID #-#-#
135 master-bin.000005 # Query # # use `test`; insert into t1 values(null)
136 master-bin.000005 # Query # # COMMIT
137 master-bin.000005 # Gtid # # BEGIN GTID #-#-#
138 master-bin.000005 # Query # # use `test`; insert into t2 values(null)
139 master-bin.000005 # Query # # COMMIT
140 master-bin.000005 # Gtid # # BEGIN GTID #-#-#
141 master-bin.000005 # Query # # use `test`; insert into t5 values(null)
142 master-bin.000005 # Query # # COMMIT
143 master-bin.000005 # Gtid # # BEGIN GTID #-#-#
144 master-bin.000005 # Query # # use `test`; insert into t4 values(null)
145 master-bin.000005 # Query # # COMMIT
146 master-bin.000005 # Gtid # # GTID #-#-#
147 master-bin.000005 # Query # # use `test`; DROP TABLE `t1`,`t2`,`t4`,`t5` /* generated by server */