Debian Codegraph @

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

raw
1 drop table if exists t1, t2;
2 reset master;
3 create table t1 (a int) engine=innodb;
4 create table t2 (a int) engine=innodb;
5 begin;
6 insert t1 values (5);
7 commit;
8 begin;
9 insert t2 values (5);
10 commit;
11 include/show_binlog_events.inc
12 Log_name Pos Event_type Server_id End_log_pos Info
13 master-bin.000001 # Gtid # # GTID #-#-#
14 master-bin.000001 # Query # # use `test`; create table t1 (a int) engine=innodb
15 master-bin.000001 # Gtid # # GTID #-#-#
16 master-bin.000001 # Query # # use `test`; create table t2 (a int) engine=innodb
17 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
18 master-bin.000001 # Annotate_rows # # insert t1 values (5)
19 master-bin.000001 # Table_map # # table_id: # (test.t1)
20 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
21 master-bin.000001 # Xid # # COMMIT /* XID */
22 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
23 master-bin.000001 # Annotate_rows # # insert t2 values (5)
24 master-bin.000001 # Table_map # # table_id: # (test.t2)
25 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
26 master-bin.000001 # Xid # # COMMIT /* XID */
27 drop table t1,t2;
28 reset master;
29 create table t1 (n int) engine=innodb;
30 begin;
31 commit;
32 drop table t1;
33 include/show_binlog_events.inc
34 Log_name Pos Event_type Server_id End_log_pos Info
35 master-bin.000001 # Gtid # # GTID #-#-#
36 master-bin.000001 # Query # # use `test`; create table t1 (n int) engine=innodb
37 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
38 master-bin.000001 # Annotate_rows # # insert into t1 values(100 + 4)
39 master-bin.000001 # Table_map # # table_id: # (test.t1)
40 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
41 master-bin.000001 # Annotate_rows # # insert into t1 values(99 + 4)
42 master-bin.000001 # Table_map # # table_id: # (test.t1)
43 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
44 master-bin.000001 # Annotate_rows # # insert into t1 values(98 + 4)
45 master-bin.000001 # Table_map # # table_id: # (test.t1)
46 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
47 master-bin.000001 # Annotate_rows # # insert into t1 values(97 + 4)
48 master-bin.000001 # Table_map # # table_id: # (test.t1)
49 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
50 master-bin.000001 # Annotate_rows # # insert into t1 values(96 + 4)
51 master-bin.000001 # Table_map # # table_id: # (test.t1)
52 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
53 master-bin.000001 # Annotate_rows # # insert into t1 values(95 + 4)
54 master-bin.000001 # Table_map # # table_id: # (test.t1)
55 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
56 master-bin.000001 # Annotate_rows # # insert into t1 values(94 + 4)
57 master-bin.000001 # Table_map # # table_id: # (test.t1)
58 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
59 master-bin.000001 # Annotate_rows # # insert into t1 values(93 + 4)
60 master-bin.000001 # Table_map # # table_id: # (test.t1)
61 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
62 master-bin.000001 # Annotate_rows # # insert into t1 values(92 + 4)
63 master-bin.000001 # Table_map # # table_id: # (test.t1)
64 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
65 master-bin.000001 # Annotate_rows # # insert into t1 values(91 + 4)
66 master-bin.000001 # Table_map # # table_id: # (test.t1)
67 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
68 master-bin.000001 # Annotate_rows # # insert into t1 values(90 + 4)
69 master-bin.000001 # Table_map # # table_id: # (test.t1)
70 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
71 master-bin.000001 # Annotate_rows # # insert into t1 values(89 + 4)
72 master-bin.000001 # Table_map # # table_id: # (test.t1)
73 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
74 master-bin.000001 # Annotate_rows # # insert into t1 values(88 + 4)
75 master-bin.000001 # Table_map # # table_id: # (test.t1)
76 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
77 master-bin.000001 # Annotate_rows # # insert into t1 values(87 + 4)
78 master-bin.000001 # Table_map # # table_id: # (test.t1)
79 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
80 master-bin.000001 # Annotate_rows # # insert into t1 values(86 + 4)
81 master-bin.000001 # Table_map # # table_id: # (test.t1)
82 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
83 master-bin.000001 # Annotate_rows # # insert into t1 values(85 + 4)
84 master-bin.000001 # Table_map # # table_id: # (test.t1)
85 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
86 master-bin.000001 # Annotate_rows # # insert into t1 values(84 + 4)
87 master-bin.000001 # Table_map # # table_id: # (test.t1)
88 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
89 master-bin.000001 # Annotate_rows # # insert into t1 values(83 + 4)
90 master-bin.000001 # Table_map # # table_id: # (test.t1)
91 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
92 master-bin.000001 # Annotate_rows # # insert into t1 values(82 + 4)
93 master-bin.000001 # Table_map # # table_id: # (test.t1)
94 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
95 master-bin.000001 # Annotate_rows # # insert into t1 values(81 + 4)
96 master-bin.000001 # Table_map # # table_id: # (test.t1)
97 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
98 master-bin.000001 # Annotate_rows # # insert into t1 values(80 + 4)
99 master-bin.000001 # Table_map # # table_id: # (test.t1)
100 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
101 master-bin.000001 # Annotate_rows # # insert into t1 values(79 + 4)
102 master-bin.000001 # Table_map # # table_id: # (test.t1)
103 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
104 master-bin.000001 # Annotate_rows # # insert into t1 values(78 + 4)
105 master-bin.000001 # Table_map # # table_id: # (test.t1)
106 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
107 master-bin.000001 # Annotate_rows # # insert into t1 values(77 + 4)
108 master-bin.000001 # Table_map # # table_id: # (test.t1)
109 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
110 master-bin.000001 # Annotate_rows # # insert into t1 values(76 + 4)
111 master-bin.000001 # Table_map # # table_id: # (test.t1)
112 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
113 master-bin.000001 # Annotate_rows # # insert into t1 values(75 + 4)
114 master-bin.000001 # Table_map # # table_id: # (test.t1)
115 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
116 master-bin.000001 # Annotate_rows # # insert into t1 values(74 + 4)
117 master-bin.000001 # Table_map # # table_id: # (test.t1)
118 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
119 master-bin.000001 # Annotate_rows # # insert into t1 values(73 + 4)
120 master-bin.000001 # Table_map # # table_id: # (test.t1)
121 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
122 master-bin.000001 # Annotate_rows # # insert into t1 values(72 + 4)
123 master-bin.000001 # Table_map # # table_id: # (test.t1)
124 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
125 master-bin.000001 # Annotate_rows # # insert into t1 values(71 + 4)
126 master-bin.000001 # Table_map # # table_id: # (test.t1)
127 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
128 master-bin.000001 # Annotate_rows # # insert into t1 values(70 + 4)
129 master-bin.000001 # Table_map # # table_id: # (test.t1)
130 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
131 master-bin.000001 # Annotate_rows # # insert into t1 values(69 + 4)
132 master-bin.000001 # Table_map # # table_id: # (test.t1)
133 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
134 master-bin.000001 # Annotate_rows # # insert into t1 values(68 + 4)
135 master-bin.000001 # Table_map # # table_id: # (test.t1)
136 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
137 master-bin.000001 # Annotate_rows # # insert into t1 values(67 + 4)
138 master-bin.000001 # Table_map # # table_id: # (test.t1)
139 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
140 master-bin.000001 # Annotate_rows # # insert into t1 values(66 + 4)
141 master-bin.000001 # Table_map # # table_id: # (test.t1)
142 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
143 master-bin.000001 # Annotate_rows # # insert into t1 values(65 + 4)
144 master-bin.000001 # Table_map # # table_id: # (test.t1)
145 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
146 master-bin.000001 # Annotate_rows # # insert into t1 values(64 + 4)
147 master-bin.000001 # Table_map # # table_id: # (test.t1)
148 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
149 master-bin.000001 # Annotate_rows # # insert into t1 values(63 + 4)
150 master-bin.000001 # Table_map # # table_id: # (test.t1)
151 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
152 master-bin.000001 # Annotate_rows # # insert into t1 values(62 + 4)
153 master-bin.000001 # Table_map # # table_id: # (test.t1)
154 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
155 master-bin.000001 # Annotate_rows # # insert into t1 values(61 + 4)
156 master-bin.000001 # Table_map # # table_id: # (test.t1)
157 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
158 master-bin.000001 # Annotate_rows # # insert into t1 values(60 + 4)
159 master-bin.000001 # Table_map # # table_id: # (test.t1)
160 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
161 master-bin.000001 # Annotate_rows # # insert into t1 values(59 + 4)
162 master-bin.000001 # Table_map # # table_id: # (test.t1)
163 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
164 master-bin.000001 # Annotate_rows # # insert into t1 values(58 + 4)
165 master-bin.000001 # Table_map # # table_id: # (test.t1)
166 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
167 master-bin.000001 # Annotate_rows # # insert into t1 values(57 + 4)
168 master-bin.000001 # Table_map # # table_id: # (test.t1)
169 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
170 master-bin.000001 # Annotate_rows # # insert into t1 values(56 + 4)
171 master-bin.000001 # Table_map # # table_id: # (test.t1)
172 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
173 master-bin.000001 # Annotate_rows # # insert into t1 values(55 + 4)
174 master-bin.000001 # Table_map # # table_id: # (test.t1)
175 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
176 master-bin.000001 # Annotate_rows # # insert into t1 values(54 + 4)
177 master-bin.000001 # Table_map # # table_id: # (test.t1)
178 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
179 master-bin.000001 # Annotate_rows # # insert into t1 values(53 + 4)
180 master-bin.000001 # Table_map # # table_id: # (test.t1)
181 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
182 master-bin.000001 # Annotate_rows # # insert into t1 values(52 + 4)
183 master-bin.000001 # Table_map # # table_id: # (test.t1)
184 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
185 master-bin.000001 # Annotate_rows # # insert into t1 values(51 + 4)
186 master-bin.000001 # Table_map # # table_id: # (test.t1)
187 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
188 master-bin.000001 # Annotate_rows # # insert into t1 values(50 + 4)
189 master-bin.000001 # Table_map # # table_id: # (test.t1)
190 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
191 master-bin.000001 # Annotate_rows # # insert into t1 values(49 + 4)
192 master-bin.000001 # Table_map # # table_id: # (test.t1)
193 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
194 master-bin.000001 # Annotate_rows # # insert into t1 values(48 + 4)
195 master-bin.000001 # Table_map # # table_id: # (test.t1)
196 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
197 master-bin.000001 # Annotate_rows # # insert into t1 values(47 + 4)
198 master-bin.000001 # Table_map # # table_id: # (test.t1)
199 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
200 master-bin.000001 # Annotate_rows # # insert into t1 values(46 + 4)
201 master-bin.000001 # Table_map # # table_id: # (test.t1)
202 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
203 master-bin.000001 # Annotate_rows # # insert into t1 values(45 + 4)
204 master-bin.000001 # Table_map # # table_id: # (test.t1)
205 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
206 master-bin.000001 # Annotate_rows # # insert into t1 values(44 + 4)
207 master-bin.000001 # Table_map # # table_id: # (test.t1)
208 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
209 master-bin.000001 # Annotate_rows # # insert into t1 values(43 + 4)
210 master-bin.000001 # Table_map # # table_id: # (test.t1)
211 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
212 master-bin.000001 # Annotate_rows # # insert into t1 values(42 + 4)
213 master-bin.000001 # Table_map # # table_id: # (test.t1)
214 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
215 master-bin.000001 # Annotate_rows # # insert into t1 values(41 + 4)
216 master-bin.000001 # Table_map # # table_id: # (test.t1)
217 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
218 master-bin.000001 # Annotate_rows # # insert into t1 values(40 + 4)
219 master-bin.000001 # Table_map # # table_id: # (test.t1)
220 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
221 master-bin.000001 # Annotate_rows # # insert into t1 values(39 + 4)
222 master-bin.000001 # Table_map # # table_id: # (test.t1)
223 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
224 master-bin.000001 # Annotate_rows # # insert into t1 values(38 + 4)
225 master-bin.000001 # Table_map # # table_id: # (test.t1)
226 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
227 master-bin.000001 # Annotate_rows # # insert into t1 values(37 + 4)
228 master-bin.000001 # Table_map # # table_id: # (test.t1)
229 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
230 master-bin.000001 # Annotate_rows # # insert into t1 values(36 + 4)
231 master-bin.000001 # Table_map # # table_id: # (test.t1)
232 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
233 master-bin.000001 # Annotate_rows # # insert into t1 values(35 + 4)
234 master-bin.000001 # Table_map # # table_id: # (test.t1)
235 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
236 master-bin.000001 # Annotate_rows # # insert into t1 values(34 + 4)
237 master-bin.000001 # Table_map # # table_id: # (test.t1)
238 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
239 master-bin.000001 # Annotate_rows # # insert into t1 values(33 + 4)
240 master-bin.000001 # Table_map # # table_id: # (test.t1)
241 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
242 master-bin.000001 # Annotate_rows # # insert into t1 values(32 + 4)
243 master-bin.000001 # Table_map # # table_id: # (test.t1)
244 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
245 master-bin.000001 # Annotate_rows # # insert into t1 values(31 + 4)
246 master-bin.000001 # Table_map # # table_id: # (test.t1)
247 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
248 master-bin.000001 # Annotate_rows # # insert into t1 values(30 + 4)
249 master-bin.000001 # Table_map # # table_id: # (test.t1)
250 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
251 master-bin.000001 # Annotate_rows # # insert into t1 values(29 + 4)
252 master-bin.000001 # Table_map # # table_id: # (test.t1)
253 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
254 master-bin.000001 # Annotate_rows # # insert into t1 values(28 + 4)
255 master-bin.000001 # Table_map # # table_id: # (test.t1)
256 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
257 master-bin.000001 # Annotate_rows # # insert into t1 values(27 + 4)
258 master-bin.000001 # Table_map # # table_id: # (test.t1)
259 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
260 master-bin.000001 # Annotate_rows # # insert into t1 values(26 + 4)
261 master-bin.000001 # Table_map # # table_id: # (test.t1)
262 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
263 master-bin.000001 # Annotate_rows # # insert into t1 values(25 + 4)
264 master-bin.000001 # Table_map # # table_id: # (test.t1)
265 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
266 master-bin.000001 # Annotate_rows # # insert into t1 values(24 + 4)
267 master-bin.000001 # Table_map # # table_id: # (test.t1)
268 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
269 master-bin.000001 # Annotate_rows # # insert into t1 values(23 + 4)
270 master-bin.000001 # Table_map # # table_id: # (test.t1)
271 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
272 master-bin.000001 # Annotate_rows # # insert into t1 values(22 + 4)
273 master-bin.000001 # Table_map # # table_id: # (test.t1)
274 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
275 master-bin.000001 # Annotate_rows # # insert into t1 values(21 + 4)
276 master-bin.000001 # Table_map # # table_id: # (test.t1)
277 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
278 master-bin.000001 # Annotate_rows # # insert into t1 values(20 + 4)
279 master-bin.000001 # Table_map # # table_id: # (test.t1)
280 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
281 master-bin.000001 # Annotate_rows # # insert into t1 values(19 + 4)
282 master-bin.000001 # Table_map # # table_id: # (test.t1)
283 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
284 master-bin.000001 # Annotate_rows # # insert into t1 values(18 + 4)
285 master-bin.000001 # Table_map # # table_id: # (test.t1)
286 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
287 master-bin.000001 # Annotate_rows # # insert into t1 values(17 + 4)
288 master-bin.000001 # Table_map # # table_id: # (test.t1)
289 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
290 master-bin.000001 # Annotate_rows # # insert into t1 values(16 + 4)
291 master-bin.000001 # Table_map # # table_id: # (test.t1)
292 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
293 master-bin.000001 # Annotate_rows # # insert into t1 values(15 + 4)
294 master-bin.000001 # Table_map # # table_id: # (test.t1)
295 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
296 master-bin.000001 # Annotate_rows # # insert into t1 values(14 + 4)
297 master-bin.000001 # Table_map # # table_id: # (test.t1)
298 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
299 master-bin.000001 # Annotate_rows # # insert into t1 values(13 + 4)
300 master-bin.000001 # Table_map # # table_id: # (test.t1)
301 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
302 master-bin.000001 # Annotate_rows # # insert into t1 values(12 + 4)
303 master-bin.000001 # Table_map # # table_id: # (test.t1)
304 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
305 master-bin.000001 # Annotate_rows # # insert into t1 values(11 + 4)
306 master-bin.000001 # Table_map # # table_id: # (test.t1)
307 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
308 master-bin.000001 # Annotate_rows # # insert into t1 values(10 + 4)
309 master-bin.000001 # Table_map # # table_id: # (test.t1)
310 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
311 master-bin.000001 # Annotate_rows # # insert into t1 values(9 + 4)
312 master-bin.000001 # Table_map # # table_id: # (test.t1)
313 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
314 master-bin.000001 # Annotate_rows # # insert into t1 values(8 + 4)
315 master-bin.000001 # Table_map # # table_id: # (test.t1)
316 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
317 master-bin.000001 # Annotate_rows # # insert into t1 values(7 + 4)
318 master-bin.000001 # Table_map # # table_id: # (test.t1)
319 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
320 master-bin.000001 # Annotate_rows # # insert into t1 values(6 + 4)
321 master-bin.000001 # Table_map # # table_id: # (test.t1)
322 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
323 master-bin.000001 # Annotate_rows # # insert into t1 values(5 + 4)
324 master-bin.000001 # Table_map # # table_id: # (test.t1)
325 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
326 master-bin.000001 # Annotate_rows # # insert into t1 values(4 + 4)
327 master-bin.000001 # Table_map # # table_id: # (test.t1)
328 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
329 master-bin.000001 # Annotate_rows # # insert into t1 values(3 + 4)
330 master-bin.000001 # Table_map # # table_id: # (test.t1)
331 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
332 master-bin.000001 # Annotate_rows # # insert into t1 values(2 + 4)
333 master-bin.000001 # Table_map # # table_id: # (test.t1)
334 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
335 master-bin.000001 # Annotate_rows # # insert into t1 values(1 + 4)
336 master-bin.000001 # Table_map # # table_id: # (test.t1)
337 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
338 master-bin.000001 # Xid # # COMMIT /* XID */
339 master-bin.000001 # Rotate # # master-bin.000002;pos=POS
340 include/show_binlog_events.inc
341 Log_name Pos Event_type Server_id End_log_pos Info
342 master-bin.000002 # Binlog_checkpoint # # master-bin.000002
343 master-bin.000002 # Gtid # # GTID #-#-#
344 master-bin.000002 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
345 set @ac = @@autocommit;
346 set autocommit= 0;
347 reset master;
348 create table t1(n int) engine=innodb;
349 begin;
350 insert into t1 values (1);
351 insert into t1 values (2);
352 insert into t1 values (3);
353 commit;
354 drop table t1;
355 include/show_binlog_events.inc
356 Log_name Pos Event_type Server_id End_log_pos Info
357 master-bin.000001 # Gtid # # GTID #-#-#
358 master-bin.000001 # Query # # use `test`; create table t1(n int) engine=innodb
359 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
360 master-bin.000001 # Annotate_rows # # insert into t1 values (1)
361 master-bin.000001 # Table_map # # table_id: # (test.t1)
362 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
363 master-bin.000001 # Annotate_rows # # insert into t1 values (2)
364 master-bin.000001 # Table_map # # table_id: # (test.t1)
365 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
366 master-bin.000001 # Annotate_rows # # insert into t1 values (3)
367 master-bin.000001 # Table_map # # table_id: # (test.t1)
368 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
369 master-bin.000001 # Xid # # COMMIT /* XID */
370 master-bin.000001 # Gtid # # GTID #-#-#
371 master-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
372 set @bcs = @@binlog_cache_size;
373 set global binlog_cache_size=4096;
374 reset master;
375 create table t1 (a int, b char(255)) engine=innodb;
376 flush global status;
377 show status like "binlog_cache_use";
378 Variable_name Value
379 Binlog_cache_use 0
380 *** the following must show the counter value = 1 ***
381 Variable_name Value
382 Binlog_cache_use 1
383 include/show_binlog_events.inc
384 Log_name Pos Event_type Server_id End_log_pos Info
385 master-bin.000001 # Gtid # # GTID #-#-#
386 master-bin.000001 # Query # # use `test`; create table t1 (a int, b char(255)) engine=innodb
387 master-bin.000001 # Gtid # # GTID #-#-#
388 master-bin.000001 # Query # # use `test`; flush global status
389 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
390 master-bin.000001 # Annotate_rows # # insert into t1 values( 100, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
391 master-bin.000001 # Table_map # # table_id: # (test.t1)
392 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
393 master-bin.000001 # Annotate_rows # # insert into t1 values( 99, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
394 master-bin.000001 # Table_map # # table_id: # (test.t1)
395 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
396 master-bin.000001 # Annotate_rows # # insert into t1 values( 98, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
397 master-bin.000001 # Table_map # # table_id: # (test.t1)
398 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
399 master-bin.000001 # Annotate_rows # # insert into t1 values( 97, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
400 master-bin.000001 # Table_map # # table_id: # (test.t1)
401 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
402 master-bin.000001 # Annotate_rows # # insert into t1 values( 96, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
403 master-bin.000001 # Table_map # # table_id: # (test.t1)
404 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
405 master-bin.000001 # Annotate_rows # # insert into t1 values( 95, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
406 master-bin.000001 # Table_map # # table_id: # (test.t1)
407 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
408 master-bin.000001 # Annotate_rows # # insert into t1 values( 94, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
409 master-bin.000001 # Table_map # # table_id: # (test.t1)
410 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
411 master-bin.000001 # Annotate_rows # # insert into t1 values( 93, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
412 master-bin.000001 # Table_map # # table_id: # (test.t1)
413 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
414 master-bin.000001 # Annotate_rows # # insert into t1 values( 92, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
415 master-bin.000001 # Table_map # # table_id: # (test.t1)
416 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
417 master-bin.000001 # Annotate_rows # # insert into t1 values( 91, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
418 master-bin.000001 # Table_map # # table_id: # (test.t1)
419 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
420 master-bin.000001 # Annotate_rows # # insert into t1 values( 90, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
421 master-bin.000001 # Table_map # # table_id: # (test.t1)
422 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
423 master-bin.000001 # Annotate_rows # # insert into t1 values( 89, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
424 master-bin.000001 # Table_map # # table_id: # (test.t1)
425 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
426 master-bin.000001 # Annotate_rows # # insert into t1 values( 88, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
427 master-bin.000001 # Table_map # # table_id: # (test.t1)
428 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
429 master-bin.000001 # Annotate_rows # # insert into t1 values( 87, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
430 master-bin.000001 # Table_map # # table_id: # (test.t1)
431 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
432 master-bin.000001 # Annotate_rows # # insert into t1 values( 86, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
433 master-bin.000001 # Table_map # # table_id: # (test.t1)
434 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
435 master-bin.000001 # Annotate_rows # # insert into t1 values( 85, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
436 master-bin.000001 # Table_map # # table_id: # (test.t1)
437 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
438 master-bin.000001 # Annotate_rows # # insert into t1 values( 84, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
439 master-bin.000001 # Table_map # # table_id: # (test.t1)
440 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
441 master-bin.000001 # Annotate_rows # # insert into t1 values( 83, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
442 master-bin.000001 # Table_map # # table_id: # (test.t1)
443 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
444 master-bin.000001 # Annotate_rows # # insert into t1 values( 82, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
445 master-bin.000001 # Table_map # # table_id: # (test.t1)
446 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
447 master-bin.000001 # Annotate_rows # # insert into t1 values( 81, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
448 master-bin.000001 # Table_map # # table_id: # (test.t1)
449 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
450 master-bin.000001 # Annotate_rows # # insert into t1 values( 80, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
451 master-bin.000001 # Table_map # # table_id: # (test.t1)
452 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
453 master-bin.000001 # Annotate_rows # # insert into t1 values( 79, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
454 master-bin.000001 # Table_map # # table_id: # (test.t1)
455 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
456 master-bin.000001 # Annotate_rows # # insert into t1 values( 78, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
457 master-bin.000001 # Table_map # # table_id: # (test.t1)
458 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
459 master-bin.000001 # Annotate_rows # # insert into t1 values( 77, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
460 master-bin.000001 # Table_map # # table_id: # (test.t1)
461 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
462 master-bin.000001 # Annotate_rows # # insert into t1 values( 76, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
463 master-bin.000001 # Table_map # # table_id: # (test.t1)
464 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
465 master-bin.000001 # Annotate_rows # # insert into t1 values( 75, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
466 master-bin.000001 # Table_map # # table_id: # (test.t1)
467 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
468 master-bin.000001 # Annotate_rows # # insert into t1 values( 74, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
469 master-bin.000001 # Table_map # # table_id: # (test.t1)
470 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
471 master-bin.000001 # Annotate_rows # # insert into t1 values( 73, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
472 master-bin.000001 # Table_map # # table_id: # (test.t1)
473 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
474 master-bin.000001 # Annotate_rows # # insert into t1 values( 72, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
475 master-bin.000001 # Table_map # # table_id: # (test.t1)
476 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
477 master-bin.000001 # Annotate_rows # # insert into t1 values( 71, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
478 master-bin.000001 # Table_map # # table_id: # (test.t1)
479 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
480 master-bin.000001 # Annotate_rows # # insert into t1 values( 70, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
481 master-bin.000001 # Table_map # # table_id: # (test.t1)
482 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
483 master-bin.000001 # Annotate_rows # # insert into t1 values( 69, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
484 master-bin.000001 # Table_map # # table_id: # (test.t1)
485 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
486 master-bin.000001 # Annotate_rows # # insert into t1 values( 68, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
487 master-bin.000001 # Table_map # # table_id: # (test.t1)
488 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
489 master-bin.000001 # Annotate_rows # # insert into t1 values( 67, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
490 master-bin.000001 # Table_map # # table_id: # (test.t1)
491 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
492 master-bin.000001 # Annotate_rows # # insert into t1 values( 66, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
493 master-bin.000001 # Table_map # # table_id: # (test.t1)
494 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
495 master-bin.000001 # Annotate_rows # # insert into t1 values( 65, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
496 master-bin.000001 # Table_map # # table_id: # (test.t1)
497 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
498 master-bin.000001 # Annotate_rows # # insert into t1 values( 64, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
499 master-bin.000001 # Table_map # # table_id: # (test.t1)
500 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
501 master-bin.000001 # Annotate_rows # # insert into t1 values( 63, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
502 master-bin.000001 # Table_map # # table_id: # (test.t1)
503 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
504 master-bin.000001 # Annotate_rows # # insert into t1 values( 62, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
505 master-bin.000001 # Table_map # # table_id: # (test.t1)
506 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
507 master-bin.000001 # Annotate_rows # # insert into t1 values( 61, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
508 master-bin.000001 # Table_map # # table_id: # (test.t1)
509 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
510 master-bin.000001 # Annotate_rows # # insert into t1 values( 60, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
511 master-bin.000001 # Table_map # # table_id: # (test.t1)
512 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
513 master-bin.000001 # Annotate_rows # # insert into t1 values( 59, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
514 master-bin.000001 # Table_map # # table_id: # (test.t1)
515 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
516 master-bin.000001 # Annotate_rows # # insert into t1 values( 58, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
517 master-bin.000001 # Table_map # # table_id: # (test.t1)
518 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
519 master-bin.000001 # Annotate_rows # # insert into t1 values( 57, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
520 master-bin.000001 # Table_map # # table_id: # (test.t1)
521 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
522 master-bin.000001 # Annotate_rows # # insert into t1 values( 56, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
523 master-bin.000001 # Table_map # # table_id: # (test.t1)
524 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
525 master-bin.000001 # Annotate_rows # # insert into t1 values( 55, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
526 master-bin.000001 # Table_map # # table_id: # (test.t1)
527 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
528 master-bin.000001 # Annotate_rows # # insert into t1 values( 54, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
529 master-bin.000001 # Table_map # # table_id: # (test.t1)
530 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
531 master-bin.000001 # Annotate_rows # # insert into t1 values( 53, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
532 master-bin.000001 # Table_map # # table_id: # (test.t1)
533 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
534 master-bin.000001 # Annotate_rows # # insert into t1 values( 52, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
535 master-bin.000001 # Table_map # # table_id: # (test.t1)
536 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
537 master-bin.000001 # Annotate_rows # # insert into t1 values( 51, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
538 master-bin.000001 # Table_map # # table_id: # (test.t1)
539 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
540 master-bin.000001 # Annotate_rows # # insert into t1 values( 50, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
541 master-bin.000001 # Table_map # # table_id: # (test.t1)
542 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
543 master-bin.000001 # Annotate_rows # # insert into t1 values( 49, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
544 master-bin.000001 # Table_map # # table_id: # (test.t1)
545 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
546 master-bin.000001 # Annotate_rows # # insert into t1 values( 48, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
547 master-bin.000001 # Table_map # # table_id: # (test.t1)
548 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
549 master-bin.000001 # Annotate_rows # # insert into t1 values( 47, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
550 master-bin.000001 # Table_map # # table_id: # (test.t1)
551 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
552 master-bin.000001 # Annotate_rows # # insert into t1 values( 46, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
553 master-bin.000001 # Table_map # # table_id: # (test.t1)
554 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
555 master-bin.000001 # Annotate_rows # # insert into t1 values( 45, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
556 master-bin.000001 # Table_map # # table_id: # (test.t1)
557 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
558 master-bin.000001 # Annotate_rows # # insert into t1 values( 44, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
559 master-bin.000001 # Table_map # # table_id: # (test.t1)
560 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
561 master-bin.000001 # Annotate_rows # # insert into t1 values( 43, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
562 master-bin.000001 # Table_map # # table_id: # (test.t1)
563 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
564 master-bin.000001 # Annotate_rows # # insert into t1 values( 42, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
565 master-bin.000001 # Table_map # # table_id: # (test.t1)
566 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
567 master-bin.000001 # Annotate_rows # # insert into t1 values( 41, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
568 master-bin.000001 # Table_map # # table_id: # (test.t1)
569 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
570 master-bin.000001 # Annotate_rows # # insert into t1 values( 40, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
571 master-bin.000001 # Table_map # # table_id: # (test.t1)
572 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
573 master-bin.000001 # Annotate_rows # # insert into t1 values( 39, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
574 master-bin.000001 # Table_map # # table_id: # (test.t1)
575 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
576 master-bin.000001 # Annotate_rows # # insert into t1 values( 38, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
577 master-bin.000001 # Table_map # # table_id: # (test.t1)
578 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
579 master-bin.000001 # Annotate_rows # # insert into t1 values( 37, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
580 master-bin.000001 # Table_map # # table_id: # (test.t1)
581 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
582 master-bin.000001 # Annotate_rows # # insert into t1 values( 36, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
583 master-bin.000001 # Table_map # # table_id: # (test.t1)
584 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
585 master-bin.000001 # Annotate_rows # # insert into t1 values( 35, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
586 master-bin.000001 # Table_map # # table_id: # (test.t1)
587 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
588 master-bin.000001 # Annotate_rows # # insert into t1 values( 34, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
589 master-bin.000001 # Table_map # # table_id: # (test.t1)
590 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
591 master-bin.000001 # Annotate_rows # # insert into t1 values( 33, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
592 master-bin.000001 # Table_map # # table_id: # (test.t1)
593 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
594 master-bin.000001 # Annotate_rows # # insert into t1 values( 32, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
595 master-bin.000001 # Table_map # # table_id: # (test.t1)
596 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
597 master-bin.000001 # Annotate_rows # # insert into t1 values( 31, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
598 master-bin.000001 # Table_map # # table_id: # (test.t1)
599 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
600 master-bin.000001 # Annotate_rows # # insert into t1 values( 30, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
601 master-bin.000001 # Table_map # # table_id: # (test.t1)
602 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
603 master-bin.000001 # Annotate_rows # # insert into t1 values( 29, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
604 master-bin.000001 # Table_map # # table_id: # (test.t1)
605 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
606 master-bin.000001 # Annotate_rows # # insert into t1 values( 28, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
607 master-bin.000001 # Table_map # # table_id: # (test.t1)
608 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
609 master-bin.000001 # Annotate_rows # # insert into t1 values( 27, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
610 master-bin.000001 # Table_map # # table_id: # (test.t1)
611 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
612 master-bin.000001 # Annotate_rows # # insert into t1 values( 26, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
613 master-bin.000001 # Table_map # # table_id: # (test.t1)
614 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
615 master-bin.000001 # Annotate_rows # # insert into t1 values( 25, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
616 master-bin.000001 # Table_map # # table_id: # (test.t1)
617 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
618 master-bin.000001 # Annotate_rows # # insert into t1 values( 24, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
619 master-bin.000001 # Table_map # # table_id: # (test.t1)
620 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
621 master-bin.000001 # Annotate_rows # # insert into t1 values( 23, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
622 master-bin.000001 # Table_map # # table_id: # (test.t1)
623 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
624 master-bin.000001 # Annotate_rows # # insert into t1 values( 22, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
625 master-bin.000001 # Table_map # # table_id: # (test.t1)
626 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
627 master-bin.000001 # Annotate_rows # # insert into t1 values( 21, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
628 master-bin.000001 # Table_map # # table_id: # (test.t1)
629 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
630 master-bin.000001 # Annotate_rows # # insert into t1 values( 20, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
631 master-bin.000001 # Table_map # # table_id: # (test.t1)
632 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
633 master-bin.000001 # Annotate_rows # # insert into t1 values( 19, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
634 master-bin.000001 # Table_map # # table_id: # (test.t1)
635 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
636 master-bin.000001 # Annotate_rows # # insert into t1 values( 18, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
637 master-bin.000001 # Table_map # # table_id: # (test.t1)
638 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
639 master-bin.000001 # Annotate_rows # # insert into t1 values( 17, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
640 master-bin.000001 # Table_map # # table_id: # (test.t1)
641 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
642 master-bin.000001 # Annotate_rows # # insert into t1 values( 16, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
643 master-bin.000001 # Table_map # # table_id: # (test.t1)
644 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
645 master-bin.000001 # Annotate_rows # # insert into t1 values( 15, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
646 master-bin.000001 # Table_map # # table_id: # (test.t1)
647 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
648 master-bin.000001 # Annotate_rows # # insert into t1 values( 14, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
649 master-bin.000001 # Table_map # # table_id: # (test.t1)
650 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
651 master-bin.000001 # Annotate_rows # # insert into t1 values( 13, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
652 master-bin.000001 # Table_map # # table_id: # (test.t1)
653 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
654 master-bin.000001 # Annotate_rows # # insert into t1 values( 12, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
655 master-bin.000001 # Table_map # # table_id: # (test.t1)
656 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
657 master-bin.000001 # Annotate_rows # # insert into t1 values( 11, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
658 master-bin.000001 # Table_map # # table_id: # (test.t1)
659 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
660 master-bin.000001 # Annotate_rows # # insert into t1 values( 10, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
661 master-bin.000001 # Table_map # # table_id: # (test.t1)
662 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
663 master-bin.000001 # Annotate_rows # # insert into t1 values( 9, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
664 master-bin.000001 # Table_map # # table_id: # (test.t1)
665 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
666 master-bin.000001 # Annotate_rows # # insert into t1 values( 8, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
667 master-bin.000001 # Table_map # # table_id: # (test.t1)
668 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
669 master-bin.000001 # Annotate_rows # # insert into t1 values( 7, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
670 master-bin.000001 # Table_map # # table_id: # (test.t1)
671 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
672 master-bin.000001 # Annotate_rows # # insert into t1 values( 6, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
673 master-bin.000001 # Table_map # # table_id: # (test.t1)
674 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
675 master-bin.000001 # Annotate_rows # # insert into t1 values( 5, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
676 master-bin.000001 # Table_map # # table_id: # (test.t1)
677 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
678 master-bin.000001 # Annotate_rows # # insert into t1 values( 4, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
679 master-bin.000001 # Table_map # # table_id: # (test.t1)
680 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
681 master-bin.000001 # Annotate_rows # # insert into t1 values( 3, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
682 master-bin.000001 # Table_map # # table_id: # (test.t1)
683 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
684 master-bin.000001 # Annotate_rows # # insert into t1 values( 2, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
685 master-bin.000001 # Table_map # # table_id: # (test.t1)
686 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
687 master-bin.000001 # Annotate_rows # # insert into t1 values( 1, 'just to fill void to make transaction occupying at least two buffers of the trans cache' )
688 master-bin.000001 # Table_map # # table_id: # (test.t1)
689 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
690 master-bin.000001 # Xid # # COMMIT /* XID */
691 master-bin.000001 # Rotate # # master-bin.000002;pos=POS
692 drop table t1;
693 set global binlog_cache_size=@bcs;
694 set session autocommit = @ac;
695 drop table if exists t1;
696 reset master;
697 create table t1 (a bigint unsigned, b bigint(20) unsigned);
698 prepare stmt from "insert into t1 values (?,?)";
699 set @a= 9999999999999999;
700 set @b= 14632475938453979136;
701 execute stmt using @a, @b;
702 deallocate prepare stmt;
703 drop table t1;
704 include/show_binlog_events.inc
705 Log_name Pos Event_type Server_id End_log_pos Info
706 master-bin.000001 # Gtid # # GTID #-#-#
707 master-bin.000001 # Query # # use `test`; create table t1 (a bigint unsigned, b bigint(20) unsigned)
708 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
709 master-bin.000001 # Annotate_rows # # insert into t1 values (9999999999999999,14632475938453979136)
710 master-bin.000001 # Table_map # # table_id: # (test.t1)
711 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
712 master-bin.000001 # Query # # COMMIT
713 master-bin.000001 # Gtid # # GTID #-#-#
714 master-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
715 reset master;
716 CREATE DATABASE bug39182 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
717 USE bug39182;
718 CREATE TABLE t1 (a VARCHAR(255) COLLATE utf8_unicode_ci)
719 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
720 CREATE PROCEDURE p1()
721 BEGIN
722 DECLARE s1 VARCHAR(255);
723 SET s1= "test";
724 CREATE TEMPORARY TABLE tmp1
725 SELECT * FROM t1 WHERE a LIKE CONCAT("%", s1, "%");
726 SELECT
727 COLLATION(NAME_CONST('s1', _utf8'test')) c1,
728 COLLATION(NAME_CONST('s1', _utf8'test' COLLATE utf8_unicode_ci)) c2,
729 COLLATION(s1) c3,
730 COERCIBILITY(NAME_CONST('s1', _utf8'test')) d1,
731 COERCIBILITY(NAME_CONST('s1', _utf8'test' COLLATE utf8_unicode_ci)) d2,
732 COERCIBILITY(s1) d3;
733 DROP TEMPORARY TABLE tmp1;
734 END//
735 CALL p1();
736 c1 c2 c3 d1 d2 d3
737 utf8mb3_uca1400_ai_ci utf8mb3_unicode_ci utf8mb3_unicode_ci 2 2 2
738 include/show_binlog_events.inc
739 Log_name Pos Event_type Server_id End_log_pos Info
740 master-bin.000001 # Gtid # # GTID #-#-#
741 master-bin.000001 # Query # # CREATE DATABASE bug39182 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci
742 master-bin.000001 # Gtid # # GTID #-#-#
743 master-bin.000001 # Query # # use `bug39182`; CREATE TABLE t1 (a VARCHAR(255) COLLATE utf8_unicode_ci)
744 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
745 master-bin.000001 # Gtid # # GTID #-#-#
746 master-bin.000001 # Query # # use `bug39182`; CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`()
747 BEGIN
748 DECLARE s1 VARCHAR(255);
749 SET s1= "test";
750 CREATE TEMPORARY TABLE tmp1
751 SELECT * FROM t1 WHERE a LIKE CONCAT("%", s1, "%");
752 SELECT
753 COLLATION(NAME_CONST('s1', _utf8'test')) c1,
754 COLLATION(NAME_CONST('s1', _utf8'test' COLLATE utf8_unicode_ci)) c2,
755 COLLATION(s1) c3,
756 COERCIBILITY(NAME_CONST('s1', _utf8'test')) d1,
757 COERCIBILITY(NAME_CONST('s1', _utf8'test' COLLATE utf8_unicode_ci)) d2,
758 COERCIBILITY(s1) d3;
759 DROP TEMPORARY TABLE tmp1;
760 END
761 DROP PROCEDURE p1;
762 DROP TABLE t1;
763 DROP DATABASE bug39182;
764 USE test;
765 CREATE PROCEDURE p1(IN v1 INT)
766 BEGIN
767 CREATE TABLE t1 SELECT v1;
768 DROP TABLE t1;
769 END//
770 CREATE PROCEDURE p2()
771 BEGIN
772 DECLARE v1 INT;
773 CREATE TABLE t1 SELECT v1+1;
774 DROP TABLE t1;
775 END//
776 CREATE PROCEDURE p3(IN v1 INT)
777 BEGIN
778 CREATE TABLE t1 SELECT 1 FROM DUAL WHERE v1!=0;
779 DROP TABLE t1;
780 END//
781 CREATE PROCEDURE p4(IN v1 INT)
782 BEGIN
783 DECLARE v2 INT;
784 CREATE TABLE t1 SELECT 1, v1, v2;
785 DROP TABLE t1;
786 CREATE TABLE t1 SELECT 1, v1+1, v2;
787 DROP TABLE t1;
788 END//
789 CALL p1(1);
790 CALL p2();
791 CALL p3(0);
792 CALL p4(0);
793 DROP PROCEDURE p1;
794 DROP PROCEDURE p2;
795 DROP PROCEDURE p3;
796 DROP PROCEDURE p4;
797 End of 5.0 tests
798 reset master;
799 create table t1 (id tinyint auto_increment primary key);
800 insert into t1 values(5);
801 set insert_id=128;
802 insert into t1 values(null) /* Not binlogged */;
803 ERROR 22003: Out of range value for column 'id' at row 1
804 set insert_id=128;
805 insert ignore into t1 values(null) /* Insert 128 */;
806 Warnings:
807 Warning 167 Out of range value for column 'id' at row 1
808 set insert_id=5;
809 insert into t1 values(null) /* Not binlogged */;
810 ERROR 23000: Duplicate entry '5' for key 'PRIMARY'
811 set insert_id=5;
812 insert ignore into t1 values(null) /* Insert 5 */;
813 Warnings:
814 Warning 1062 Duplicate entry '5' for key 'PRIMARY'
815 select * from t1;
816 id
817 5
818 drop table t1;
819 create table t1 (id tinyint auto_increment primary key) engine=myisam;
820 set insert_id=128;
821 insert into t1 values(5),(null) /* Insert_id 128 */;
822 ERROR 22003: Out of range value for column 'id' at row 2
823 set insert_id=128;
824 insert ignore into t1 values (4),(null) /* Insert_id 128 */;
825 Warnings:
826 Warning 167 Out of range value for column 'id' at row 2
827 set insert_id=5;
828 insert into t1 values(3),(null) /* Insert_id 5 */;
829 ERROR 23000: Duplicate entry '5' for key 'PRIMARY'
830 set insert_id=5;
831 insert ignore into t1 values(2),(null) /* Insert_id 5 */;
832 Warnings:
833 Warning 1062 Duplicate entry '5' for key 'PRIMARY'
834 select * from t1 order by id;
835 id
836 2
837 3
838 4
839 5
840 drop table t1;
841 create table t1 (a int);
842 create table if not exists t2 select * from t1;
843 create temporary table tt1 (a int);
844 create table if not exists t3 like tt1;
845 USE mysql;
846 INSERT db SET host='localhost', user='@#@', db='Just a test';
847 UPDATE db SET db='Another db' WHERE host='localhost' AND user='@#@';
848 DELETE FROM db WHERE host='localhost' AND user='@#@';
849 use test;
850 include/show_binlog_events.inc
851 Log_name Pos Event_type Server_id End_log_pos Info
852 master-bin.000001 # Gtid # # GTID #-#-#
853 master-bin.000001 # Query # # use `test`; create table t1 (id tinyint auto_increment primary key)
854 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
855 master-bin.000001 # Annotate_rows # # insert into t1 values(5)
856 master-bin.000001 # Table_map # # table_id: # (test.t1)
857 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
858 master-bin.000001 # Query # # COMMIT
859 master-bin.000001 # Gtid # # GTID #-#-#
860 master-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
861 master-bin.000001 # Gtid # # GTID #-#-#
862 master-bin.000001 # Query # # use `test`; create table t1 (id tinyint auto_increment primary key) engine=myisam
863 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
864 master-bin.000001 # Annotate_rows # # insert into t1 values(5),(null) /* Insert_id 128 */
865 master-bin.000001 # Table_map # # table_id: # (test.t1)
866 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
867 master-bin.000001 # Query # # COMMIT
868 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
869 master-bin.000001 # Annotate_rows # # insert ignore into t1 values (4),(null) /* Insert_id 128 */
870 master-bin.000001 # Table_map # # table_id: # (test.t1)
871 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
872 master-bin.000001 # Query # # COMMIT
873 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
874 master-bin.000001 # Annotate_rows # # insert into t1 values(3),(null) /* Insert_id 5 */
875 master-bin.000001 # Table_map # # table_id: # (test.t1)
876 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
877 master-bin.000001 # Query # # COMMIT
878 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
879 master-bin.000001 # Annotate_rows # # insert ignore into t1 values(2),(null) /* Insert_id 5 */
880 master-bin.000001 # Table_map # # table_id: # (test.t1)
881 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
882 master-bin.000001 # Query # # COMMIT
883 master-bin.000001 # Gtid # # GTID #-#-#
884 master-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
885 master-bin.000001 # Gtid # # GTID #-#-#
886 master-bin.000001 # Query # # use `test`; create table t1 (a int)
887 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
888 master-bin.000001 # Query # # use `test`; CREATE TABLE IF NOT EXISTS `t2` (
889 `a` int(11) DEFAULT NULL
890 )
891 master-bin.000001 # Query # # COMMIT
892 master-bin.000001 # Gtid # # GTID #-#-#
893 master-bin.000001 # Query # # use `test`; CREATE TABLE IF NOT EXISTS `t3` (
894 `a` int(11) DEFAULT NULL
895 ) ENGINE=MyISAM
896 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
897 master-bin.000001 # Annotate_rows # # INSERT db SET host='localhost', user='@#@', db='Just a test'
898 master-bin.000001 # Table_map # # table_id: # (mysql.db)
899 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
900 master-bin.000001 # Query # # COMMIT
901 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
902 master-bin.000001 # Annotate_rows # # UPDATE db SET db='Another db' WHERE host='localhost' AND user='@#@'
903 master-bin.000001 # Table_map # # table_id: # (mysql.db)
904 master-bin.000001 # Update_rows_v1 # # table_id: # flags: STMT_END_F
905 master-bin.000001 # Query # # COMMIT
906 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
907 master-bin.000001 # Annotate_rows # # DELETE FROM db WHERE host='localhost' AND user='@#@'
908 master-bin.000001 # Table_map # # table_id: # (mysql.db)
909 master-bin.000001 # Delete_rows_v1 # # table_id: # flags: STMT_END_F
910 master-bin.000001 # Query # # COMMIT
911 drop table t1,t2,t3,tt1;
912 reset master;
913 create table t1 (a int not null auto_increment, primary key (a)) engine=myisam;
914 insert /* before delayed */ delayed /* after delayed */ into t1 values (207);
915 insert /*! delayed */ into t1 values (null);
916 insert delayed into t1 values (300);
917 FLUSH TABLES;
918 include/show_binlog_events.inc
919 Log_name Pos Event_type Server_id End_log_pos Info
920 master-bin.000001 # Gtid # # GTID #-#-#
921 master-bin.000001 # Query # # use `test`; create table t1 (a int not null auto_increment, primary key (a)) engine=myisam
922 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
923 master-bin.000001 # Table_map # # table_id: # (test.t1)
924 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
925 master-bin.000001 # Query # # COMMIT
926 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
927 master-bin.000001 # Table_map # # table_id: # (test.t1)
928 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
929 master-bin.000001 # Query # # COMMIT
930 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
931 master-bin.000001 # Table_map # # table_id: # (test.t1)
932 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
933 master-bin.000001 # Query # # COMMIT
934 master-bin.000001 # Gtid # # GTID #-#-#
935 master-bin.000001 # Query # # use `test`; FLUSH TABLES
936 RESET MASTER;
937 insert /* before delayed */ delayed /* after delayed */ into t1 values (null),(null),(null),(null);
938 insert /*! delayed */ into t1 values (null),(null),(400),(null);
939 select * from t1;
940 a
941 207
942 208
943 300
944 301
945 302
946 303
947 304
948 305
949 306
950 400
951 401
952 drop table t1;
953 reset master;
954 drop table if exists t3;
955 create table t3 (a int(11) NOT NULL AUTO_INCREMENT, b text, PRIMARY KEY (a) ) engine=innodb;
956 File master-bin.000001
957 insert into t3(b) values ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa');
958 insert into t3(b) values ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa');
959 insert into t3(b) values ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa');
960 insert into t3(b) values ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa');
961 *** show new binlog index after rotating ***
962 File master-bin.000002
963 drop table t3;
964 #
965 # Bug #45998: database crashes when running "create as select"
966 #
967 CREATE DATABASE test1;
968 USE test1;
969 DROP DATABASE test1;
970 CREATE TABLE test.t1(a int);
971 INSERT INTO test.t1 VALUES (1), (2);
972 CREATE TABLE test.t2 SELECT * FROM test.t1;
973 USE test;
974 DROP TABLES t1, t2;
975 connect fresh,localhost,root,,test;
976 connection fresh;
977 RESET MASTER;
978 CREATE TABLE t1 (a INT PRIMARY KEY);
979 BINLOG '
980 3u9kSA8KAAAAZgAAAGoAAAABAAQANS4xLjM1LW1hcmlhLWJldGExLWRlYnVnLWxvZwAAAAAAAAAA
981 AAAAAAAAAAAAAAAAAADe72RIEzgNAAgAEgAEBAQEEgAAUwAEGggAAAAICAgC
982 ';
983 INSERT INTO t1 VALUES (1);
984 BINLOG '
985 3u9kSBMUAAAAKQAAAJEBAAAAABoAAAAAAAAABHRlc3QAAnQxAAEDAAA=
986 3u9kSBcUAAAAIgAAALMBAAAQABoAAAAAAAEAAf/+AgAAAA==
987 ';
988 SHOW BINLOG EVENTS;
989 Log_name Pos Event_type Server_id End_log_pos Info
990 # # Format_desc 1 # Server ver: #, Binlog ver: #
991 # # Gtid_list 1 # []
992 # # Binlog_checkpoint 1 # master-bin.000001
993 # # Gtid 1 # GTID 0-1-1
994 # # Query 1 # use `test`; CREATE TABLE t1 (a INT PRIMARY KEY)
995 # # Gtid 1 # BEGIN GTID 0-1-2
996 # # Annotate_rows 1 # INSERT INTO t1 VALUES (1)
997 # # Table_map 1 # table_id: # (test.t1)
998 # # Write_rows_v1 1 # table_id: # flags: STMT_END_F
999 # # Query 1 # COMMIT
1000 # # Gtid 1 # BEGIN GTID 0-1-3
1001 # # Annotate_rows 1 # BINLOG '
1002 3u9kSBMUAAAAKQAAAJEBAAAAABoAAAAAAAAABHRlc3QAAnQxAAEDAAA=
1003 3u9kSBcUAAAAIgAAALMBAAAQABoAAAAAAAEAAf/+AgAAAA==
1004 '
1005 # # Table_map 1 # table_id: # (test.t1)
1006 # # Write_rows_v1 1 # table_id: # flags: STMT_END_F
1007 # # Query 1 # COMMIT
1008 DROP TABLE t1;
1009
1010 # BUG#54903 BINLOG statement toggles session variables
1011 # ----------------------------------------------------------------------
1012 # This test verify that BINLOG statement doesn't change current session's
1013 # variables foreign_key_checks and unique_checks.
1014
1015 CREATE TABLE t1 (c1 INT KEY);
1016 SET @@SESSION.foreign_key_checks= ON;
1017 SET @@SESSION.unique_checks= ON;
1018 # INSERT INTO t1 VALUES (1)
1019 # foreign_key_checks=0 and unique_checks=0
1020 BINLOG '
1021 dfLtTBMBAAAAKQAAANcAAAAAABcAAAAAAAEABHRlc3QAAnQxAAEDAAE=
1022 dfLtTBcBAAAAIgAAAPkAAAAAABcAAAAAAAcAAf/+AQAAAA==
1023 ';
1024 SELECT * FROM t1;
1025 c1
1026 1
1027 # Their values should be ON
1028 SHOW SESSION VARIABLES LIKE "foreign_key_checks";
1029 Variable_name Value
1030 foreign_key_checks ON
1031 SHOW SESSION VARIABLES LIKE "unique_checks";
1032 Variable_name Value
1033 unique_checks ON
1034
1035 SET @@SESSION.foreign_key_checks= OFF;
1036 SET @@SESSION.unique_checks= OFF;
1037 # INSERT INTO t1 VALUES(2)
1038 # foreign_key_checks=1 and unique_checks=1
1039 BINLOG '
1040 dfLtTBMBAAAAKQAAAKsBAAAAABcAAAAAAAEABHRlc3QAAnQxAAEDAAE=
1041 dfLtTBcBAAAAIgAAAM0BAAAAABcAAAAAAAEAAf/+AgAAAA==
1042 ';
1043 SELECT * FROM t1;
1044 c1
1045 1
1046 2
1047 # Their values should be OFF
1048 SHOW SESSION VARIABLES LIKE "foreign_key_checks";
1049 Variable_name Value
1050 foreign_key_checks OFF
1051 SHOW SESSION VARIABLES LIKE "unique_checks";
1052 Variable_name Value
1053 unique_checks OFF
1054 # INSERT INTO t1 VALUES(2)
1055 # foreign_key_checks=1 and unique_checks=1
1056 # It should not change current session's variables, even error happens
1057 call mtr.add_suppression("BINLOG_BASE64_EVENT.*Could not execute Write_rows_v1 event on table test.t1; Duplicate entry .2. for key .PRIMARY., Error_code: 1062");
1058 BINLOG '
1059 dfLtTBMBAAAAKQAAAKsBAAAAABcAAAAAAAEABHRlc3QAAnQxAAEDAAE=
1060 dfLtTBcBAAAAIgAAAM0BAAAAABcAAAAAAAEAAf/+AgAAAA==
1061 ';
1062 ERROR 23000: Duplicate entry '2' for key 'PRIMARY'
1063 SELECT * FROM t1;
1064 c1
1065 1
1066 2
1067 # Their values should be OFF
1068 SHOW SESSION VARIABLES LIKE "foreign_key_checks";
1069 Variable_name Value
1070 foreign_key_checks OFF
1071 SHOW SESSION VARIABLES LIKE "unique_checks";
1072 Variable_name Value
1073 unique_checks OFF
1074 DROP TABLE t1;
1075 disconnect fresh;
1076 connection default;
1077 #
1078 # MDEV-25595 DROP part of failed CREATE OR REPLACE is not written into binary log
1079 #
1080 reset master;
1081 create table t as select 1 as b, 2 as b;
1082 ERROR 42S21: Duplicate column name 'b'
1083 create table t (old_table_field int);
1084 create or replace table t as select 1 as b, 2 as b;
1085 ERROR 42S21: Duplicate column name 'b'
1086 create or replace temporary table t as select 1 as b, 2 as b;
1087 ERROR 42S21: Duplicate column name 'b'
1088 create table t (new_table_field int);
1089 include/show_binlog_events.inc
1090 Log_name Pos Event_type Server_id End_log_pos Info
1091 master-bin.000001 # Gtid # # GTID #-#-#
1092 master-bin.000001 # Query # # use `test`; create table t (old_table_field int)
1093 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1094 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `test`.`t`/* Generated to handle failed CREATE OR REPLACE */
1095 master-bin.000001 # Query # # ROLLBACK
1096 master-bin.000001 # Gtid # # GTID #-#-#
1097 master-bin.000001 # Query # # use `test`; create table t (new_table_field int)
1098 drop table t;