4
DROP TABLE IF EXISTS t1, t2;
6
# We need a fixed timestamp to avoid varying results.
8
SET timestamp=1000000000;
10
# Delete all existing binary logs.
19
) ENGINE=InnoDB DEFAULT CHARSET latin1;
23
) ENGINE=MyISAM DEFAULT CHARSET latin1;
25
# Start transaction #1, transactional table only, commit.
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;
44
# Start transaction #2, transactional table only, rollback.
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;
54
# Rollback transaction.
61
# Start transaction #3, both tables, commit.
65
# Do some statements on the transactional table.
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;
71
# Do some statements on the non-transactional table.
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;
91
# Start transaction #4, both tables, rollback.
95
# Do some statements on the transactional table.
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;
101
# Do some statements on the non-transactional table.
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;
107
# Rollback transaction.
111
Warning 1196 Some non-transactional changed tables couldn't be rolled back
121
# Flush all log buffers to the log file.
125
# Call mysqlbinlog to display the log file contents.
127
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
128
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
131
#010909 4:46:40 server id 1 end_log_pos # Start: binlog v 4, server v #.##.## created 010909 4:46:40 at startup
134
#010909 4:46:40 server id 1 end_log_pos # Query thread_id=# exec_time=# error_code=0
136
SET TIMESTAMP=1000000000/*!*/;
137
SET @@session.pseudo_thread_id=#/*!*/;
138
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
139
SET @@session.sql_mode=0/*!*/;
140
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
141
/*!\C latin1 *//*!*/;
142
SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/;
143
SET @@session.lc_time_names=0/*!*/;
144
SET @@session.collation_database=DEFAULT/*!*/;
148
) ENGINE=InnoDB DEFAULT CHARSET latin1
151
#010909 4:46:40 server id 1 end_log_pos # Query thread_id=# exec_time=# error_code=0
152
SET TIMESTAMP=1000000000/*!*/;
156
) ENGINE=MyISAM DEFAULT CHARSET latin1
159
#010909 4:46:40 server id 1 end_log_pos # Query thread_id=# exec_time=# error_code=0
160
SET TIMESTAMP=1000000000/*!*/;
165
#010909 4:46:40 server id 1 end_log_pos # Table_map: `test`.`t1` mapped to number #
166
#010909 4:46:40 server id 1 end_log_pos # Write_rows: table id # flags: STMT_END_F
167
### INSERT INTO test.t1
169
### @1=1 /* INT meta=0 nullable=1 is_null=0 */
170
### @2='varchar-1' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
171
### INSERT INTO test.t1
173
### @1=2 /* INT meta=0 nullable=1 is_null=0 */
174
### @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
175
### INSERT INTO test.t1
177
### @1=3 /* INT meta=0 nullable=1 is_null=0 */
178
### @2='varchar-3' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
181
#010909 4:46:40 server id 1 end_log_pos # Table_map: `test`.`t1` mapped to number #
182
#010909 4:46:40 server id 1 end_log_pos # Update_rows: table id # flags: STMT_END_F
185
### @1=1 /* INT meta=0 nullable=1 is_null=0 */
186
### @2='varchar-1' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
188
### @1=11 /* INT meta=0 nullable=1 is_null=0 */
189
### @2='varchar-1' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
192
### @1=2 /* INT meta=0 nullable=1 is_null=0 */
193
### @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
195
### @1=12 /* INT meta=0 nullable=1 is_null=0 */
196
### @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
199
### @1=3 /* INT meta=0 nullable=1 is_null=0 */
200
### @2='varchar-3' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
202
### @1=13 /* INT meta=0 nullable=1 is_null=0 */
203
### @2='varchar-3' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
206
#010909 4:46:40 server id 1 end_log_pos # Table_map: `test`.`t1` mapped to number #
207
#010909 4:46:40 server id 1 end_log_pos # Delete_rows: table id # flags: STMT_END_F
208
### DELETE FROM test.t1
210
### @1=12 /* INT meta=0 nullable=1 is_null=0 */
211
### @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
213
#010909 4:46:40 server id 1 end_log_pos # Xid = #
216
#010909 4:46:40 server id 1 end_log_pos # Query thread_id=# exec_time=# error_code=0
217
SET TIMESTAMP=1000000000/*!*/;
221
#010909 4:46:40 server id 1 end_log_pos # Query thread_id=# exec_time=# error_code=0
222
SET TIMESTAMP=1000000000/*!*/;
226
#010909 4:46:40 server id 1 end_log_pos # Query thread_id=# exec_time=# error_code=0
227
SET TIMESTAMP=1000000000/*!*/;
232
#010909 4:46:40 server id 1 end_log_pos # Table_map: `test`.`t2` mapped to number #
233
#010909 4:46:40 server id 1 end_log_pos # Write_rows: table id # flags: STMT_END_F
234
### INSERT INTO test.t2
236
### @1=1 /* INT meta=0 nullable=1 is_null=0 */
237
### @2='varchar-1' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
238
### INSERT INTO test.t2
240
### @1=2 /* INT meta=0 nullable=1 is_null=0 */
241
### @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
242
### INSERT INTO test.t2
244
### @1=3 /* INT meta=0 nullable=1 is_null=0 */
245
### @2='varchar-3' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
247
#010909 4:46:40 server id 1 end_log_pos # Query thread_id=# exec_time=# error_code=0
248
SET TIMESTAMP=1000000000/*!*/;
252
#010909 4:46:40 server id 1 end_log_pos # Query thread_id=# exec_time=# error_code=0
253
SET TIMESTAMP=1000000000/*!*/;
258
#010909 4:46:40 server id 1 end_log_pos # Table_map: `test`.`t2` mapped to number #
259
#010909 4:46:40 server id 1 end_log_pos # Update_rows: table id # flags: STMT_END_F
262
### @1=1 /* INT meta=0 nullable=1 is_null=0 */
263
### @2='varchar-1' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
265
### @1=11 /* INT meta=0 nullable=1 is_null=0 */
266
### @2='varchar-1' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
269
### @1=2 /* INT meta=0 nullable=1 is_null=0 */
270
### @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
272
### @1=12 /* INT meta=0 nullable=1 is_null=0 */
273
### @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
276
### @1=3 /* INT meta=0 nullable=1 is_null=0 */
277
### @2='varchar-3' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
279
### @1=13 /* INT meta=0 nullable=1 is_null=0 */
280
### @2='varchar-3' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
282
#010909 4:46:40 server id 1 end_log_pos # Query thread_id=# exec_time=# error_code=0
283
SET TIMESTAMP=1000000000/*!*/;
287
#010909 4:46:40 server id 1 end_log_pos # Query thread_id=# exec_time=# error_code=0
288
SET TIMESTAMP=1000000000/*!*/;
293
#010909 4:46:40 server id 1 end_log_pos # Table_map: `test`.`t2` mapped to number #
294
#010909 4:46:40 server id 1 end_log_pos # Delete_rows: table id # flags: STMT_END_F
295
### DELETE FROM test.t2
297
### @1=12 /* INT meta=0 nullable=1 is_null=0 */
298
### @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
300
#010909 4:46:40 server id 1 end_log_pos # Query thread_id=# exec_time=# error_code=0
301
SET TIMESTAMP=1000000000/*!*/;
305
#010909 4:46:40 server id 1 end_log_pos # Query thread_id=# exec_time=# error_code=0
306
SET TIMESTAMP=1000000000/*!*/;
311
#010909 4:46:40 server id 1 end_log_pos # Table_map: `test`.`t1` mapped to number #
312
#010909 4:46:40 server id 1 end_log_pos # Write_rows: table id # flags: STMT_END_F
313
### INSERT INTO test.t1
315
### @1=1 /* INT meta=0 nullable=1 is_null=0 */
316
### @2='varchar-1' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
317
### INSERT INTO test.t1
319
### @1=2 /* INT meta=0 nullable=1 is_null=0 */
320
### @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
321
### INSERT INTO test.t1
323
### @1=3 /* INT meta=0 nullable=1 is_null=0 */
324
### @2='varchar-3' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
327
#010909 4:46:40 server id 1 end_log_pos # Table_map: `test`.`t1` mapped to number #
328
#010909 4:46:40 server id 1 end_log_pos # Update_rows: table id # flags: STMT_END_F
331
### @1=1 /* INT meta=0 nullable=1 is_null=0 */
332
### @2='varchar-1' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
334
### @1=11 /* INT meta=0 nullable=1 is_null=0 */
335
### @2='varchar-1' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
338
### @1=2 /* INT meta=0 nullable=1 is_null=0 */
339
### @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
341
### @1=12 /* INT meta=0 nullable=1 is_null=0 */
342
### @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
345
### @1=3 /* INT meta=0 nullable=1 is_null=0 */
346
### @2='varchar-3' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
348
### @1=13 /* INT meta=0 nullable=1 is_null=0 */
349
### @2='varchar-3' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
352
#010909 4:46:40 server id 1 end_log_pos # Table_map: `test`.`t1` mapped to number #
353
#010909 4:46:40 server id 1 end_log_pos # Delete_rows: table id # flags: STMT_END_F
354
### DELETE FROM test.t1
356
### @1=12 /* INT meta=0 nullable=1 is_null=0 */
357
### @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
359
#010909 4:46:40 server id 1 end_log_pos # Xid = #
362
#010909 4:46:40 server id 1 end_log_pos # Query thread_id=# exec_time=# error_code=0
363
SET TIMESTAMP=1000000000/*!*/;
367
#010909 4:46:40 server id 1 end_log_pos # Query thread_id=# exec_time=# error_code=0
368
SET TIMESTAMP=1000000000/*!*/;
372
#010909 4:46:40 server id 1 end_log_pos # Query thread_id=# exec_time=# error_code=0
373
SET TIMESTAMP=1000000000/*!*/;
378
#010909 4:46:40 server id 1 end_log_pos # Table_map: `test`.`t2` mapped to number #
379
#010909 4:46:40 server id 1 end_log_pos # Write_rows: table id # flags: STMT_END_F
380
### INSERT INTO test.t2
382
### @1=1 /* INT meta=0 nullable=1 is_null=0 */
383
### @2='varchar-1' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
384
### INSERT INTO test.t2
386
### @1=2 /* INT meta=0 nullable=1 is_null=0 */
387
### @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
388
### INSERT INTO test.t2
390
### @1=3 /* INT meta=0 nullable=1 is_null=0 */
391
### @2='varchar-3' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
393
#010909 4:46:40 server id 1 end_log_pos # Query thread_id=# exec_time=# error_code=0
394
SET TIMESTAMP=1000000000/*!*/;
398
#010909 4:46:40 server id 1 end_log_pos # Query thread_id=# exec_time=# error_code=0
399
SET TIMESTAMP=1000000000/*!*/;
404
#010909 4:46:40 server id 1 end_log_pos # Table_map: `test`.`t2` mapped to number #
405
#010909 4:46:40 server id 1 end_log_pos # Update_rows: table id # flags: STMT_END_F
408
### @1=1 /* INT meta=0 nullable=1 is_null=0 */
409
### @2='varchar-1' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
411
### @1=11 /* INT meta=0 nullable=1 is_null=0 */
412
### @2='varchar-1' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
415
### @1=2 /* INT meta=0 nullable=1 is_null=0 */
416
### @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
418
### @1=12 /* INT meta=0 nullable=1 is_null=0 */
419
### @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
422
### @1=3 /* INT meta=0 nullable=1 is_null=0 */
423
### @2='varchar-3' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
425
### @1=13 /* INT meta=0 nullable=1 is_null=0 */
426
### @2='varchar-3' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
428
#010909 4:46:40 server id 1 end_log_pos # Query thread_id=# exec_time=# error_code=0
429
SET TIMESTAMP=1000000000/*!*/;
433
#010909 4:46:40 server id 1 end_log_pos # Query thread_id=# exec_time=# error_code=0
434
SET TIMESTAMP=1000000000/*!*/;
439
#010909 4:46:40 server id 1 end_log_pos # Table_map: `test`.`t2` mapped to number #
440
#010909 4:46:40 server id 1 end_log_pos # Delete_rows: table id # flags: STMT_END_F
441
### DELETE FROM test.t2
443
### @1=12 /* INT meta=0 nullable=1 is_null=0 */
444
### @2='varchar-2' /* VARSTRING(20) meta=20 nullable=1 is_null=0 */
446
#010909 4:46:40 server id 1 end_log_pos # Query thread_id=# exec_time=# error_code=0
447
SET TIMESTAMP=1000000000/*!*/;
451
#010909 4:46:40 server id 1 end_log_pos # Query thread_id=# exec_time=# error_code=0
452
SET TIMESTAMP=1000000000/*!*/;
456
#010909 4:46:40 server id 1 end_log_pos # Query thread_id=# exec_time=# error_code=0
457
SET TIMESTAMP=1000000000/*!*/;
461
#010909 4:46:40 server id 1 end_log_pos # Rotate to master-bin.000002 pos: 4
464
ROLLBACK /* added by mysqlbinlog */;
465
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;