Debian Codegraph @

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

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