Debian Codegraph @

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

raw
1 DROP DATABASE IF EXISTS test1;
2 DROP DATABASE IF EXISTS test2;
3 DROP DATABASE IF EXISTS test3;
4 CREATE DATABASE test1;
5 CREATE DATABASE test2;
6 CREATE DATABASE test3;
7 SET timestamp=1000000000;
8 RESET MASTER;
9 USE test1;
10 CREATE TABLE t1 (a INT, b INT);
11 INSERT INTO t1 VALUES (1,1),(2,2);
12 USE test2;
13 CREATE TABLE t2 (a INT);
14 INSERT INTO t2 VALUES (1),(2);
15 DELETE FROM test1.t1 WHERE a=1;
16 USE test3;
17 CREATE TABLE t3 (a INT);
18 INSERT INTO t3 VALUES (1),(2);
19 INSERT INTO test1.t1 VALUES (3,3);
20 USE test1;
21 LOAD DATA INFILE '../../std_data/loaddata7.dat' INTO TABLE t1
22 FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n';
23 DELETE FROM test3.t3 WHERE a=1;
24 flush logs;
25 #
26 # mysqlbinlog output
27 # --base64-output = decode-rows
28 # --rewrite-db = test1->new_test1
29 # --rewrite-db = test3->new_test3
30 #
31 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
32 /*!40019 SET @@session.max_delayed_threads=0*/;
33 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
34 DELIMITER /*!*/;
35 # at #
36 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Start: binlog v 4, server v #.##.## created 010909 4:46:40 at startup
37 ROLLBACK/*!*/;
38 # at #
39 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Gtid list []
40 # at #
41 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Binlog checkpoint master-bin.000001
42 # at #
43 #010909 4:46:40 server id # end_log_pos # CRC32 XXX GTID 0-1-1 ddl thread_id=#
44 /*M!100101 SET @@session.skip_parallel_replication=0*//*!*/;
45 /*M!100001 SET @@session.gtid_domain_id=0*//*!*/;
46 /*M!100001 SET @@session.server_id=1*//*!*/;
47 /*M!100001 SET @@session.gtid_seq_no=1*//*!*/;
48 # at #
49 use `new_test1`/*!*/;
50 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Query thread_id=# exec_time=# error_code=0 xid=<xid>
51 SET TIMESTAMP=1000000000/*!*/;
52 SET @@session.pseudo_thread_id=#/*!*/;
53 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/*!*/;
54 SET @@session.sql_mode=1411383296/*!*/;
55 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
56 /*!\C latin1 *//*!*/;
57 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
58 SET @@session.lc_time_names=0/*!*/;
59 SET @@session.collation_database=DEFAULT/*!*/;
60 CREATE TABLE t1 (a INT, b INT)
61 /*!*/;
62 # at #
63 #010909 4:46:40 server id # end_log_pos # CRC32 XXX GTID 0-1-2 thread_id=#
64 /*M!100001 SET @@session.gtid_seq_no=2*//*!*/;
65 START TRANSACTION
66 /*!*/;
67 # at #
68 # at #
69 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Annotate_rows:
70 #Q> INSERT INTO t1 VALUES (1,1),(2,2)
71 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Table_map: `new_test1`.`t1` mapped to number #
72 # at #
73 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Write_rows: table id # flags: STMT_END_F
74 ### INSERT INTO `new_test1`.`t1`
75 ### SET
76 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
77 ### @2=1 /* INT meta=0 nullable=1 is_null=0 */
78 ### INSERT INTO `new_test1`.`t1`
79 ### SET
80 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
81 ### @2=2 /* INT meta=0 nullable=1 is_null=0 */
82 # Number of rows: 2
83 # at #
84 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Query thread_id=# exec_time=# error_code=0 xid=<xid>
85 SET TIMESTAMP=1000000000/*!*/;
86 COMMIT
87 /*!*/;
88 # at #
89 #010909 4:46:40 server id # end_log_pos # CRC32 XXX GTID 0-1-3 ddl thread_id=#
90 /*M!100001 SET @@session.gtid_seq_no=3*//*!*/;
91 # at #
92 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Query thread_id=# exec_time=# error_code=0 xid=<xid>
93 use `test2`/*!*/;
94 SET TIMESTAMP=1000000000/*!*/;
95 CREATE TABLE t2 (a INT)
96 /*!*/;
97 # at #
98 #010909 4:46:40 server id # end_log_pos # CRC32 XXX GTID 0-1-4 thread_id=#
99 /*M!100001 SET @@session.gtid_seq_no=4*//*!*/;
100 START TRANSACTION
101 /*!*/;
102 # at #
103 # at #
104 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Annotate_rows:
105 #Q> INSERT INTO t2 VALUES (1),(2)
106 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Table_map: `test2`.`t2` mapped to number #
107 # at #
108 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Write_rows: table id # flags: STMT_END_F
109 ### INSERT INTO `test2`.`t2`
110 ### SET
111 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
112 ### INSERT INTO `test2`.`t2`
113 ### SET
114 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
115 # Number of rows: 2
116 # at #
117 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Query thread_id=# exec_time=# error_code=0 xid=<xid>
118 SET TIMESTAMP=1000000000/*!*/;
119 COMMIT
120 /*!*/;
121 # at #
122 #010909 4:46:40 server id # end_log_pos # CRC32 XXX GTID 0-1-5 thread_id=#
123 /*M!100001 SET @@session.gtid_seq_no=5*//*!*/;
124 START TRANSACTION
125 /*!*/;
126 # at #
127 # at #
128 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Annotate_rows:
129 #Q> DELETE FROM test1.t1 WHERE a=1
130 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Table_map: `new_test1`.`t1` mapped to number #
131 # at #
132 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Delete_rows: table id # flags: STMT_END_F
133 ### DELETE FROM `new_test1`.`t1`
134 ### WHERE
135 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
136 ### @2=1 /* INT meta=0 nullable=1 is_null=0 */
137 # Number of rows: 1
138 # at #
139 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Query thread_id=# exec_time=# error_code=0 xid=<xid>
140 SET TIMESTAMP=1000000000/*!*/;
141 COMMIT
142 /*!*/;
143 # at #
144 #010909 4:46:40 server id # end_log_pos # CRC32 XXX GTID 0-1-6 ddl thread_id=#
145 /*M!100001 SET @@session.gtid_seq_no=6*//*!*/;
146 # at #
147 use `new_test3`/*!*/;
148 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Query thread_id=# exec_time=# error_code=0 xid=<xid>
149 SET TIMESTAMP=1000000000/*!*/;
150 CREATE TABLE t3 (a INT)
151 /*!*/;
152 # at #
153 #010909 4:46:40 server id # end_log_pos # CRC32 XXX GTID 0-1-7 thread_id=#
154 /*M!100001 SET @@session.gtid_seq_no=7*//*!*/;
155 START TRANSACTION
156 /*!*/;
157 # at #
158 # at #
159 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Annotate_rows:
160 #Q> INSERT INTO t3 VALUES (1),(2)
161 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Table_map: `new_test3`.`t3` mapped to number #
162 # at #
163 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Write_rows: table id # flags: STMT_END_F
164 ### INSERT INTO `new_test3`.`t3`
165 ### SET
166 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
167 ### INSERT INTO `new_test3`.`t3`
168 ### SET
169 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
170 # Number of rows: 2
171 # at #
172 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Query thread_id=# exec_time=# error_code=0 xid=<xid>
173 SET TIMESTAMP=1000000000/*!*/;
174 COMMIT
175 /*!*/;
176 # at #
177 #010909 4:46:40 server id # end_log_pos # CRC32 XXX GTID 0-1-8 thread_id=#
178 /*M!100001 SET @@session.gtid_seq_no=8*//*!*/;
179 START TRANSACTION
180 /*!*/;
181 # at #
182 # at #
183 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Annotate_rows:
184 #Q> INSERT INTO test1.t1 VALUES (3,3)
185 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Table_map: `new_test1`.`t1` mapped to number #
186 # at #
187 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Write_rows: table id # flags: STMT_END_F
188 ### INSERT INTO `new_test1`.`t1`
189 ### SET
190 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
191 ### @2=3 /* INT meta=0 nullable=1 is_null=0 */
192 # Number of rows: 1
193 # at #
194 #010909 4:46:40 server id # end_log_pos # CRC32 XXX 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 # CRC32 XXX GTID 0-1-9 thread_id=#
200 /*M!100001 SET @@session.gtid_seq_no=9*//*!*/;
201 START TRANSACTION
202 /*!*/;
203 # at #
204 # at #
205 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Annotate_rows:
206 #Q> LOAD DATA INFILE '../../std_data/loaddata7.dat' INTO TABLE t1
207 #Q> FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n'
208 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Table_map: `new_test1`.`t1` mapped to number #
209 # at #
210 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Write_rows: table id # flags: STMT_END_F
211 ### INSERT INTO `new_test1`.`t1`
212 ### SET
213 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
214 ### @2=2 /* INT meta=0 nullable=1 is_null=0 */
215 ### INSERT INTO `new_test1`.`t1`
216 ### SET
217 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
218 ### @2=3 /* INT meta=0 nullable=1 is_null=0 */
219 ### INSERT INTO `new_test1`.`t1`
220 ### SET
221 ### @1=4 /* INT meta=0 nullable=1 is_null=0 */
222 ### @2=4 /* INT meta=0 nullable=1 is_null=0 */
223 ### INSERT INTO `new_test1`.`t1`
224 ### SET
225 ### @1=5 /* INT meta=0 nullable=1 is_null=0 */
226 ### @2=5 /* INT meta=0 nullable=1 is_null=0 */
227 ### INSERT INTO `new_test1`.`t1`
228 ### SET
229 ### @1=6 /* INT meta=0 nullable=1 is_null=0 */
230 ### @2=6 /* INT meta=0 nullable=1 is_null=0 */
231 # Number of rows: 5
232 # at #
233 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Query thread_id=# exec_time=# error_code=0 xid=<xid>
234 SET TIMESTAMP=1000000000/*!*/;
235 COMMIT
236 /*!*/;
237 # at #
238 #010909 4:46:40 server id # end_log_pos # CRC32 XXX GTID 0-1-10 thread_id=#
239 /*M!100001 SET @@session.gtid_seq_no=10*//*!*/;
240 START TRANSACTION
241 /*!*/;
242 # at #
243 # at #
244 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Annotate_rows:
245 #Q> DELETE FROM test3.t3 WHERE a=1
246 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Table_map: `new_test3`.`t3` mapped to number #
247 # at #
248 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Delete_rows: table id # flags: STMT_END_F
249 ### DELETE FROM `new_test3`.`t3`
250 ### WHERE
251 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
252 # Number of rows: 1
253 # at #
254 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Query thread_id=# exec_time=# error_code=0 xid=<xid>
255 SET TIMESTAMP=1000000000/*!*/;
256 COMMIT
257 /*!*/;
258 # at #
259 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Rotate to master-bin.000002 pos: 4
260 DELIMITER ;
261 # End of log file
262 ROLLBACK /* added by mysqlbinlog */;
263 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
264 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
265 #
266 # mysqlbinlog output
267 # --base64-output = decode-rows
268 # --rewrite-db = test1->new_test1
269 # --rewrite-db = test3->new_test3
270 # --read-from-remote-server
271 #
272 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
273 /*!40019 SET @@session.max_delayed_threads=0*/;
274 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
275 DELIMITER /*!*/;
276 # at #
277 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Start: binlog v 4, server v #.##.## created 010909 4:46:40 at startup
278 ROLLBACK/*!*/;
279 # at #
280 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Gtid list []
281 # at #
282 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Binlog checkpoint master-bin.000001
283 # at #
284 #010909 4:46:40 server id # end_log_pos # CRC32 XXX GTID 0-1-1 ddl thread_id=#
285 /*M!100101 SET @@session.skip_parallel_replication=0*//*!*/;
286 /*M!100001 SET @@session.gtid_domain_id=0*//*!*/;
287 /*M!100001 SET @@session.server_id=1*//*!*/;
288 /*M!100001 SET @@session.gtid_seq_no=1*//*!*/;
289 # at #
290 use `new_test1`/*!*/;
291 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Query thread_id=# exec_time=# error_code=0 xid=<xid>
292 SET TIMESTAMP=1000000000/*!*/;
293 SET @@session.pseudo_thread_id=#/*!*/;
294 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/*!*/;
295 SET @@session.sql_mode=1411383296/*!*/;
296 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
297 /*!\C latin1 *//*!*/;
298 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
299 SET @@session.lc_time_names=0/*!*/;
300 SET @@session.collation_database=DEFAULT/*!*/;
301 CREATE TABLE t1 (a INT, b INT)
302 /*!*/;
303 # at #
304 #010909 4:46:40 server id # end_log_pos # CRC32 XXX GTID 0-1-2 thread_id=#
305 /*M!100001 SET @@session.gtid_seq_no=2*//*!*/;
306 START TRANSACTION
307 /*!*/;
308 # at #
309 # at #
310 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Annotate_rows:
311 #Q> INSERT INTO t1 VALUES (1,1),(2,2)
312 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Table_map: `new_test1`.`t1` mapped to number #
313 # at #
314 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Write_rows: table id # flags: STMT_END_F
315 ### INSERT INTO `new_test1`.`t1`
316 ### SET
317 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
318 ### @2=1 /* INT meta=0 nullable=1 is_null=0 */
319 ### INSERT INTO `new_test1`.`t1`
320 ### SET
321 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
322 ### @2=2 /* INT meta=0 nullable=1 is_null=0 */
323 # Number of rows: 2
324 # at #
325 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Query thread_id=# exec_time=# error_code=0 xid=<xid>
326 SET TIMESTAMP=1000000000/*!*/;
327 COMMIT
328 /*!*/;
329 # at #
330 #010909 4:46:40 server id # end_log_pos # CRC32 XXX GTID 0-1-3 ddl thread_id=#
331 /*M!100001 SET @@session.gtid_seq_no=3*//*!*/;
332 # at #
333 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Query thread_id=# exec_time=# error_code=0 xid=<xid>
334 use `test2`/*!*/;
335 SET TIMESTAMP=1000000000/*!*/;
336 CREATE TABLE t2 (a INT)
337 /*!*/;
338 # at #
339 #010909 4:46:40 server id # end_log_pos # CRC32 XXX GTID 0-1-4 thread_id=#
340 /*M!100001 SET @@session.gtid_seq_no=4*//*!*/;
341 START TRANSACTION
342 /*!*/;
343 # at #
344 # at #
345 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Annotate_rows:
346 #Q> INSERT INTO t2 VALUES (1),(2)
347 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Table_map: `test2`.`t2` mapped to number #
348 # at #
349 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Write_rows: table id # flags: STMT_END_F
350 ### INSERT INTO `test2`.`t2`
351 ### SET
352 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
353 ### INSERT INTO `test2`.`t2`
354 ### SET
355 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
356 # Number of rows: 2
357 # at #
358 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Query thread_id=# exec_time=# error_code=0 xid=<xid>
359 SET TIMESTAMP=1000000000/*!*/;
360 COMMIT
361 /*!*/;
362 # at #
363 #010909 4:46:40 server id # end_log_pos # CRC32 XXX GTID 0-1-5 thread_id=#
364 /*M!100001 SET @@session.gtid_seq_no=5*//*!*/;
365 START TRANSACTION
366 /*!*/;
367 # at #
368 # at #
369 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Annotate_rows:
370 #Q> DELETE FROM test1.t1 WHERE a=1
371 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Table_map: `new_test1`.`t1` mapped to number #
372 # at #
373 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Delete_rows: table id # flags: STMT_END_F
374 ### DELETE FROM `new_test1`.`t1`
375 ### WHERE
376 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
377 ### @2=1 /* INT meta=0 nullable=1 is_null=0 */
378 # Number of rows: 1
379 # at #
380 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Query thread_id=# exec_time=# error_code=0 xid=<xid>
381 SET TIMESTAMP=1000000000/*!*/;
382 COMMIT
383 /*!*/;
384 # at #
385 #010909 4:46:40 server id # end_log_pos # CRC32 XXX GTID 0-1-6 ddl thread_id=#
386 /*M!100001 SET @@session.gtid_seq_no=6*//*!*/;
387 # at #
388 use `new_test3`/*!*/;
389 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Query thread_id=# exec_time=# error_code=0 xid=<xid>
390 SET TIMESTAMP=1000000000/*!*/;
391 CREATE TABLE t3 (a INT)
392 /*!*/;
393 # at #
394 #010909 4:46:40 server id # end_log_pos # CRC32 XXX GTID 0-1-7 thread_id=#
395 /*M!100001 SET @@session.gtid_seq_no=7*//*!*/;
396 START TRANSACTION
397 /*!*/;
398 # at #
399 # at #
400 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Annotate_rows:
401 #Q> INSERT INTO t3 VALUES (1),(2)
402 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Table_map: `new_test3`.`t3` mapped to number #
403 # at #
404 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Write_rows: table id # flags: STMT_END_F
405 ### INSERT INTO `new_test3`.`t3`
406 ### SET
407 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
408 ### INSERT INTO `new_test3`.`t3`
409 ### SET
410 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
411 # Number of rows: 2
412 # at #
413 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Query thread_id=# exec_time=# error_code=0 xid=<xid>
414 SET TIMESTAMP=1000000000/*!*/;
415 COMMIT
416 /*!*/;
417 # at #
418 #010909 4:46:40 server id # end_log_pos # CRC32 XXX GTID 0-1-8 thread_id=#
419 /*M!100001 SET @@session.gtid_seq_no=8*//*!*/;
420 START TRANSACTION
421 /*!*/;
422 # at #
423 # at #
424 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Annotate_rows:
425 #Q> INSERT INTO test1.t1 VALUES (3,3)
426 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Table_map: `new_test1`.`t1` mapped to number #
427 # at #
428 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Write_rows: table id # flags: STMT_END_F
429 ### INSERT INTO `new_test1`.`t1`
430 ### SET
431 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
432 ### @2=3 /* INT meta=0 nullable=1 is_null=0 */
433 # Number of rows: 1
434 # at #
435 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Query thread_id=# exec_time=# error_code=0 xid=<xid>
436 SET TIMESTAMP=1000000000/*!*/;
437 COMMIT
438 /*!*/;
439 # at #
440 #010909 4:46:40 server id # end_log_pos # CRC32 XXX GTID 0-1-9 thread_id=#
441 /*M!100001 SET @@session.gtid_seq_no=9*//*!*/;
442 START TRANSACTION
443 /*!*/;
444 # at #
445 # at #
446 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Annotate_rows:
447 #Q> LOAD DATA INFILE '../../std_data/loaddata7.dat' INTO TABLE t1
448 #Q> FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n'
449 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Table_map: `new_test1`.`t1` mapped to number #
450 # at #
451 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Write_rows: table id # flags: STMT_END_F
452 ### INSERT INTO `new_test1`.`t1`
453 ### SET
454 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
455 ### @2=2 /* INT meta=0 nullable=1 is_null=0 */
456 ### INSERT INTO `new_test1`.`t1`
457 ### SET
458 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
459 ### @2=3 /* INT meta=0 nullable=1 is_null=0 */
460 ### INSERT INTO `new_test1`.`t1`
461 ### SET
462 ### @1=4 /* INT meta=0 nullable=1 is_null=0 */
463 ### @2=4 /* INT meta=0 nullable=1 is_null=0 */
464 ### INSERT INTO `new_test1`.`t1`
465 ### SET
466 ### @1=5 /* INT meta=0 nullable=1 is_null=0 */
467 ### @2=5 /* INT meta=0 nullable=1 is_null=0 */
468 ### INSERT INTO `new_test1`.`t1`
469 ### SET
470 ### @1=6 /* INT meta=0 nullable=1 is_null=0 */
471 ### @2=6 /* INT meta=0 nullable=1 is_null=0 */
472 # Number of rows: 5
473 # at #
474 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Query thread_id=# exec_time=# error_code=0 xid=<xid>
475 SET TIMESTAMP=1000000000/*!*/;
476 COMMIT
477 /*!*/;
478 # at #
479 #010909 4:46:40 server id # end_log_pos # CRC32 XXX GTID 0-1-10 thread_id=#
480 /*M!100001 SET @@session.gtid_seq_no=10*//*!*/;
481 START TRANSACTION
482 /*!*/;
483 # at #
484 # at #
485 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Annotate_rows:
486 #Q> DELETE FROM test3.t3 WHERE a=1
487 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Table_map: `new_test3`.`t3` mapped to number #
488 # at #
489 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Delete_rows: table id # flags: STMT_END_F
490 ### DELETE FROM `new_test3`.`t3`
491 ### WHERE
492 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
493 # Number of rows: 1
494 # at #
495 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Query thread_id=# exec_time=# error_code=0 xid=<xid>
496 SET TIMESTAMP=1000000000/*!*/;
497 COMMIT
498 /*!*/;
499 # at #
500 #010909 4:46:40 server id # end_log_pos # CRC32 XXX Rotate to master-bin.000002 pos: 4
501 DELIMITER ;
502 # End of log file
503 ROLLBACK /* added by mysqlbinlog */;
504 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
505 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
506 DROP DATABASE test1;
507 DROP DATABASE test2;
508 DROP DATABASE test3;