Debian Codegraph @

mysql-test/suite/binlog_nogtid/r/binlog_mysqlbinlog_row_trans_myisam.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 include/mysqlbinlog.inc
128 # The proper term is pseudo_replica_mode, but we use this compatibility alias
129 # to make the statement usable on server versions 8.0.24 and older.
130 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
131 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
132 DELIMITER /*!*/;
133 # at #
134 # # server id # end_log_pos # CRC32 # Start: binlog v #, server v # created # at startup
135 ROLLBACK/*!*/;
136 # at #
137 # # server id # end_log_pos # CRC32 # Previous-GTIDs
138 # [empty]
139 # at #
140 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=no original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
141 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
142 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
143 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
144 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
145 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
146 SET @@SESSION.GTID_NEXT= '#'/*!*/;
147 # at #
148 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 Xid = #
149 use `test`/*!*/;
150 SET TIMESTAMP=#/*!*/;
151 SET @@session.pseudo_thread_id=#/*!*/;
152 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
153 SET @@session.sql_mode=1168113696/*!*/;
154 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
155 /*!\C utf8mb4 *//*!*/;
156 SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=255/*!*/;
157 SET @@session.lc_time_names=0/*!*/;
158 SET @@session.collation_database=DEFAULT/*!*/;
159 /*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/;
160 /*!80013 SET @@session.sql_require_primary_key=0*//*!*/;
161 CREATE TABLE t1 (
162 c1 INT,
163 c2 VARCHAR(20)
164 ) ENGINE=InnoDB DEFAULT CHARSET latin1
165 /*!*/;
166 # at #
167 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=no original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
168 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
169 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
170 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
171 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
172 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
173 SET @@SESSION.GTID_NEXT= '#'/*!*/;
174 # at #
175 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
176 SET TIMESTAMP=#/*!*/;
177 /*!80013 SET @@session.sql_require_primary_key=0*//*!*/;
178 CREATE TABLE t2 (
179 c1 INT,
180 c2 VARCHAR(20)
181 ) ENGINE=MyISAM DEFAULT CHARSET latin1
182 /*!*/;
183 # at #
184 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=yes original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
185 /*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/;
186 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
187 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
188 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
189 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
190 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
191 SET @@SESSION.GTID_NEXT= '#'/*!*/;
192 # at #
193 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
194 SET TIMESTAMP=#/*!*/;
195 BEGIN
196 /*!*/;
197 # at #
198 # # server id # end_log_pos # CRC32 # Table_map: `test`.`t1` mapped to number #
199 # has_generated_invisible_primary_key=0
200 # at #
201 # # server id # end_log_pos # CRC32 # Write_rows: table id # flags: STMT_END_F
202 ### INSERT INTO `test`.`t1`
203 ### SET
204 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
205 ### @2='varchar-1' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
206 ### INSERT INTO `test`.`t1`
207 ### SET
208 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
209 ### @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
210 ### INSERT INTO `test`.`t1`
211 ### SET
212 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
213 ### @2='varchar-3' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
214 # at #
215 # # server id # end_log_pos # CRC32 # Table_map: `test`.`t1` mapped to number #
216 # has_generated_invisible_primary_key=0
217 # at #
218 # # server id # end_log_pos # CRC32 # Update_rows: table id # flags: STMT_END_F
219 ### UPDATE `test`.`t1`
220 ### WHERE
221 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
222 ### @2='varchar-1' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
223 ### SET
224 ### @1=11 /* INT meta=0 nullable=1 is_null=0 */
225 ### @2='varchar-1' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
226 ### UPDATE `test`.`t1`
227 ### WHERE
228 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
229 ### @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
230 ### SET
231 ### @1=12 /* INT meta=0 nullable=1 is_null=0 */
232 ### @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
233 ### UPDATE `test`.`t1`
234 ### WHERE
235 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
236 ### @2='varchar-3' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
237 ### SET
238 ### @1=13 /* INT meta=0 nullable=1 is_null=0 */
239 ### @2='varchar-3' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
240 # at #
241 # # server id # end_log_pos # CRC32 # Table_map: `test`.`t1` mapped to number #
242 # has_generated_invisible_primary_key=0
243 # at #
244 # # server id # end_log_pos # CRC32 # Delete_rows: table id # flags: STMT_END_F
245 ### DELETE FROM `test`.`t1`
246 ### WHERE
247 ### @1=12 /* INT meta=0 nullable=1 is_null=0 */
248 ### @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
249 # at #
250 # # server id # end_log_pos # CRC32 # Xid = #
251 COMMIT/*!*/;
252 # at #
253 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=no original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
254 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
255 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
256 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
257 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
258 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
259 SET @@SESSION.GTID_NEXT= '#'/*!*/;
260 # at #
261 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 Xid = #
262 SET TIMESTAMP=#/*!*/;
263 TRUNCATE TABLE t1
264 /*!*/;
265 # at #
266 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=no original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
267 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
268 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
269 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
270 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
271 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
272 SET @@SESSION.GTID_NEXT= '#'/*!*/;
273 # at #
274 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 Xid = #
275 SET TIMESTAMP=#/*!*/;
276 TRUNCATE TABLE t1
277 /*!*/;
278 # at #
279 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=yes original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
280 /*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/;
281 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
282 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
283 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
284 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
285 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
286 SET @@SESSION.GTID_NEXT= '#'/*!*/;
287 # at #
288 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
289 SET TIMESTAMP=#/*!*/;
290 BEGIN
291 /*!*/;
292 # at #
293 # # server id # end_log_pos # CRC32 # Table_map: `test`.`t2` mapped to number #
294 # has_generated_invisible_primary_key=0
295 # at #
296 # # server id # end_log_pos # CRC32 # Write_rows: table id # flags: STMT_END_F
297 ### INSERT INTO `test`.`t2`
298 ### SET
299 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
300 ### @2='varchar-1' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
301 ### INSERT INTO `test`.`t2`
302 ### SET
303 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
304 ### @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
305 ### INSERT INTO `test`.`t2`
306 ### SET
307 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
308 ### @2='varchar-3' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
309 # at #
310 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
311 SET TIMESTAMP=#/*!*/;
312 COMMIT
313 /*!*/;
314 # at #
315 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=yes original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
316 /*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/;
317 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
318 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
319 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
320 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
321 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
322 SET @@SESSION.GTID_NEXT= '#'/*!*/;
323 # at #
324 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
325 SET TIMESTAMP=#/*!*/;
326 BEGIN
327 /*!*/;
328 # at #
329 # # server id # end_log_pos # CRC32 # Table_map: `test`.`t2` mapped to number #
330 # has_generated_invisible_primary_key=0
331 # at #
332 # # server id # end_log_pos # CRC32 # Update_rows: table id # flags: STMT_END_F
333 ### UPDATE `test`.`t2`
334 ### WHERE
335 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
336 ### @2='varchar-1' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
337 ### SET
338 ### @1=11 /* INT meta=0 nullable=1 is_null=0 */
339 ### @2='varchar-1' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
340 ### UPDATE `test`.`t2`
341 ### WHERE
342 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
343 ### @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
344 ### SET
345 ### @1=12 /* INT meta=0 nullable=1 is_null=0 */
346 ### @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
347 ### UPDATE `test`.`t2`
348 ### WHERE
349 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
350 ### @2='varchar-3' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
351 ### SET
352 ### @1=13 /* INT meta=0 nullable=1 is_null=0 */
353 ### @2='varchar-3' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
354 # at #
355 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
356 SET TIMESTAMP=#/*!*/;
357 COMMIT
358 /*!*/;
359 # at #
360 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=yes original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
361 /*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/;
362 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
363 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
364 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
365 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
366 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
367 SET @@SESSION.GTID_NEXT= '#'/*!*/;
368 # at #
369 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
370 SET TIMESTAMP=#/*!*/;
371 BEGIN
372 /*!*/;
373 # at #
374 # # server id # end_log_pos # CRC32 # Table_map: `test`.`t2` mapped to number #
375 # has_generated_invisible_primary_key=0
376 # at #
377 # # server id # end_log_pos # CRC32 # Delete_rows: table id # flags: STMT_END_F
378 ### DELETE FROM `test`.`t2`
379 ### WHERE
380 ### @1=12 /* INT meta=0 nullable=1 is_null=0 */
381 ### @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
382 # at #
383 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
384 SET TIMESTAMP=#/*!*/;
385 COMMIT
386 /*!*/;
387 # at #
388 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=yes original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
389 /*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/;
390 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
391 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
392 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
393 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
394 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
395 SET @@SESSION.GTID_NEXT= '#'/*!*/;
396 # at #
397 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
398 SET TIMESTAMP=#/*!*/;
399 BEGIN
400 /*!*/;
401 # at #
402 # # server id # end_log_pos # CRC32 # Table_map: `test`.`t1` mapped to number #
403 # has_generated_invisible_primary_key=0
404 # at #
405 # # server id # end_log_pos # CRC32 # Write_rows: table id # flags: STMT_END_F
406 ### INSERT INTO `test`.`t1`
407 ### SET
408 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
409 ### @2='varchar-1' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
410 ### INSERT INTO `test`.`t1`
411 ### SET
412 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
413 ### @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
414 ### INSERT INTO `test`.`t1`
415 ### SET
416 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
417 ### @2='varchar-3' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
418 # at #
419 # # server id # end_log_pos # CRC32 # Table_map: `test`.`t1` mapped to number #
420 # has_generated_invisible_primary_key=0
421 # at #
422 # # server id # end_log_pos # CRC32 # Update_rows: table id # flags: STMT_END_F
423 ### UPDATE `test`.`t1`
424 ### WHERE
425 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
426 ### @2='varchar-1' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
427 ### SET
428 ### @1=11 /* INT meta=0 nullable=1 is_null=0 */
429 ### @2='varchar-1' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
430 ### UPDATE `test`.`t1`
431 ### WHERE
432 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
433 ### @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
434 ### SET
435 ### @1=12 /* INT meta=0 nullable=1 is_null=0 */
436 ### @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
437 ### UPDATE `test`.`t1`
438 ### WHERE
439 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
440 ### @2='varchar-3' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
441 ### SET
442 ### @1=13 /* INT meta=0 nullable=1 is_null=0 */
443 ### @2='varchar-3' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
444 # at #
445 # # server id # end_log_pos # CRC32 # Table_map: `test`.`t1` mapped to number #
446 # has_generated_invisible_primary_key=0
447 # at #
448 # # server id # end_log_pos # CRC32 # Delete_rows: table id # flags: STMT_END_F
449 ### DELETE FROM `test`.`t1`
450 ### WHERE
451 ### @1=12 /* INT meta=0 nullable=1 is_null=0 */
452 ### @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
453 # at #
454 # # server id # end_log_pos # CRC32 # Xid = #
455 COMMIT/*!*/;
456 # at #
457 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=no original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
458 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
459 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
460 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
461 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
462 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
463 SET @@SESSION.GTID_NEXT= '#'/*!*/;
464 # at #
465 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 Xid = #
466 SET TIMESTAMP=#/*!*/;
467 TRUNCATE TABLE t1
468 /*!*/;
469 # at #
470 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=no original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
471 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
472 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
473 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
474 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
475 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
476 SET @@SESSION.GTID_NEXT= '#'/*!*/;
477 # at #
478 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
479 SET TIMESTAMP=#/*!*/;
480 TRUNCATE TABLE t2
481 /*!*/;
482 # at #
483 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=yes original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
484 /*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/;
485 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
486 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
487 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
488 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
489 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
490 SET @@SESSION.GTID_NEXT= '#'/*!*/;
491 # at #
492 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
493 SET TIMESTAMP=#/*!*/;
494 BEGIN
495 /*!*/;
496 # at #
497 # # server id # end_log_pos # CRC32 # Table_map: `test`.`t2` mapped to number #
498 # has_generated_invisible_primary_key=0
499 # at #
500 # # server id # end_log_pos # CRC32 # Write_rows: table id # flags: STMT_END_F
501 ### INSERT INTO `test`.`t2`
502 ### SET
503 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
504 ### @2='varchar-1' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
505 ### INSERT INTO `test`.`t2`
506 ### SET
507 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
508 ### @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
509 ### INSERT INTO `test`.`t2`
510 ### SET
511 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
512 ### @2='varchar-3' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
513 # at #
514 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
515 SET TIMESTAMP=#/*!*/;
516 COMMIT
517 /*!*/;
518 # at #
519 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=yes original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
520 /*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/;
521 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
522 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
523 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
524 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
525 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
526 SET @@SESSION.GTID_NEXT= '#'/*!*/;
527 # at #
528 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
529 SET TIMESTAMP=#/*!*/;
530 BEGIN
531 /*!*/;
532 # at #
533 # # server id # end_log_pos # CRC32 # Table_map: `test`.`t2` mapped to number #
534 # has_generated_invisible_primary_key=0
535 # at #
536 # # server id # end_log_pos # CRC32 # Update_rows: table id # flags: STMT_END_F
537 ### UPDATE `test`.`t2`
538 ### WHERE
539 ### @1=1 /* INT meta=0 nullable=1 is_null=0 */
540 ### @2='varchar-1' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
541 ### SET
542 ### @1=11 /* INT meta=0 nullable=1 is_null=0 */
543 ### @2='varchar-1' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
544 ### UPDATE `test`.`t2`
545 ### WHERE
546 ### @1=2 /* INT meta=0 nullable=1 is_null=0 */
547 ### @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
548 ### SET
549 ### @1=12 /* INT meta=0 nullable=1 is_null=0 */
550 ### @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
551 ### UPDATE `test`.`t2`
552 ### WHERE
553 ### @1=3 /* INT meta=0 nullable=1 is_null=0 */
554 ### @2='varchar-3' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
555 ### SET
556 ### @1=13 /* INT meta=0 nullable=1 is_null=0 */
557 ### @2='varchar-3' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
558 # at #
559 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
560 SET TIMESTAMP=#/*!*/;
561 COMMIT
562 /*!*/;
563 # at #
564 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=yes original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
565 /*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/;
566 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
567 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
568 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
569 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
570 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
571 SET @@SESSION.GTID_NEXT= '#'/*!*/;
572 # at #
573 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
574 SET TIMESTAMP=#/*!*/;
575 BEGIN
576 /*!*/;
577 # at #
578 # # server id # end_log_pos # CRC32 # Table_map: `test`.`t2` mapped to number #
579 # has_generated_invisible_primary_key=0
580 # at #
581 # # server id # end_log_pos # CRC32 # Delete_rows: table id # flags: STMT_END_F
582 ### DELETE FROM `test`.`t2`
583 ### WHERE
584 ### @1=12 /* INT meta=0 nullable=1 is_null=0 */
585 ### @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
586 # at #
587 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
588 SET TIMESTAMP=#/*!*/;
589 COMMIT
590 /*!*/;
591 # at #
592 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=no original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
593 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
594 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
595 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
596 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
597 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
598 SET @@SESSION.GTID_NEXT= '#'/*!*/;
599 # at #
600 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0 Xid = #
601 SET TIMESTAMP=#/*!*/;
602 TRUNCATE TABLE t1
603 /*!*/;
604 # at #
605 # # server id # end_log_pos # CRC32 # Anonymous_GTID last_committed=# sequence_number=# rbr_only=no original_committed_timestamp=# immediate_commit_timestamp=# transaction_length=#
606 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
607 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
608 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
609 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
610 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
611 SET @@SESSION.GTID_NEXT= '#'/*!*/;
612 # at #
613 # # server id # end_log_pos # CRC32 # Query thread_id=# exec_time=# error_code=0
614 SET TIMESTAMP=#/*!*/;
615 TRUNCATE TABLE t2
616 /*!*/;
617 # at #
618 # # server id # end_log_pos # CRC32 # Rotate to binlog.000002 pos: 4
619 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
620 DELIMITER ;
621 # End of log file
622 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
623 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
624 #
625 # Cleanup.
626 #
627 DROP TABLE t1, t2;