Debian Codegraph @

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

raw
1 set @old_binlog_checksum=@@binlog_checksum;
2 set global binlog_checksum=NONE;
3 set sql_mode="";
4 SET timestamp=1000000000;
5 RESET MASTER;
6 CREATE DATABASE test1;
7 CREATE TABLE test1.t1(a int);
8 CREATE DATABASE test2;
9 CREATE TABLE test2.t2(a int);
10 CREATE VIEW test2.v2 AS SELECT * FROM test2.t2;
11 CREATE DATABASE test3;
12 CREATE TABLE test3.t3(a int);
13 CREATE DATABASE xtest1;
14 CREATE TABLE xtest1.xt1(a int);
15 CREATE DATABASE xtest2;
16 CREATE TABLE xtest2.xt2(a int);
17 INSERT INTO test1.t1 VALUES (1), (2), (3);
18 SET SESSION binlog_annotate_row_events = ON;
19 INSERT INTO test2.t2 VALUES (1), (2), (3);
20 INSERT INTO test3.t3 VALUES (1), (2), (3);
21 DELETE test1.t1, test2.t2
22 FROM test1.t1 INNER JOIN test2.t2 INNER JOIN test3.t3
23 WHERE test1.t1.a=test2.t2.a AND test2.t2.a=test3.t3.a;
24 INSERT INTO xtest1.xt1 VALUES (1), (2), (3);
25 INSERT INTO test2.v2 VALUES (1), (2), (3);
26 DELETE xtest1.xt1, test2.t2
27 FROM xtest1.xt1 INNER JOIN test2.t2 INNER JOIN test3.t3
28 WHERE xtest1.xt1.a=test2.t2.a AND test2.t2.a=test3.t3.a;
29 INSERT INTO xtest1.xt1 VALUES (1), (2), (3);
30 INSERT INTO xtest2.xt2 VALUES (1), (2), (3);
31 DELETE xtest1.xt1, xtest2.xt2
32 FROM xtest1.xt1 INNER JOIN xtest2.xt2 INNER JOIN test3.t3
33 WHERE xtest1.xt1.a=xtest2.xt2.a AND xtest2.xt2.a=test3.t3.a;
34 FLUSH LOGS;
35 #####################################################################################
36 # The following Annotate_rows events should appear below:
37 # - INSERT INTO test2.t2 VALUES (1), (2), (3)
38 # - INSERT INTO test3.t3 VALUES (1), (2), (3)
39 # - DELETE test1.t1, test2.t2 FROM <...>
40 # - INSERT INTO test2.t2 VALUES (1), (2), (3)
41 # - DELETE xtest1.xt1, test2.t2 FROM <...>
42 #####################################################################################
43 include/show_binlog_events.inc
44 Log_name Pos Event_type Server_id End_log_pos Info
45 master-bin.000001 # Gtid # # GTID #-#-#
46 master-bin.000001 # Query # # CREATE DATABASE test1
47 master-bin.000001 # Gtid # # GTID #-#-#
48 master-bin.000001 # Query # # CREATE DATABASE test2
49 master-bin.000001 # Gtid # # GTID #-#-#
50 master-bin.000001 # Query # # CREATE DATABASE test3
51 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
52 master-bin.000001 # Annotate_rows # # INSERT INTO test1.t1 VALUES (1), (2), (3)
53 master-bin.000001 # Table_map # # table_id: # (test1.t1)
54 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
55 master-bin.000001 # Query # # COMMIT
56 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
57 master-bin.000001 # Annotate_rows # # INSERT INTO test2.t2 VALUES (1), (2), (3)
58 master-bin.000001 # Table_map # # table_id: # (test2.t2)
59 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
60 master-bin.000001 # Query # # COMMIT
61 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
62 master-bin.000001 # Annotate_rows # # INSERT INTO test3.t3 VALUES (1), (2), (3)
63 master-bin.000001 # Table_map # # table_id: # (test3.t3)
64 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
65 master-bin.000001 # Query # # COMMIT
66 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
67 master-bin.000001 # Annotate_rows # # DELETE test1.t1, test2.t2
68 FROM test1.t1 INNER JOIN test2.t2 INNER JOIN test3.t3
69 WHERE test1.t1.a=test2.t2.a AND test2.t2.a=test3.t3.a
70 master-bin.000001 # Table_map # # table_id: # (test1.t1)
71 master-bin.000001 # Table_map # # table_id: # (test2.t2)
72 master-bin.000001 # Delete_rows_v1 # # table_id: #
73 master-bin.000001 # Delete_rows_v1 # # table_id: # flags: STMT_END_F
74 master-bin.000001 # Query # # COMMIT
75 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
76 master-bin.000001 # Annotate_rows # # INSERT INTO test2.v2 VALUES (1), (2), (3)
77 master-bin.000001 # Table_map # # table_id: # (test2.t2)
78 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
79 master-bin.000001 # Query # # COMMIT
80 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
81 master-bin.000001 # Annotate_rows # # DELETE xtest1.xt1, test2.t2
82 FROM xtest1.xt1 INNER JOIN test2.t2 INNER JOIN test3.t3
83 WHERE xtest1.xt1.a=test2.t2.a AND test2.t2.a=test3.t3.a
84 master-bin.000001 # Table_map # # table_id: # (test2.t2)
85 master-bin.000001 # Delete_rows_v1 # # table_id: # flags: STMT_END_F
86 master-bin.000001 # Query # # COMMIT
87 master-bin.000001 # Rotate # # master-bin.000002;pos=POS
88 #
89 #####################################################################################
90 # mysqlbinlog
91 # The following Annotates should appear in this output:
92 # - INSERT INTO test2.t2 VALUES (1), (2), (3)
93 # - INSERT INTO test3.t3 VALUES (1), (2), (3)
94 # - DELETE test1.t1, test2.t2 FROM <...> (with two subsequent Table maps)
95 # - INSERT INTO test2.t2 VALUES (1), (2), (3)
96 # - DELETE xtest1.xt1, test2.t2 FROM <...> (with one subsequent Table map)
97 #####################################################################################
98 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
99 /*!40019 SET @@session.max_delayed_threads=0*/;
100 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
101 DELIMITER /*!*/;
102 # at #
103 #010909 4:46:40 server id # end_log_pos # Start: binlog v 4, server v #.##.## created 010909 4:46:40 at startup
104 ROLLBACK/*!*/;
105 # at #
106 #010909 4:46:40 server id # end_log_pos # Gtid list []
107 # at #
108 #010909 4:46:40 server id # end_log_pos # Binlog checkpoint master-bin.000001
109 # at #
110 #010909 4:46:40 server id # end_log_pos # GTID 0-1-1 ddl thread_id=#
111 /*M!100101 SET @@session.skip_parallel_replication=0*//*!*/;
112 /*M!100001 SET @@session.gtid_domain_id=0*//*!*/;
113 /*M!100001 SET @@session.server_id=1*//*!*/;
114 /*M!100001 SET @@session.gtid_seq_no=1*//*!*/;
115 # at #
116 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
117 SET TIMESTAMP=1000000000/*!*/;
118 SET @@session.pseudo_thread_id=#/*!*/;
119 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1, @@session.check_constraint_checks=1, @@session.sql_if_exists=0, @@session.explicit_defaults_for_timestamp=1, @@session.system_versioning_insert_history=0/*!*/;
120 SET @@session.sql_mode=0/*!*/;
121 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
122 /*!\C latin1 *//*!*/;
123 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
124 SET @@session.lc_time_names=0/*!*/;
125 SET @@session.collation_database=DEFAULT/*!*/;
126 CREATE DATABASE test1
127 /*!*/;
128 # at #
129 #010909 4:46:40 server id # end_log_pos # GTID 0-1-2 ddl thread_id=#
130 /*M!100001 SET @@session.gtid_seq_no=2*//*!*/;
131 # at #
132 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
133 SET TIMESTAMP=1000000000/*!*/;
134 CREATE DATABASE test2
135 /*!*/;
136 # at #
137 #010909 4:46:40 server id # end_log_pos # GTID 0-1-3 ddl thread_id=#
138 /*M!100001 SET @@session.gtid_seq_no=3*//*!*/;
139 # at #
140 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
141 SET TIMESTAMP=1000000000/*!*/;
142 CREATE DATABASE test3
143 /*!*/;
144 # at #
145 #010909 4:46:40 server id # end_log_pos # GTID 0-1-4 thread_id=#
146 /*M!100001 SET @@session.gtid_seq_no=4*//*!*/;
147 START TRANSACTION
148 /*!*/;
149 # at #
150 # at #
151 #010909 4:46:40 server id # end_log_pos # Annotate_rows:
152 #Q> INSERT INTO test1.t1 VALUES (1), (2), (3)
153 #010909 4:46:40 server id # end_log_pos # Table_map: `test1`.`t1` mapped to number #
154 # at #
155 #010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F
156 ### INSERT INTO `test1`.`t1`
157 ### SET
158 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
159 ### INSERT INTO `test1`.`t1`
160 ### SET
161 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
162 ### INSERT INTO `test1`.`t1`
163 ### SET
164 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
165 # Number of rows: 3
166 # at #
167 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
168 SET TIMESTAMP=1000000000/*!*/;
169 COMMIT
170 /*!*/;
171 # at #
172 #010909 4:46:40 server id # end_log_pos # GTID 0-1-5 thread_id=#
173 /*M!100001 SET @@session.gtid_seq_no=5*//*!*/;
174 START TRANSACTION
175 /*!*/;
176 # at #
177 # at #
178 #010909 4:46:40 server id # end_log_pos # Annotate_rows:
179 #Q> INSERT INTO test2.t2 VALUES (1), (2), (3)
180 #010909 4:46:40 server id # end_log_pos # Table_map: `test2`.`t2` mapped to number #
181 # at #
182 #010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F
183 ### INSERT INTO `test2`.`t2`
184 ### SET
185 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
186 ### INSERT INTO `test2`.`t2`
187 ### SET
188 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
189 ### INSERT INTO `test2`.`t2`
190 ### SET
191 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
192 # Number of rows: 3
193 # at #
194 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
195 SET TIMESTAMP=1000000000/*!*/;
196 COMMIT
197 /*!*/;
198 # at #
199 #010909 4:46:40 server id # end_log_pos # GTID 0-1-6 thread_id=#
200 /*M!100001 SET @@session.gtid_seq_no=6*//*!*/;
201 START TRANSACTION
202 /*!*/;
203 # at #
204 # at #
205 #010909 4:46:40 server id # end_log_pos # Annotate_rows:
206 #Q> INSERT INTO test3.t3 VALUES (1), (2), (3)
207 #010909 4:46:40 server id # end_log_pos # Table_map: `test3`.`t3` mapped to number #
208 # at #
209 #010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F
210 ### INSERT INTO `test3`.`t3`
211 ### SET
212 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
213 ### INSERT INTO `test3`.`t3`
214 ### SET
215 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
216 ### INSERT INTO `test3`.`t3`
217 ### SET
218 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
219 # Number of rows: 3
220 # at #
221 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
222 SET TIMESTAMP=1000000000/*!*/;
223 COMMIT
224 /*!*/;
225 # at #
226 #010909 4:46:40 server id # end_log_pos # GTID 0-1-7 thread_id=#
227 /*M!100001 SET @@session.gtid_seq_no=7*//*!*/;
228 START TRANSACTION
229 /*!*/;
230 # at #
231 # at #
232 #010909 4:46:40 server id # end_log_pos # Annotate_rows:
233 #Q> DELETE test1.t1, test2.t2
234 #Q> FROM test1.t1 INNER JOIN test2.t2 INNER JOIN test3.t3
235 #Q> WHERE test1.t1.a=test2.t2.a AND test2.t2.a=test3.t3.a
236 #010909 4:46:40 server id # end_log_pos # Table_map: `test1`.`t1` mapped to number #
237 # at #
238 #010909 4:46:40 server id # end_log_pos # Table_map: `test2`.`t2` mapped to number #
239 # at #
240 # at #
241 #010909 4:46:40 server id # end_log_pos # Delete_rows: table id #
242 #010909 4:46:40 server id # end_log_pos # Delete_rows: table id # flags: STMT_END_F
243 ### DELETE FROM `test1`.`t1`
244 ### WHERE
245 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
246 ### DELETE FROM `test1`.`t1`
247 ### WHERE
248 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
249 ### DELETE FROM `test1`.`t1`
250 ### WHERE
251 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
252 ### DELETE FROM `test2`.`t2`
253 ### WHERE
254 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
255 ### DELETE FROM `test2`.`t2`
256 ### WHERE
257 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
258 ### DELETE FROM `test2`.`t2`
259 ### WHERE
260 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
261 # Number of rows: 6
262 # at #
263 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
264 SET TIMESTAMP=1000000000/*!*/;
265 COMMIT
266 /*!*/;
267 # at #
268 #010909 4:46:40 server id # end_log_pos # GTID 0-1-8 thread_id=#
269 /*M!100001 SET @@session.gtid_seq_no=8*//*!*/;
270 START TRANSACTION
271 /*!*/;
272 # at #
273 # at #
274 #010909 4:46:40 server id # end_log_pos # Annotate_rows:
275 #Q> INSERT INTO test2.v2 VALUES (1), (2), (3)
276 #010909 4:46:40 server id # end_log_pos # Table_map: `test2`.`t2` mapped to number #
277 # at #
278 #010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F
279 ### INSERT INTO `test2`.`t2`
280 ### SET
281 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
282 ### INSERT INTO `test2`.`t2`
283 ### SET
284 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
285 ### INSERT INTO `test2`.`t2`
286 ### SET
287 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
288 # Number of rows: 3
289 # at #
290 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
291 SET TIMESTAMP=1000000000/*!*/;
292 COMMIT
293 /*!*/;
294 # at #
295 #010909 4:46:40 server id # end_log_pos # GTID 0-1-9 thread_id=#
296 /*M!100001 SET @@session.gtid_seq_no=9*//*!*/;
297 START TRANSACTION
298 /*!*/;
299 # at #
300 # at #
301 #010909 4:46:40 server id # end_log_pos # Annotate_rows:
302 #Q> DELETE xtest1.xt1, test2.t2
303 #Q> FROM xtest1.xt1 INNER JOIN test2.t2 INNER JOIN test3.t3
304 #Q> WHERE xtest1.xt1.a=test2.t2.a AND test2.t2.a=test3.t3.a
305 #010909 4:46:40 server id # end_log_pos # Table_map: `test2`.`t2` mapped to number #
306 # at #
307 #010909 4:46:40 server id # end_log_pos # Delete_rows: table id # flags: STMT_END_F
308 ### DELETE FROM `test2`.`t2`
309 ### WHERE
310 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
311 ### DELETE FROM `test2`.`t2`
312 ### WHERE
313 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
314 ### DELETE FROM `test2`.`t2`
315 ### WHERE
316 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
317 # Number of rows: 3
318 # at #
319 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
320 SET TIMESTAMP=1000000000/*!*/;
321 COMMIT
322 /*!*/;
323 # at #
324 #010909 4:46:40 server id # end_log_pos # Rotate to master-bin.000002 pos: 4
325 DELIMITER ;
326 # End of log file
327 ROLLBACK /* added by mysqlbinlog */;
328 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
329 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
330 #
331 #####################################################################################
332 # mysqlbinlog --database=test1
333 # The following Annotate should appear in this output:
334 # - DELETE test1.t1, test2.t2 FROM <...>
335 #####################################################################################
336 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
337 /*!40019 SET @@session.max_delayed_threads=0*/;
338 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
339 DELIMITER /*!*/;
340 # at #
341 #010909 4:46:40 server id # end_log_pos # Start: binlog v 4, server v #.##.## created 010909 4:46:40 at startup
342 ROLLBACK/*!*/;
343 # at #
344 #010909 4:46:40 server id # end_log_pos # Gtid list []
345 # at #
346 #010909 4:46:40 server id # end_log_pos # Binlog checkpoint master-bin.000001
347 # at #
348 #010909 4:46:40 server id # end_log_pos # GTID 0-1-1 ddl thread_id=#
349 /*M!100101 SET @@session.skip_parallel_replication=0*//*!*/;
350 /*M!100001 SET @@session.gtid_domain_id=0*//*!*/;
351 /*M!100001 SET @@session.server_id=1*//*!*/;
352 /*M!100001 SET @@session.gtid_seq_no=1*//*!*/;
353 # at #
354 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
355 SET TIMESTAMP=1000000000/*!*/;
356 SET @@session.pseudo_thread_id=#/*!*/;
357 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1, @@session.check_constraint_checks=1, @@session.sql_if_exists=0, @@session.explicit_defaults_for_timestamp=1, @@session.system_versioning_insert_history=0/*!*/;
358 SET @@session.sql_mode=0/*!*/;
359 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
360 /*!\C latin1 *//*!*/;
361 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
362 SET @@session.lc_time_names=0/*!*/;
363 SET @@session.collation_database=DEFAULT/*!*/;
364 CREATE DATABASE test1
365 /*!*/;
366 # at #
367 #010909 4:46:40 server id # end_log_pos # GTID 0-1-2 ddl thread_id=#
368 /*M!100001 SET @@session.gtid_seq_no=2*//*!*/;
369 # at #
370 # at #
371 #010909 4:46:40 server id # end_log_pos # GTID 0-1-3 ddl thread_id=#
372 /*M!100001 SET @@session.gtid_seq_no=3*//*!*/;
373 # at #
374 # at #
375 #010909 4:46:40 server id # end_log_pos # GTID 0-1-4 thread_id=#
376 /*M!100001 SET @@session.gtid_seq_no=4*//*!*/;
377 START TRANSACTION
378 /*!*/;
379 # at #
380 # at #
381 #010909 4:46:40 server id # end_log_pos # Annotate_rows:
382 #Q> INSERT INTO test1.t1 VALUES (1), (2), (3)
383 #010909 4:46:40 server id # end_log_pos # Table_map: `test1`.`t1` mapped to number #
384 # at #
385 #010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F
386 ### INSERT INTO `test1`.`t1`
387 ### SET
388 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
389 ### INSERT INTO `test1`.`t1`
390 ### SET
391 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
392 ### INSERT INTO `test1`.`t1`
393 ### SET
394 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
395 # Number of rows: 3
396 # at #
397 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
398 SET TIMESTAMP=1000000000/*!*/;
399 COMMIT
400 /*!*/;
401 # at #
402 #010909 4:46:40 server id # end_log_pos # GTID 0-1-5 thread_id=#
403 /*M!100001 SET @@session.gtid_seq_no=5*//*!*/;
404 START TRANSACTION
405 /*!*/;
406 # at #
407 # at #
408 # at #
409 # at #
410 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
411 SET TIMESTAMP=1000000000/*!*/;
412 COMMIT
413 /*!*/;
414 # at #
415 #010909 4:46:40 server id # end_log_pos # GTID 0-1-6 thread_id=#
416 /*M!100001 SET @@session.gtid_seq_no=6*//*!*/;
417 START TRANSACTION
418 /*!*/;
419 # at #
420 # at #
421 # at #
422 # at #
423 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
424 SET TIMESTAMP=1000000000/*!*/;
425 COMMIT
426 /*!*/;
427 # at #
428 #010909 4:46:40 server id # end_log_pos # GTID 0-1-7 thread_id=#
429 /*M!100001 SET @@session.gtid_seq_no=7*//*!*/;
430 START TRANSACTION
431 /*!*/;
432 # at #
433 # at #
434 #010909 4:46:40 server id # end_log_pos # Annotate_rows:
435 #Q> DELETE test1.t1, test2.t2
436 #Q> FROM test1.t1 INNER JOIN test2.t2 INNER JOIN test3.t3
437 #Q> WHERE test1.t1.a=test2.t2.a AND test2.t2.a=test3.t3.a
438 #010909 4:46:40 server id # end_log_pos # Table_map: `test1`.`t1` mapped to number #
439 # at #
440 # at #
441 # at #
442 #010909 4:46:40 server id # end_log_pos # Delete_rows: table id #
443 ### DELETE FROM `test1`.`t1`
444 ### WHERE
445 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
446 ### DELETE FROM `test1`.`t1`
447 ### WHERE
448 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
449 ### DELETE FROM `test1`.`t1`
450 ### WHERE
451 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
452 # at #
453 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
454 SET TIMESTAMP=1000000000/*!*/;
455 COMMIT
456 /*!*/;
457 # at #
458 #010909 4:46:40 server id # end_log_pos # GTID 0-1-8 thread_id=#
459 /*M!100001 SET @@session.gtid_seq_no=8*//*!*/;
460 START TRANSACTION
461 /*!*/;
462 # at #
463 # at #
464 # at #
465 # at #
466 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
467 SET TIMESTAMP=1000000000/*!*/;
468 COMMIT
469 /*!*/;
470 # at #
471 #010909 4:46:40 server id # end_log_pos # GTID 0-1-9 thread_id=#
472 /*M!100001 SET @@session.gtid_seq_no=9*//*!*/;
473 START TRANSACTION
474 /*!*/;
475 # at #
476 # at #
477 # at #
478 # at #
479 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
480 SET TIMESTAMP=1000000000/*!*/;
481 COMMIT
482 /*!*/;
483 # at #
484 #010909 4:46:40 server id # end_log_pos # Rotate to master-bin.000002 pos: 4
485 DELIMITER ;
486 # End of log file
487 ROLLBACK /* added by mysqlbinlog */;
488 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
489 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
490 #
491 #####################################################################################
492 # mysqlbinlog --skip-annotate-row-events
493 # No Annotates should appear in this output
494 #####################################################################################
495 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
496 /*!40019 SET @@session.max_delayed_threads=0*/;
497 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
498 DELIMITER /*!*/;
499 # at #
500 #010909 4:46:40 server id # end_log_pos # Start: binlog v 4, server v #.##.## created 010909 4:46:40 at startup
501 ROLLBACK/*!*/;
502 # at #
503 #010909 4:46:40 server id # end_log_pos # Gtid list []
504 # at #
505 #010909 4:46:40 server id # end_log_pos # Binlog checkpoint master-bin.000001
506 # at #
507 #010909 4:46:40 server id # end_log_pos # GTID 0-1-1 ddl thread_id=#
508 /*M!100101 SET @@session.skip_parallel_replication=0*//*!*/;
509 /*M!100001 SET @@session.gtid_domain_id=0*//*!*/;
510 /*M!100001 SET @@session.server_id=1*//*!*/;
511 /*M!100001 SET @@session.gtid_seq_no=1*//*!*/;
512 # at #
513 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
514 SET TIMESTAMP=1000000000/*!*/;
515 SET @@session.pseudo_thread_id=#/*!*/;
516 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1, @@session.check_constraint_checks=1, @@session.sql_if_exists=0, @@session.explicit_defaults_for_timestamp=1, @@session.system_versioning_insert_history=0/*!*/;
517 SET @@session.sql_mode=0/*!*/;
518 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
519 /*!\C latin1 *//*!*/;
520 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
521 SET @@session.lc_time_names=0/*!*/;
522 SET @@session.collation_database=DEFAULT/*!*/;
523 CREATE DATABASE test1
524 /*!*/;
525 # at #
526 #010909 4:46:40 server id # end_log_pos # GTID 0-1-2 ddl thread_id=#
527 /*M!100001 SET @@session.gtid_seq_no=2*//*!*/;
528 # at #
529 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
530 SET TIMESTAMP=1000000000/*!*/;
531 CREATE DATABASE test2
532 /*!*/;
533 # at #
534 #010909 4:46:40 server id # end_log_pos # GTID 0-1-3 ddl thread_id=#
535 /*M!100001 SET @@session.gtid_seq_no=3*//*!*/;
536 # at #
537 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
538 SET TIMESTAMP=1000000000/*!*/;
539 CREATE DATABASE test3
540 /*!*/;
541 # at #
542 #010909 4:46:40 server id # end_log_pos # GTID 0-1-4 thread_id=#
543 /*M!100001 SET @@session.gtid_seq_no=4*//*!*/;
544 START TRANSACTION
545 /*!*/;
546 # at #
547 # at #
548 #010909 4:46:40 server id # end_log_pos # Table_map: `test1`.`t1` mapped to number #
549 # at #
550 #010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F
551 ### INSERT INTO `test1`.`t1`
552 ### SET
553 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
554 ### INSERT INTO `test1`.`t1`
555 ### SET
556 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
557 ### INSERT INTO `test1`.`t1`
558 ### SET
559 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
560 # Number of rows: 3
561 # at #
562 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
563 SET TIMESTAMP=1000000000/*!*/;
564 COMMIT
565 /*!*/;
566 # at #
567 #010909 4:46:40 server id # end_log_pos # GTID 0-1-5 thread_id=#
568 /*M!100001 SET @@session.gtid_seq_no=5*//*!*/;
569 START TRANSACTION
570 /*!*/;
571 # at #
572 # at #
573 #010909 4:46:40 server id # end_log_pos # Table_map: `test2`.`t2` mapped to number #
574 # at #
575 #010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F
576 ### INSERT INTO `test2`.`t2`
577 ### SET
578 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
579 ### INSERT INTO `test2`.`t2`
580 ### SET
581 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
582 ### INSERT INTO `test2`.`t2`
583 ### SET
584 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
585 # Number of rows: 3
586 # at #
587 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
588 SET TIMESTAMP=1000000000/*!*/;
589 COMMIT
590 /*!*/;
591 # at #
592 #010909 4:46:40 server id # end_log_pos # GTID 0-1-6 thread_id=#
593 /*M!100001 SET @@session.gtid_seq_no=6*//*!*/;
594 START TRANSACTION
595 /*!*/;
596 # at #
597 # at #
598 #010909 4:46:40 server id # end_log_pos # Table_map: `test3`.`t3` mapped to number #
599 # at #
600 #010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F
601 ### INSERT INTO `test3`.`t3`
602 ### SET
603 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
604 ### INSERT INTO `test3`.`t3`
605 ### SET
606 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
607 ### INSERT INTO `test3`.`t3`
608 ### SET
609 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
610 # Number of rows: 3
611 # at #
612 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
613 SET TIMESTAMP=1000000000/*!*/;
614 COMMIT
615 /*!*/;
616 # at #
617 #010909 4:46:40 server id # end_log_pos # GTID 0-1-7 thread_id=#
618 /*M!100001 SET @@session.gtid_seq_no=7*//*!*/;
619 START TRANSACTION
620 /*!*/;
621 # at #
622 # at #
623 #010909 4:46:40 server id # end_log_pos # Table_map: `test1`.`t1` mapped to number #
624 # at #
625 #010909 4:46:40 server id # end_log_pos # Table_map: `test2`.`t2` mapped to number #
626 # at #
627 # at #
628 #010909 4:46:40 server id # end_log_pos # Delete_rows: table id #
629 #010909 4:46:40 server id # end_log_pos # Delete_rows: table id # flags: STMT_END_F
630 ### DELETE FROM `test1`.`t1`
631 ### WHERE
632 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
633 ### DELETE FROM `test1`.`t1`
634 ### WHERE
635 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
636 ### DELETE FROM `test1`.`t1`
637 ### WHERE
638 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
639 ### DELETE FROM `test2`.`t2`
640 ### WHERE
641 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
642 ### DELETE FROM `test2`.`t2`
643 ### WHERE
644 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
645 ### DELETE FROM `test2`.`t2`
646 ### WHERE
647 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
648 # Number of rows: 6
649 # at #
650 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
651 SET TIMESTAMP=1000000000/*!*/;
652 COMMIT
653 /*!*/;
654 # at #
655 #010909 4:46:40 server id # end_log_pos # GTID 0-1-8 thread_id=#
656 /*M!100001 SET @@session.gtid_seq_no=8*//*!*/;
657 START TRANSACTION
658 /*!*/;
659 # at #
660 # at #
661 #010909 4:46:40 server id # end_log_pos # Table_map: `test2`.`t2` mapped to number #
662 # at #
663 #010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F
664 ### INSERT INTO `test2`.`t2`
665 ### SET
666 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
667 ### INSERT INTO `test2`.`t2`
668 ### SET
669 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
670 ### INSERT INTO `test2`.`t2`
671 ### SET
672 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
673 # Number of rows: 3
674 # at #
675 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
676 SET TIMESTAMP=1000000000/*!*/;
677 COMMIT
678 /*!*/;
679 # at #
680 #010909 4:46:40 server id # end_log_pos # GTID 0-1-9 thread_id=#
681 /*M!100001 SET @@session.gtid_seq_no=9*//*!*/;
682 START TRANSACTION
683 /*!*/;
684 # at #
685 # at #
686 #010909 4:46:40 server id # end_log_pos # Table_map: `test2`.`t2` mapped to number #
687 # at #
688 #010909 4:46:40 server id # end_log_pos # Delete_rows: table id # flags: STMT_END_F
689 ### DELETE FROM `test2`.`t2`
690 ### WHERE
691 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
692 ### DELETE FROM `test2`.`t2`
693 ### WHERE
694 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
695 ### DELETE FROM `test2`.`t2`
696 ### WHERE
697 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
698 # Number of rows: 3
699 # at #
700 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
701 SET TIMESTAMP=1000000000/*!*/;
702 COMMIT
703 /*!*/;
704 # at #
705 #010909 4:46:40 server id # end_log_pos # Rotate to master-bin.000002 pos: 4
706 DELIMITER ;
707 # End of log file
708 ROLLBACK /* added by mysqlbinlog */;
709 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
710 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
711 #
712 #####################################################################################
713 # mysqlbinlog --read-from-remote-server
714 # The following Annotates should appear in this output:
715 # - INSERT INTO test2.t2 VALUES (1), (2), (3)
716 # - INSERT INTO test3.t3 VALUES (1), (2), (3)
717 # - DELETE test1.t1, test2.t2 FROM <...> (with two subsequent Table maps)
718 # - INSERT INTO test2.t2 VALUES (1), (2), (3)
719 # - DELETE xtest1.xt1, test2.t2 FROM <...> (with one subsequent Table map)
720 #####################################################################################
721 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
722 /*!40019 SET @@session.max_delayed_threads=0*/;
723 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
724 DELIMITER /*!*/;
725 # at #
726 #010909 4:46:40 server id # end_log_pos # Start: binlog v 4, server v #.##.## created 010909 4:46:40 at startup
727 ROLLBACK/*!*/;
728 # at #
729 #010909 4:46:40 server id # end_log_pos # Gtid list []
730 # at #
731 #010909 4:46:40 server id # end_log_pos # Binlog checkpoint master-bin.000001
732 # at #
733 #010909 4:46:40 server id # end_log_pos # GTID 0-1-1 ddl thread_id=#
734 /*M!100101 SET @@session.skip_parallel_replication=0*//*!*/;
735 /*M!100001 SET @@session.gtid_domain_id=0*//*!*/;
736 /*M!100001 SET @@session.server_id=1*//*!*/;
737 /*M!100001 SET @@session.gtid_seq_no=1*//*!*/;
738 # at #
739 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
740 SET TIMESTAMP=1000000000/*!*/;
741 SET @@session.pseudo_thread_id=#/*!*/;
742 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1, @@session.check_constraint_checks=1, @@session.sql_if_exists=0, @@session.explicit_defaults_for_timestamp=1, @@session.system_versioning_insert_history=0/*!*/;
743 SET @@session.sql_mode=0/*!*/;
744 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
745 /*!\C latin1 *//*!*/;
746 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
747 SET @@session.lc_time_names=0/*!*/;
748 SET @@session.collation_database=DEFAULT/*!*/;
749 CREATE DATABASE test1
750 /*!*/;
751 # at #
752 #010909 4:46:40 server id # end_log_pos # GTID 0-1-2 ddl thread_id=#
753 /*M!100001 SET @@session.gtid_seq_no=2*//*!*/;
754 # at #
755 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
756 SET TIMESTAMP=1000000000/*!*/;
757 CREATE DATABASE test2
758 /*!*/;
759 # at #
760 #010909 4:46:40 server id # end_log_pos # GTID 0-1-3 ddl thread_id=#
761 /*M!100001 SET @@session.gtid_seq_no=3*//*!*/;
762 # at #
763 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
764 SET TIMESTAMP=1000000000/*!*/;
765 CREATE DATABASE test3
766 /*!*/;
767 # at #
768 #010909 4:46:40 server id # end_log_pos # GTID 0-1-4 thread_id=#
769 /*M!100001 SET @@session.gtid_seq_no=4*//*!*/;
770 START TRANSACTION
771 /*!*/;
772 # at #
773 # at #
774 #010909 4:46:40 server id # end_log_pos # Annotate_rows:
775 #Q> INSERT INTO test1.t1 VALUES (1), (2), (3)
776 #010909 4:46:40 server id # end_log_pos # Table_map: `test1`.`t1` mapped to number #
777 # at #
778 #010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F
779 ### INSERT INTO `test1`.`t1`
780 ### SET
781 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
782 ### INSERT INTO `test1`.`t1`
783 ### SET
784 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
785 ### INSERT INTO `test1`.`t1`
786 ### SET
787 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
788 # Number of rows: 3
789 # at #
790 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
791 SET TIMESTAMP=1000000000/*!*/;
792 COMMIT
793 /*!*/;
794 # at #
795 #010909 4:46:40 server id # end_log_pos # GTID 0-1-5 thread_id=#
796 /*M!100001 SET @@session.gtid_seq_no=5*//*!*/;
797 START TRANSACTION
798 /*!*/;
799 # at #
800 # at #
801 #010909 4:46:40 server id # end_log_pos # Annotate_rows:
802 #Q> INSERT INTO test2.t2 VALUES (1), (2), (3)
803 #010909 4:46:40 server id # end_log_pos # Table_map: `test2`.`t2` mapped to number #
804 # at #
805 #010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F
806 ### INSERT INTO `test2`.`t2`
807 ### SET
808 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
809 ### INSERT INTO `test2`.`t2`
810 ### SET
811 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
812 ### INSERT INTO `test2`.`t2`
813 ### SET
814 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
815 # Number of rows: 3
816 # at #
817 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
818 SET TIMESTAMP=1000000000/*!*/;
819 COMMIT
820 /*!*/;
821 # at #
822 #010909 4:46:40 server id # end_log_pos # GTID 0-1-6 thread_id=#
823 /*M!100001 SET @@session.gtid_seq_no=6*//*!*/;
824 START TRANSACTION
825 /*!*/;
826 # at #
827 # at #
828 #010909 4:46:40 server id # end_log_pos # Annotate_rows:
829 #Q> INSERT INTO test3.t3 VALUES (1), (2), (3)
830 #010909 4:46:40 server id # end_log_pos # Table_map: `test3`.`t3` mapped to number #
831 # at #
832 #010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F
833 ### INSERT INTO `test3`.`t3`
834 ### SET
835 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
836 ### INSERT INTO `test3`.`t3`
837 ### SET
838 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
839 ### INSERT INTO `test3`.`t3`
840 ### SET
841 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
842 # Number of rows: 3
843 # at #
844 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
845 SET TIMESTAMP=1000000000/*!*/;
846 COMMIT
847 /*!*/;
848 # at #
849 #010909 4:46:40 server id # end_log_pos # GTID 0-1-7 thread_id=#
850 /*M!100001 SET @@session.gtid_seq_no=7*//*!*/;
851 START TRANSACTION
852 /*!*/;
853 # at #
854 # at #
855 #010909 4:46:40 server id # end_log_pos # Annotate_rows:
856 #Q> DELETE test1.t1, test2.t2
857 #Q> FROM test1.t1 INNER JOIN test2.t2 INNER JOIN test3.t3
858 #Q> WHERE test1.t1.a=test2.t2.a AND test2.t2.a=test3.t3.a
859 #010909 4:46:40 server id # end_log_pos # Table_map: `test1`.`t1` mapped to number #
860 # at #
861 #010909 4:46:40 server id # end_log_pos # Table_map: `test2`.`t2` mapped to number #
862 # at #
863 # at #
864 #010909 4:46:40 server id # end_log_pos # Delete_rows: table id #
865 #010909 4:46:40 server id # end_log_pos # Delete_rows: table id # flags: STMT_END_F
866 ### DELETE FROM `test1`.`t1`
867 ### WHERE
868 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
869 ### DELETE FROM `test1`.`t1`
870 ### WHERE
871 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
872 ### DELETE FROM `test1`.`t1`
873 ### WHERE
874 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
875 ### DELETE FROM `test2`.`t2`
876 ### WHERE
877 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
878 ### DELETE FROM `test2`.`t2`
879 ### WHERE
880 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
881 ### DELETE FROM `test2`.`t2`
882 ### WHERE
883 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
884 # Number of rows: 6
885 # at #
886 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
887 SET TIMESTAMP=1000000000/*!*/;
888 COMMIT
889 /*!*/;
890 # at #
891 #010909 4:46:40 server id # end_log_pos # GTID 0-1-8 thread_id=#
892 /*M!100001 SET @@session.gtid_seq_no=8*//*!*/;
893 START TRANSACTION
894 /*!*/;
895 # at #
896 # at #
897 #010909 4:46:40 server id # end_log_pos # Annotate_rows:
898 #Q> INSERT INTO test2.v2 VALUES (1), (2), (3)
899 #010909 4:46:40 server id # end_log_pos # Table_map: `test2`.`t2` mapped to number #
900 # at #
901 #010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F
902 ### INSERT INTO `test2`.`t2`
903 ### SET
904 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
905 ### INSERT INTO `test2`.`t2`
906 ### SET
907 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
908 ### INSERT INTO `test2`.`t2`
909 ### SET
910 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
911 # Number of rows: 3
912 # at #
913 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
914 SET TIMESTAMP=1000000000/*!*/;
915 COMMIT
916 /*!*/;
917 # at #
918 #010909 4:46:40 server id # end_log_pos # GTID 0-1-9 thread_id=#
919 /*M!100001 SET @@session.gtid_seq_no=9*//*!*/;
920 START TRANSACTION
921 /*!*/;
922 # at #
923 # at #
924 #010909 4:46:40 server id # end_log_pos # Annotate_rows:
925 #Q> DELETE xtest1.xt1, test2.t2
926 #Q> FROM xtest1.xt1 INNER JOIN test2.t2 INNER JOIN test3.t3
927 #Q> WHERE xtest1.xt1.a=test2.t2.a AND test2.t2.a=test3.t3.a
928 #010909 4:46:40 server id # end_log_pos # Table_map: `test2`.`t2` mapped to number #
929 # at #
930 #010909 4:46:40 server id # end_log_pos # Delete_rows: table id # flags: STMT_END_F
931 ### DELETE FROM `test2`.`t2`
932 ### WHERE
933 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
934 ### DELETE FROM `test2`.`t2`
935 ### WHERE
936 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
937 ### DELETE FROM `test2`.`t2`
938 ### WHERE
939 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
940 # Number of rows: 3
941 # at #
942 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
943 SET TIMESTAMP=1000000000/*!*/;
944 COMMIT
945 /*!*/;
946 # at #
947 #010909 4:46:40 server id # end_log_pos # Rotate to master-bin.000002 pos: 4
948 DELIMITER ;
949 # End of log file
950 ROLLBACK /* added by mysqlbinlog */;
951 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
952 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
953 #
954 #####################################################################################
955 # mysqlbinlog --read-from-remote-server --database=test1
956 # The following Annotate should appear in this output:
957 # - DELETE test1.t1, test2.t2 FROM <...>
958 #####################################################################################
959 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
960 /*!40019 SET @@session.max_delayed_threads=0*/;
961 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
962 DELIMITER /*!*/;
963 # at #
964 #010909 4:46:40 server id # end_log_pos # Start: binlog v 4, server v #.##.## created 010909 4:46:40 at startup
965 ROLLBACK/*!*/;
966 # at #
967 #010909 4:46:40 server id # end_log_pos # Gtid list []
968 # at #
969 #010909 4:46:40 server id # end_log_pos # Binlog checkpoint master-bin.000001
970 # at #
971 #010909 4:46:40 server id # end_log_pos # GTID 0-1-1 ddl thread_id=#
972 /*M!100101 SET @@session.skip_parallel_replication=0*//*!*/;
973 /*M!100001 SET @@session.gtid_domain_id=0*//*!*/;
974 /*M!100001 SET @@session.server_id=1*//*!*/;
975 /*M!100001 SET @@session.gtid_seq_no=1*//*!*/;
976 # at #
977 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
978 SET TIMESTAMP=1000000000/*!*/;
979 SET @@session.pseudo_thread_id=#/*!*/;
980 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1, @@session.check_constraint_checks=1, @@session.sql_if_exists=0, @@session.explicit_defaults_for_timestamp=1, @@session.system_versioning_insert_history=0/*!*/;
981 SET @@session.sql_mode=0/*!*/;
982 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
983 /*!\C latin1 *//*!*/;
984 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
985 SET @@session.lc_time_names=0/*!*/;
986 SET @@session.collation_database=DEFAULT/*!*/;
987 CREATE DATABASE test1
988 /*!*/;
989 # at #
990 #010909 4:46:40 server id # end_log_pos # GTID 0-1-2 ddl thread_id=#
991 /*M!100001 SET @@session.gtid_seq_no=2*//*!*/;
992 # at #
993 # at #
994 #010909 4:46:40 server id # end_log_pos # GTID 0-1-3 ddl thread_id=#
995 /*M!100001 SET @@session.gtid_seq_no=3*//*!*/;
996 # at #
997 # at #
998 #010909 4:46:40 server id # end_log_pos # GTID 0-1-4 thread_id=#
999 /*M!100001 SET @@session.gtid_seq_no=4*//*!*/;
1000 START TRANSACTION
1001 /*!*/;
1002 # at #
1003 # at #
1004 #010909 4:46:40 server id # end_log_pos # Annotate_rows:
1005 #Q> INSERT INTO test1.t1 VALUES (1), (2), (3)
1006 #010909 4:46:40 server id # end_log_pos # Table_map: `test1`.`t1` mapped to number #
1007 # at #
1008 #010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F
1009 ### INSERT INTO `test1`.`t1`
1010 ### SET
1011 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
1012 ### INSERT INTO `test1`.`t1`
1013 ### SET
1014 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
1015 ### INSERT INTO `test1`.`t1`
1016 ### SET
1017 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
1018 # Number of rows: 3
1019 # at #
1020 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
1021 SET TIMESTAMP=1000000000/*!*/;
1022 COMMIT
1023 /*!*/;
1024 # at #
1025 #010909 4:46:40 server id # end_log_pos # GTID 0-1-5 thread_id=#
1026 /*M!100001 SET @@session.gtid_seq_no=5*//*!*/;
1027 START TRANSACTION
1028 /*!*/;
1029 # at #
1030 # at #
1031 # at #
1032 # at #
1033 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
1034 SET TIMESTAMP=1000000000/*!*/;
1035 COMMIT
1036 /*!*/;
1037 # at #
1038 #010909 4:46:40 server id # end_log_pos # GTID 0-1-6 thread_id=#
1039 /*M!100001 SET @@session.gtid_seq_no=6*//*!*/;
1040 START TRANSACTION
1041 /*!*/;
1042 # at #
1043 # at #
1044 # at #
1045 # at #
1046 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
1047 SET TIMESTAMP=1000000000/*!*/;
1048 COMMIT
1049 /*!*/;
1050 # at #
1051 #010909 4:46:40 server id # end_log_pos # GTID 0-1-7 thread_id=#
1052 /*M!100001 SET @@session.gtid_seq_no=7*//*!*/;
1053 START TRANSACTION
1054 /*!*/;
1055 # at #
1056 # at #
1057 #010909 4:46:40 server id # end_log_pos # Annotate_rows:
1058 #Q> DELETE test1.t1, test2.t2
1059 #Q> FROM test1.t1 INNER JOIN test2.t2 INNER JOIN test3.t3
1060 #Q> WHERE test1.t1.a=test2.t2.a AND test2.t2.a=test3.t3.a
1061 #010909 4:46:40 server id # end_log_pos # Table_map: `test1`.`t1` mapped to number #
1062 # at #
1063 # at #
1064 # at #
1065 #010909 4:46:40 server id # end_log_pos # Delete_rows: table id #
1066 ### DELETE FROM `test1`.`t1`
1067 ### WHERE
1068 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
1069 ### DELETE FROM `test1`.`t1`
1070 ### WHERE
1071 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
1072 ### DELETE FROM `test1`.`t1`
1073 ### WHERE
1074 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
1075 # at #
1076 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
1077 SET TIMESTAMP=1000000000/*!*/;
1078 COMMIT
1079 /*!*/;
1080 # at #
1081 #010909 4:46:40 server id # end_log_pos # GTID 0-1-8 thread_id=#
1082 /*M!100001 SET @@session.gtid_seq_no=8*//*!*/;
1083 START TRANSACTION
1084 /*!*/;
1085 # at #
1086 # at #
1087 # at #
1088 # at #
1089 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
1090 SET TIMESTAMP=1000000000/*!*/;
1091 COMMIT
1092 /*!*/;
1093 # at #
1094 #010909 4:46:40 server id # end_log_pos # GTID 0-1-9 thread_id=#
1095 /*M!100001 SET @@session.gtid_seq_no=9*//*!*/;
1096 START TRANSACTION
1097 /*!*/;
1098 # at #
1099 # at #
1100 # at #
1101 # at #
1102 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
1103 SET TIMESTAMP=1000000000/*!*/;
1104 COMMIT
1105 /*!*/;
1106 # at #
1107 #010909 4:46:40 server id # end_log_pos # Rotate to master-bin.000002 pos: 4
1108 DELIMITER ;
1109 # End of log file
1110 ROLLBACK /* added by mysqlbinlog */;
1111 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
1112 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
1113 #
1114 #####################################################################################
1115 # mysqlbinlog --read-from-remote-server --skip-annotate-row-events
1116 # No Annotates should appear in this output
1117 #####################################################################################
1118 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
1119 /*!40019 SET @@session.max_delayed_threads=0*/;
1120 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
1121 DELIMITER /*!*/;
1122 # at #
1123 #010909 4:46:40 server id # end_log_pos # Start: binlog v 4, server v #.##.## created 010909 4:46:40 at startup
1124 ROLLBACK/*!*/;
1125 # at #
1126 #010909 4:46:40 server id # end_log_pos # Gtid list []
1127 # at #
1128 #010909 4:46:40 server id # end_log_pos # Binlog checkpoint master-bin.000001
1129 # at #
1130 #010909 4:46:40 server id # end_log_pos # GTID 0-1-1 ddl thread_id=#
1131 /*M!100101 SET @@session.skip_parallel_replication=0*//*!*/;
1132 /*M!100001 SET @@session.gtid_domain_id=0*//*!*/;
1133 /*M!100001 SET @@session.server_id=1*//*!*/;
1134 /*M!100001 SET @@session.gtid_seq_no=1*//*!*/;
1135 # at #
1136 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
1137 SET TIMESTAMP=1000000000/*!*/;
1138 SET @@session.pseudo_thread_id=#/*!*/;
1139 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1, @@session.check_constraint_checks=1, @@session.sql_if_exists=0, @@session.explicit_defaults_for_timestamp=1, @@session.system_versioning_insert_history=0/*!*/;
1140 SET @@session.sql_mode=0/*!*/;
1141 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
1142 /*!\C latin1 *//*!*/;
1143 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
1144 SET @@session.lc_time_names=0/*!*/;
1145 SET @@session.collation_database=DEFAULT/*!*/;
1146 CREATE DATABASE test1
1147 /*!*/;
1148 # at #
1149 #010909 4:46:40 server id # end_log_pos # GTID 0-1-2 ddl thread_id=#
1150 /*M!100001 SET @@session.gtid_seq_no=2*//*!*/;
1151 # at #
1152 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
1153 SET TIMESTAMP=1000000000/*!*/;
1154 CREATE DATABASE test2
1155 /*!*/;
1156 # at #
1157 #010909 4:46:40 server id # end_log_pos # GTID 0-1-3 ddl thread_id=#
1158 /*M!100001 SET @@session.gtid_seq_no=3*//*!*/;
1159 # at #
1160 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
1161 SET TIMESTAMP=1000000000/*!*/;
1162 CREATE DATABASE test3
1163 /*!*/;
1164 # at #
1165 #010909 4:46:40 server id # end_log_pos # GTID 0-1-4 thread_id=#
1166 /*M!100001 SET @@session.gtid_seq_no=4*//*!*/;
1167 START TRANSACTION
1168 /*!*/;
1169 # at #
1170 #010909 4:46:40 server id # end_log_pos # Table_map: `test1`.`t1` mapped to number #
1171 # at #
1172 #010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F
1173 ### INSERT INTO `test1`.`t1`
1174 ### SET
1175 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
1176 ### INSERT INTO `test1`.`t1`
1177 ### SET
1178 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
1179 ### INSERT INTO `test1`.`t1`
1180 ### SET
1181 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
1182 # Number of rows: 3
1183 # at #
1184 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
1185 SET TIMESTAMP=1000000000/*!*/;
1186 COMMIT
1187 /*!*/;
1188 # at #
1189 #010909 4:46:40 server id # end_log_pos # GTID 0-1-5 thread_id=#
1190 /*M!100001 SET @@session.gtid_seq_no=5*//*!*/;
1191 START TRANSACTION
1192 /*!*/;
1193 # at #
1194 #010909 4:46:40 server id # end_log_pos # Table_map: `test2`.`t2` mapped to number #
1195 # at #
1196 #010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F
1197 ### INSERT INTO `test2`.`t2`
1198 ### SET
1199 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
1200 ### INSERT INTO `test2`.`t2`
1201 ### SET
1202 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
1203 ### INSERT INTO `test2`.`t2`
1204 ### SET
1205 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
1206 # Number of rows: 3
1207 # at #
1208 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
1209 SET TIMESTAMP=1000000000/*!*/;
1210 COMMIT
1211 /*!*/;
1212 # at #
1213 #010909 4:46:40 server id # end_log_pos # GTID 0-1-6 thread_id=#
1214 /*M!100001 SET @@session.gtid_seq_no=6*//*!*/;
1215 START TRANSACTION
1216 /*!*/;
1217 # at #
1218 #010909 4:46:40 server id # end_log_pos # Table_map: `test3`.`t3` mapped to number #
1219 # at #
1220 #010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F
1221 ### INSERT INTO `test3`.`t3`
1222 ### SET
1223 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
1224 ### INSERT INTO `test3`.`t3`
1225 ### SET
1226 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
1227 ### INSERT INTO `test3`.`t3`
1228 ### SET
1229 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
1230 # Number of rows: 3
1231 # at #
1232 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
1233 SET TIMESTAMP=1000000000/*!*/;
1234 COMMIT
1235 /*!*/;
1236 # at #
1237 #010909 4:46:40 server id # end_log_pos # GTID 0-1-7 thread_id=#
1238 /*M!100001 SET @@session.gtid_seq_no=7*//*!*/;
1239 START TRANSACTION
1240 /*!*/;
1241 # at #
1242 #010909 4:46:40 server id # end_log_pos # Table_map: `test1`.`t1` mapped to number #
1243 # at #
1244 #010909 4:46:40 server id # end_log_pos # Table_map: `test2`.`t2` mapped to number #
1245 # at #
1246 # at #
1247 #010909 4:46:40 server id # end_log_pos # Delete_rows: table id #
1248 #010909 4:46:40 server id # end_log_pos # Delete_rows: table id # flags: STMT_END_F
1249 ### DELETE FROM `test1`.`t1`
1250 ### WHERE
1251 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
1252 ### DELETE FROM `test1`.`t1`
1253 ### WHERE
1254 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
1255 ### DELETE FROM `test1`.`t1`
1256 ### WHERE
1257 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
1258 ### DELETE FROM `test2`.`t2`
1259 ### WHERE
1260 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
1261 ### DELETE FROM `test2`.`t2`
1262 ### WHERE
1263 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
1264 ### DELETE FROM `test2`.`t2`
1265 ### WHERE
1266 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
1267 # Number of rows: 6
1268 # at #
1269 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
1270 SET TIMESTAMP=1000000000/*!*/;
1271 COMMIT
1272 /*!*/;
1273 # at #
1274 #010909 4:46:40 server id # end_log_pos # GTID 0-1-8 thread_id=#
1275 /*M!100001 SET @@session.gtid_seq_no=8*//*!*/;
1276 START TRANSACTION
1277 /*!*/;
1278 # at #
1279 #010909 4:46:40 server id # end_log_pos # Table_map: `test2`.`t2` mapped to number #
1280 # at #
1281 #010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F
1282 ### INSERT INTO `test2`.`t2`
1283 ### SET
1284 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
1285 ### INSERT INTO `test2`.`t2`
1286 ### SET
1287 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
1288 ### INSERT INTO `test2`.`t2`
1289 ### SET
1290 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
1291 # Number of rows: 3
1292 # at #
1293 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
1294 SET TIMESTAMP=1000000000/*!*/;
1295 COMMIT
1296 /*!*/;
1297 # at #
1298 #010909 4:46:40 server id # end_log_pos # GTID 0-1-9 thread_id=#
1299 /*M!100001 SET @@session.gtid_seq_no=9*//*!*/;
1300 START TRANSACTION
1301 /*!*/;
1302 # at #
1303 #010909 4:46:40 server id # end_log_pos # Table_map: `test2`.`t2` mapped to number #
1304 # at #
1305 #010909 4:46:40 server id # end_log_pos # Delete_rows: table id # flags: STMT_END_F
1306 ### DELETE FROM `test2`.`t2`
1307 ### WHERE
1308 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
1309 ### DELETE FROM `test2`.`t2`
1310 ### WHERE
1311 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
1312 ### DELETE FROM `test2`.`t2`
1313 ### WHERE
1314 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
1315 # Number of rows: 3
1316 # at #
1317 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
1318 SET TIMESTAMP=1000000000/*!*/;
1319 COMMIT
1320 /*!*/;
1321 # at #
1322 #010909 4:46:40 server id # end_log_pos # Rotate to master-bin.000002 pos: 4
1323 DELIMITER ;
1324 # End of log file
1325 ROLLBACK /* added by mysqlbinlog */;
1326 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
1327 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
1328 set global binlog_checksum=@old_binlog_checksum;
1329 DROP DATABASE test1;
1330 DROP DATABASE test2;
1331 DROP DATABASE test3;
1332 DROP DATABASE xtest1;
1333 DROP DATABASE xtest2;