Debian Codegraph @

mysql-test/suite/binlog_encryption/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 # Binlog_checkpoint # # master-bin.000001
46 master-bin.000001 # Gtid # # GTID #-#-#
47 master-bin.000001 # Query # # CREATE DATABASE test1
48 master-bin.000001 # Gtid # # GTID #-#-#
49 master-bin.000001 # Query # # CREATE DATABASE test2
50 master-bin.000001 # Gtid # # GTID #-#-#
51 master-bin.000001 # Query # # CREATE DATABASE test3
52 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
53 master-bin.000001 # Annotate_rows # # INSERT INTO test1.t1 VALUES (1), (2), (3)
54 master-bin.000001 # Table_map # # table_id: # (test1.t1)
55 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
56 master-bin.000001 # Query # # COMMIT
57 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
58 master-bin.000001 # Annotate_rows # # INSERT INTO test2.t2 VALUES (1), (2), (3)
59 master-bin.000001 # Table_map # # table_id: # (test2.t2)
60 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
61 master-bin.000001 # Query # # COMMIT
62 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
63 master-bin.000001 # Annotate_rows # # INSERT INTO test3.t3 VALUES (1), (2), (3)
64 master-bin.000001 # Table_map # # table_id: # (test3.t3)
65 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
66 master-bin.000001 # Query # # COMMIT
67 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
68 master-bin.000001 # Annotate_rows # # DELETE test1.t1, test2.t2
69 FROM test1.t1 INNER JOIN test2.t2 INNER JOIN test3.t3
70 WHERE test1.t1.a=test2.t2.a AND test2.t2.a=test3.t3.a
71 master-bin.000001 # Table_map # # table_id: # (test1.t1)
72 master-bin.000001 # Table_map # # table_id: # (test2.t2)
73 master-bin.000001 # Delete_rows_v1 # # table_id: #
74 master-bin.000001 # Delete_rows_v1 # # table_id: # flags: STMT_END_F
75 master-bin.000001 # Query # # COMMIT
76 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
77 master-bin.000001 # Annotate_rows # # INSERT INTO test2.v2 VALUES (1), (2), (3)
78 master-bin.000001 # Table_map # # table_id: # (test2.t2)
79 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
80 master-bin.000001 # Query # # COMMIT
81 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
82 master-bin.000001 # Annotate_rows # # DELETE xtest1.xt1, test2.t2
83 FROM xtest1.xt1 INNER JOIN test2.t2 INNER JOIN test3.t3
84 WHERE xtest1.xt1.a=test2.t2.a AND test2.t2.a=test3.t3.a
85 master-bin.000001 # Table_map # # table_id: # (test2.t2)
86 master-bin.000001 # Delete_rows_v1 # # table_id: # flags: STMT_END_F
87 master-bin.000001 # Query # # COMMIT
88 master-bin.000001 # Rotate # # master-bin.000002;pos=POS
89 #
90 #####################################################################################
91 # mysqlbinlog --read-from-remote-server
92 # The following Annotates should appear in this output:
93 # - INSERT INTO test2.t2 VALUES (1), (2), (3)
94 # - INSERT INTO test3.t3 VALUES (1), (2), (3)
95 # - DELETE test1.t1, test2.t2 FROM <...> (with two subsequent Table maps)
96 # - INSERT INTO test2.t2 VALUES (1), (2), (3)
97 # - DELETE xtest1.xt1, test2.t2 FROM <...> (with one subsequent Table map)
98 #####################################################################################
99 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
100 /*!40019 SET @@session.max_delayed_threads=0*/;
101 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
102 DELIMITER /*!*/;
103 # at #
104 #010909 4:46:40 server id # end_log_pos # Start: binlog v 4, server v #.##.## created 010909 4:46:40 at startup
105 ROLLBACK/*!*/;
106 # at #
107 #010909 4:46:40 server id # end_log_pos # Ignorable
108 # Ignorable event type 164 (Start_encryption)
109 # at #
110 #010909 4:46:40 server id # end_log_pos # Gtid list []
111 # at #
112 #010909 4:46:40 server id # end_log_pos # Binlog checkpoint master-bin.000001
113 # at #
114 #010909 4:46:40 server id # end_log_pos # GTID 0-1-1 ddl thread_id=#
115 /*M!100101 SET @@session.skip_parallel_replication=0*//*!*/;
116 /*M!100001 SET @@session.gtid_domain_id=0*//*!*/;
117 /*M!100001 SET @@session.server_id=1*//*!*/;
118 /*M!100001 SET @@session.gtid_seq_no=1*//*!*/;
119 # at #
120 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
121 SET TIMESTAMP=1000000000/*!*/;
122 SET @@session.pseudo_thread_id=#/*!*/;
123 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/*!*/;
124 SET @@session.sql_mode=0/*!*/;
125 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
126 /*!\C latin1 *//*!*/;
127 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
128 SET @@session.lc_time_names=0/*!*/;
129 SET @@session.collation_database=DEFAULT/*!*/;
130 CREATE DATABASE test1
131 /*!*/;
132 # at #
133 #010909 4:46:40 server id # end_log_pos # GTID 0-1-2 ddl thread_id=#
134 /*M!100001 SET @@session.gtid_seq_no=2*//*!*/;
135 # at #
136 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
137 SET TIMESTAMP=1000000000/*!*/;
138 CREATE DATABASE test2
139 /*!*/;
140 # at #
141 #010909 4:46:40 server id # end_log_pos # GTID 0-1-3 ddl thread_id=#
142 /*M!100001 SET @@session.gtid_seq_no=3*//*!*/;
143 # at #
144 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
145 SET TIMESTAMP=1000000000/*!*/;
146 CREATE DATABASE test3
147 /*!*/;
148 # at #
149 #010909 4:46:40 server id # end_log_pos # GTID 0-1-4 thread_id=#
150 /*M!100001 SET @@session.gtid_seq_no=4*//*!*/;
151 START TRANSACTION
152 /*!*/;
153 # at #
154 # at #
155 #010909 4:46:40 server id # end_log_pos # Annotate_rows:
156 #Q> INSERT INTO test1.t1 VALUES (1), (2), (3)
157 #010909 4:46:40 server id # end_log_pos # Table_map: `test1`.`t1` mapped to number #
158 # at #
159 #010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F
160 ### INSERT INTO `test1`.`t1`
161 ### SET
162 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
163 ### INSERT INTO `test1`.`t1`
164 ### SET
165 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
166 ### INSERT INTO `test1`.`t1`
167 ### SET
168 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
169 # Number of rows: 3
170 # at #
171 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
172 SET TIMESTAMP=1000000000/*!*/;
173 COMMIT
174 /*!*/;
175 # at #
176 #010909 4:46:40 server id # end_log_pos # GTID 0-1-5 thread_id=#
177 /*M!100001 SET @@session.gtid_seq_no=5*//*!*/;
178 START TRANSACTION
179 /*!*/;
180 # at #
181 # at #
182 #010909 4:46:40 server id # end_log_pos # Annotate_rows:
183 #Q> INSERT INTO test2.t2 VALUES (1), (2), (3)
184 #010909 4:46:40 server id # end_log_pos # Table_map: `test2`.`t2` mapped to number #
185 # at #
186 #010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F
187 ### INSERT INTO `test2`.`t2`
188 ### SET
189 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
190 ### INSERT INTO `test2`.`t2`
191 ### SET
192 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
193 ### INSERT INTO `test2`.`t2`
194 ### SET
195 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
196 # Number of rows: 3
197 # at #
198 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
199 SET TIMESTAMP=1000000000/*!*/;
200 COMMIT
201 /*!*/;
202 # at #
203 #010909 4:46:40 server id # end_log_pos # GTID 0-1-6 thread_id=#
204 /*M!100001 SET @@session.gtid_seq_no=6*//*!*/;
205 START TRANSACTION
206 /*!*/;
207 # at #
208 # at #
209 #010909 4:46:40 server id # end_log_pos # Annotate_rows:
210 #Q> INSERT INTO test3.t3 VALUES (1), (2), (3)
211 #010909 4:46:40 server id # end_log_pos # Table_map: `test3`.`t3` mapped to number #
212 # at #
213 #010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F
214 ### INSERT INTO `test3`.`t3`
215 ### SET
216 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
217 ### INSERT INTO `test3`.`t3`
218 ### SET
219 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
220 ### INSERT INTO `test3`.`t3`
221 ### SET
222 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
223 # Number of rows: 3
224 # at #
225 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
226 SET TIMESTAMP=1000000000/*!*/;
227 COMMIT
228 /*!*/;
229 # at #
230 #010909 4:46:40 server id # end_log_pos # GTID 0-1-7 thread_id=#
231 /*M!100001 SET @@session.gtid_seq_no=7*//*!*/;
232 START TRANSACTION
233 /*!*/;
234 # at #
235 # at #
236 #010909 4:46:40 server id # end_log_pos # Annotate_rows:
237 #Q> DELETE test1.t1, test2.t2
238 #Q> FROM test1.t1 INNER JOIN test2.t2 INNER JOIN test3.t3
239 #Q> WHERE test1.t1.a=test2.t2.a AND test2.t2.a=test3.t3.a
240 #010909 4:46:40 server id # end_log_pos # Table_map: `test1`.`t1` mapped to number #
241 # at #
242 #010909 4:46:40 server id # end_log_pos # Table_map: `test2`.`t2` mapped to number #
243 # at #
244 # at #
245 #010909 4:46:40 server id # end_log_pos # Delete_rows: table id #
246 #010909 4:46:40 server id # end_log_pos # Delete_rows: table id # flags: STMT_END_F
247 ### DELETE FROM `test1`.`t1`
248 ### WHERE
249 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
250 ### DELETE FROM `test1`.`t1`
251 ### WHERE
252 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
253 ### DELETE FROM `test1`.`t1`
254 ### WHERE
255 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
256 ### DELETE FROM `test2`.`t2`
257 ### WHERE
258 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
259 ### DELETE FROM `test2`.`t2`
260 ### WHERE
261 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
262 ### DELETE FROM `test2`.`t2`
263 ### WHERE
264 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
265 # Number of rows: 6
266 # at #
267 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
268 SET TIMESTAMP=1000000000/*!*/;
269 COMMIT
270 /*!*/;
271 # at #
272 #010909 4:46:40 server id # end_log_pos # GTID 0-1-8 thread_id=#
273 /*M!100001 SET @@session.gtid_seq_no=8*//*!*/;
274 START TRANSACTION
275 /*!*/;
276 # at #
277 # at #
278 #010909 4:46:40 server id # end_log_pos # Annotate_rows:
279 #Q> INSERT INTO test2.v2 VALUES (1), (2), (3)
280 #010909 4:46:40 server id # end_log_pos # Table_map: `test2`.`t2` mapped to number #
281 # at #
282 #010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F
283 ### INSERT INTO `test2`.`t2`
284 ### SET
285 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
286 ### INSERT INTO `test2`.`t2`
287 ### SET
288 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
289 ### INSERT INTO `test2`.`t2`
290 ### SET
291 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
292 # Number of rows: 3
293 # at #
294 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
295 SET TIMESTAMP=1000000000/*!*/;
296 COMMIT
297 /*!*/;
298 # at #
299 #010909 4:46:40 server id # end_log_pos # GTID 0-1-9 thread_id=#
300 /*M!100001 SET @@session.gtid_seq_no=9*//*!*/;
301 START TRANSACTION
302 /*!*/;
303 # at #
304 # at #
305 #010909 4:46:40 server id # end_log_pos # Annotate_rows:
306 #Q> DELETE xtest1.xt1, test2.t2
307 #Q> FROM xtest1.xt1 INNER JOIN test2.t2 INNER JOIN test3.t3
308 #Q> WHERE xtest1.xt1.a=test2.t2.a AND test2.t2.a=test3.t3.a
309 #010909 4:46:40 server id # end_log_pos # Table_map: `test2`.`t2` mapped to number #
310 # at #
311 #010909 4:46:40 server id # end_log_pos # Delete_rows: table id # flags: STMT_END_F
312 ### DELETE FROM `test2`.`t2`
313 ### WHERE
314 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
315 ### DELETE FROM `test2`.`t2`
316 ### WHERE
317 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
318 ### DELETE FROM `test2`.`t2`
319 ### WHERE
320 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
321 # Number of rows: 3
322 # at #
323 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
324 SET TIMESTAMP=1000000000/*!*/;
325 COMMIT
326 /*!*/;
327 # at #
328 #010909 4:46:40 server id # end_log_pos # Rotate to master-bin.000002 pos: 4
329 DELIMITER ;
330 # End of log file
331 ROLLBACK /* added by mysqlbinlog */;
332 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
333 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
334 #
335 #####################################################################################
336 # mysqlbinlog --read-from-remote-server --database=test1
337 # The following Annotate should appear in this output:
338 # - DELETE test1.t1, test2.t2 FROM <...>
339 #####################################################################################
340 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
341 /*!40019 SET @@session.max_delayed_threads=0*/;
342 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
343 DELIMITER /*!*/;
344 # at #
345 #010909 4:46:40 server id # end_log_pos # Start: binlog v 4, server v #.##.## created 010909 4:46:40 at startup
346 ROLLBACK/*!*/;
347 # at #
348 #010909 4:46:40 server id # end_log_pos # Ignorable
349 # Ignorable event type 164 (Start_encryption)
350 # at #
351 #010909 4:46:40 server id # end_log_pos # Gtid list []
352 # at #
353 #010909 4:46:40 server id # end_log_pos # Binlog checkpoint master-bin.000001
354 # at #
355 #010909 4:46:40 server id # end_log_pos # GTID 0-1-1 ddl thread_id=#
356 /*M!100101 SET @@session.skip_parallel_replication=0*//*!*/;
357 /*M!100001 SET @@session.gtid_domain_id=0*//*!*/;
358 /*M!100001 SET @@session.server_id=1*//*!*/;
359 /*M!100001 SET @@session.gtid_seq_no=1*//*!*/;
360 # at #
361 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
362 SET TIMESTAMP=1000000000/*!*/;
363 SET @@session.pseudo_thread_id=#/*!*/;
364 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/*!*/;
365 SET @@session.sql_mode=0/*!*/;
366 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
367 /*!\C latin1 *//*!*/;
368 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
369 SET @@session.lc_time_names=0/*!*/;
370 SET @@session.collation_database=DEFAULT/*!*/;
371 CREATE DATABASE test1
372 /*!*/;
373 # at #
374 #010909 4:46:40 server id # end_log_pos # GTID 0-1-2 ddl thread_id=#
375 /*M!100001 SET @@session.gtid_seq_no=2*//*!*/;
376 # at #
377 # at #
378 #010909 4:46:40 server id # end_log_pos # GTID 0-1-3 ddl thread_id=#
379 /*M!100001 SET @@session.gtid_seq_no=3*//*!*/;
380 # at #
381 # at #
382 #010909 4:46:40 server id # end_log_pos # GTID 0-1-4 thread_id=#
383 /*M!100001 SET @@session.gtid_seq_no=4*//*!*/;
384 START TRANSACTION
385 /*!*/;
386 # at #
387 # at #
388 #010909 4:46:40 server id # end_log_pos # Annotate_rows:
389 #Q> INSERT INTO test1.t1 VALUES (1), (2), (3)
390 #010909 4:46:40 server id # end_log_pos # Table_map: `test1`.`t1` mapped to number #
391 # at #
392 #010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F
393 ### INSERT INTO `test1`.`t1`
394 ### SET
395 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
396 ### INSERT INTO `test1`.`t1`
397 ### SET
398 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
399 ### INSERT INTO `test1`.`t1`
400 ### SET
401 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
402 # Number of rows: 3
403 # at #
404 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
405 SET TIMESTAMP=1000000000/*!*/;
406 COMMIT
407 /*!*/;
408 # at #
409 #010909 4:46:40 server id # end_log_pos # GTID 0-1-5 thread_id=#
410 /*M!100001 SET @@session.gtid_seq_no=5*//*!*/;
411 START TRANSACTION
412 /*!*/;
413 # at #
414 # at #
415 # at #
416 # at #
417 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
418 SET TIMESTAMP=1000000000/*!*/;
419 COMMIT
420 /*!*/;
421 # at #
422 #010909 4:46:40 server id # end_log_pos # GTID 0-1-6 thread_id=#
423 /*M!100001 SET @@session.gtid_seq_no=6*//*!*/;
424 START TRANSACTION
425 /*!*/;
426 # at #
427 # at #
428 # at #
429 # at #
430 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
431 SET TIMESTAMP=1000000000/*!*/;
432 COMMIT
433 /*!*/;
434 # at #
435 #010909 4:46:40 server id # end_log_pos # GTID 0-1-7 thread_id=#
436 /*M!100001 SET @@session.gtid_seq_no=7*//*!*/;
437 START TRANSACTION
438 /*!*/;
439 # at #
440 # at #
441 #010909 4:46:40 server id # end_log_pos # Annotate_rows:
442 #Q> DELETE test1.t1, test2.t2
443 #Q> FROM test1.t1 INNER JOIN test2.t2 INNER JOIN test3.t3
444 #Q> WHERE test1.t1.a=test2.t2.a AND test2.t2.a=test3.t3.a
445 #010909 4:46:40 server id # end_log_pos # Table_map: `test1`.`t1` mapped to number #
446 # at #
447 # at #
448 # at #
449 #010909 4:46:40 server id # end_log_pos # Delete_rows: table id #
450 ### DELETE FROM `test1`.`t1`
451 ### WHERE
452 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
453 ### DELETE FROM `test1`.`t1`
454 ### WHERE
455 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
456 ### DELETE FROM `test1`.`t1`
457 ### WHERE
458 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
459 # at #
460 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
461 SET TIMESTAMP=1000000000/*!*/;
462 COMMIT
463 /*!*/;
464 # at #
465 #010909 4:46:40 server id # end_log_pos # GTID 0-1-8 thread_id=#
466 /*M!100001 SET @@session.gtid_seq_no=8*//*!*/;
467 START TRANSACTION
468 /*!*/;
469 # at #
470 # at #
471 # at #
472 # at #
473 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
474 SET TIMESTAMP=1000000000/*!*/;
475 COMMIT
476 /*!*/;
477 # at #
478 #010909 4:46:40 server id # end_log_pos # GTID 0-1-9 thread_id=#
479 /*M!100001 SET @@session.gtid_seq_no=9*//*!*/;
480 START TRANSACTION
481 /*!*/;
482 # at #
483 # at #
484 # at #
485 # at #
486 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
487 SET TIMESTAMP=1000000000/*!*/;
488 COMMIT
489 /*!*/;
490 # at #
491 #010909 4:46:40 server id # end_log_pos # Rotate to master-bin.000002 pos: 4
492 DELIMITER ;
493 # End of log file
494 ROLLBACK /* added by mysqlbinlog */;
495 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
496 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
497 #
498 #####################################################################################
499 # mysqlbinlog --read-from-remote-server --skip-annotate-row-events
500 # No Annotates should appear in this output
501 #####################################################################################
502 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
503 /*!40019 SET @@session.max_delayed_threads=0*/;
504 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
505 DELIMITER /*!*/;
506 # at #
507 #010909 4:46:40 server id # end_log_pos # Start: binlog v 4, server v #.##.## created 010909 4:46:40 at startup
508 ROLLBACK/*!*/;
509 # at #
510 #010909 4:46:40 server id # end_log_pos # Ignorable
511 # Ignorable event type 164 (Start_encryption)
512 # at #
513 #010909 4:46:40 server id # end_log_pos # Gtid list []
514 # at #
515 #010909 4:46:40 server id # end_log_pos # Binlog checkpoint master-bin.000001
516 # at #
517 #010909 4:46:40 server id # end_log_pos # GTID 0-1-1 ddl thread_id=#
518 /*M!100101 SET @@session.skip_parallel_replication=0*//*!*/;
519 /*M!100001 SET @@session.gtid_domain_id=0*//*!*/;
520 /*M!100001 SET @@session.server_id=1*//*!*/;
521 /*M!100001 SET @@session.gtid_seq_no=1*//*!*/;
522 # at #
523 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
524 SET TIMESTAMP=1000000000/*!*/;
525 SET @@session.pseudo_thread_id=#/*!*/;
526 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/*!*/;
527 SET @@session.sql_mode=0/*!*/;
528 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
529 /*!\C latin1 *//*!*/;
530 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
531 SET @@session.lc_time_names=0/*!*/;
532 SET @@session.collation_database=DEFAULT/*!*/;
533 CREATE DATABASE test1
534 /*!*/;
535 # at #
536 #010909 4:46:40 server id # end_log_pos # GTID 0-1-2 ddl thread_id=#
537 /*M!100001 SET @@session.gtid_seq_no=2*//*!*/;
538 # at #
539 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
540 SET TIMESTAMP=1000000000/*!*/;
541 CREATE DATABASE test2
542 /*!*/;
543 # at #
544 #010909 4:46:40 server id # end_log_pos # GTID 0-1-3 ddl thread_id=#
545 /*M!100001 SET @@session.gtid_seq_no=3*//*!*/;
546 # at #
547 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
548 SET TIMESTAMP=1000000000/*!*/;
549 CREATE DATABASE test3
550 /*!*/;
551 # at #
552 #010909 4:46:40 server id # end_log_pos # GTID 0-1-4 thread_id=#
553 /*M!100001 SET @@session.gtid_seq_no=4*//*!*/;
554 START TRANSACTION
555 /*!*/;
556 # at #
557 #010909 4:46:40 server id # end_log_pos # Table_map: `test1`.`t1` mapped to number #
558 # at #
559 #010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F
560 ### INSERT INTO `test1`.`t1`
561 ### SET
562 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
563 ### INSERT INTO `test1`.`t1`
564 ### SET
565 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
566 ### INSERT INTO `test1`.`t1`
567 ### SET
568 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
569 # Number of rows: 3
570 # at #
571 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
572 SET TIMESTAMP=1000000000/*!*/;
573 COMMIT
574 /*!*/;
575 # at #
576 #010909 4:46:40 server id # end_log_pos # GTID 0-1-5 thread_id=#
577 /*M!100001 SET @@session.gtid_seq_no=5*//*!*/;
578 START TRANSACTION
579 /*!*/;
580 # at #
581 #010909 4:46:40 server id # end_log_pos # Table_map: `test2`.`t2` mapped to number #
582 # at #
583 #010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F
584 ### INSERT INTO `test2`.`t2`
585 ### SET
586 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
587 ### INSERT INTO `test2`.`t2`
588 ### SET
589 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
590 ### INSERT INTO `test2`.`t2`
591 ### SET
592 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
593 # Number of rows: 3
594 # at #
595 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
596 SET TIMESTAMP=1000000000/*!*/;
597 COMMIT
598 /*!*/;
599 # at #
600 #010909 4:46:40 server id # end_log_pos # GTID 0-1-6 thread_id=#
601 /*M!100001 SET @@session.gtid_seq_no=6*//*!*/;
602 START TRANSACTION
603 /*!*/;
604 # at #
605 #010909 4:46:40 server id # end_log_pos # Table_map: `test3`.`t3` mapped to number #
606 # at #
607 #010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F
608 ### INSERT INTO `test3`.`t3`
609 ### SET
610 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
611 ### INSERT INTO `test3`.`t3`
612 ### SET
613 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
614 ### INSERT INTO `test3`.`t3`
615 ### SET
616 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
617 # Number of rows: 3
618 # at #
619 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
620 SET TIMESTAMP=1000000000/*!*/;
621 COMMIT
622 /*!*/;
623 # at #
624 #010909 4:46:40 server id # end_log_pos # GTID 0-1-7 thread_id=#
625 /*M!100001 SET @@session.gtid_seq_no=7*//*!*/;
626 START TRANSACTION
627 /*!*/;
628 # at #
629 #010909 4:46:40 server id # end_log_pos # Table_map: `test1`.`t1` mapped to number #
630 # at #
631 #010909 4:46:40 server id # end_log_pos # Table_map: `test2`.`t2` mapped to number #
632 # at #
633 # at #
634 #010909 4:46:40 server id # end_log_pos # Delete_rows: table id #
635 #010909 4:46:40 server id # end_log_pos # Delete_rows: table id # flags: STMT_END_F
636 ### DELETE FROM `test1`.`t1`
637 ### WHERE
638 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
639 ### DELETE FROM `test1`.`t1`
640 ### WHERE
641 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
642 ### DELETE FROM `test1`.`t1`
643 ### WHERE
644 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
645 ### DELETE FROM `test2`.`t2`
646 ### WHERE
647 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
648 ### DELETE FROM `test2`.`t2`
649 ### WHERE
650 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
651 ### DELETE FROM `test2`.`t2`
652 ### WHERE
653 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
654 # Number of rows: 6
655 # at #
656 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
657 SET TIMESTAMP=1000000000/*!*/;
658 COMMIT
659 /*!*/;
660 # at #
661 #010909 4:46:40 server id # end_log_pos # GTID 0-1-8 thread_id=#
662 /*M!100001 SET @@session.gtid_seq_no=8*//*!*/;
663 START TRANSACTION
664 /*!*/;
665 # at #
666 #010909 4:46:40 server id # end_log_pos # Table_map: `test2`.`t2` mapped to number #
667 # at #
668 #010909 4:46:40 server id # end_log_pos # Write_rows: table id # flags: STMT_END_F
669 ### INSERT INTO `test2`.`t2`
670 ### SET
671 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
672 ### INSERT INTO `test2`.`t2`
673 ### SET
674 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
675 ### INSERT INTO `test2`.`t2`
676 ### SET
677 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
678 # Number of rows: 3
679 # at #
680 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
681 SET TIMESTAMP=1000000000/*!*/;
682 COMMIT
683 /*!*/;
684 # at #
685 #010909 4:46:40 server id # end_log_pos # GTID 0-1-9 thread_id=#
686 /*M!100001 SET @@session.gtid_seq_no=9*//*!*/;
687 START TRANSACTION
688 /*!*/;
689 # at #
690 #010909 4:46:40 server id # end_log_pos # Table_map: `test2`.`t2` mapped to number #
691 # at #
692 #010909 4:46:40 server id # end_log_pos # Delete_rows: table id # flags: STMT_END_F
693 ### DELETE FROM `test2`.`t2`
694 ### WHERE
695 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
696 ### DELETE FROM `test2`.`t2`
697 ### WHERE
698 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
699 ### DELETE FROM `test2`.`t2`
700 ### WHERE
701 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
702 # Number of rows: 3
703 # at #
704 #010909 4:46:40 server id # end_log_pos # Query thread_id=# exec_time=# error_code=0 xid=<xid>
705 SET TIMESTAMP=1000000000/*!*/;
706 COMMIT
707 /*!*/;
708 # at #
709 #010909 4:46:40 server id # end_log_pos # Rotate to master-bin.000002 pos: 4
710 DELIMITER ;
711 # End of log file
712 ROLLBACK /* added by mysqlbinlog */;
713 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
714 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
715 set global binlog_checksum=@old_binlog_checksum;
716 DROP DATABASE test1;
717 DROP DATABASE test2;
718 DROP DATABASE test3;
719 DROP DATABASE xtest1;
720 DROP DATABASE xtest2;