Debian Codegraph @

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

raw
1 set sql_mode="";
2 set global binlog_checksum=NONE;
3 drop table if exists t1;
4 set @a=UNIX_TIMESTAMP("1970-01-21 15:32:22");
5 set timestamp=@a;
6 reset master;
7 create table t1 (a int auto_increment not null primary key, b char(3));
8 insert into t1 values(null, "a");
9 insert into t1 values(null, "b");
10 set timestamp=@a+2;
11 insert into t1 values(null, "c");
12 set timestamp=@a+4;
13 insert into t1 values(null, "d");
14 insert into t1 values(null, "e");
15 flush logs;
16 set timestamp=@a+1;
17 insert into t1 values(null, "f");
18
19 --- Local --
20 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
21 /*!40019 SET @@session.max_delayed_threads=0*/;
22 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
23 DELIMITER /*!*/;
24 ROLLBACK/*!*/;
25 use `test`/*!*/;
26 SET TIMESTAMP=1773142/*!*/;
27 SET @@session.pseudo_thread_id=999999999/*!*/;
28 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/*!*/;
29 SET @@session.sql_mode=0/*!*/;
30 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
31 /*!\C latin1 *//*!*/;
32 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
33 SET @@session.lc_time_names=0/*!*/;
34 SET @@session.collation_database=DEFAULT/*!*/;
35 create table t1 (a int auto_increment not null primary key, b char(3))
36 /*!*/;
37 START TRANSACTION
38 /*!*/;
39 SET INSERT_ID=1/*!*/;
40 SET TIMESTAMP=1773142/*!*/;
41 insert into t1 values(null, "a")
42 /*!*/;
43 SET TIMESTAMP=1773142/*!*/;
44 COMMIT
45 /*!*/;
46 START TRANSACTION
47 /*!*/;
48 SET INSERT_ID=2/*!*/;
49 SET TIMESTAMP=1773142/*!*/;
50 insert into t1 values(null, "b")
51 /*!*/;
52 SET TIMESTAMP=1773142/*!*/;
53 COMMIT
54 /*!*/;
55 START TRANSACTION
56 /*!*/;
57 SET INSERT_ID=3/*!*/;
58 SET TIMESTAMP=1773144/*!*/;
59 insert into t1 values(null, "c")
60 /*!*/;
61 SET TIMESTAMP=1773144/*!*/;
62 COMMIT
63 /*!*/;
64 START TRANSACTION
65 /*!*/;
66 SET INSERT_ID=4/*!*/;
67 SET TIMESTAMP=1773146/*!*/;
68 insert into t1 values(null, "d")
69 /*!*/;
70 SET TIMESTAMP=1773146/*!*/;
71 COMMIT
72 /*!*/;
73 START TRANSACTION
74 /*!*/;
75 SET INSERT_ID=5/*!*/;
76 SET TIMESTAMP=1773146/*!*/;
77 insert into t1 values(null, "e")
78 /*!*/;
79 SET TIMESTAMP=1773146/*!*/;
80 COMMIT
81 /*!*/;
82 DELIMITER ;
83 # End of log file
84 ROLLBACK /* added by mysqlbinlog */;
85 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
86 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
87
88 --- offset --
89 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
90 /*!40019 SET @@session.max_delayed_threads=0*/;
91 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
92 DELIMITER /*!*/;
93 ROLLBACK/*!*/;
94 START TRANSACTION
95 /*!*/;
96 SET INSERT_ID=1/*!*/;
97 use `test`/*!*/;
98 SET TIMESTAMP=1773142/*!*/;
99 SET @@session.pseudo_thread_id=999999999/*!*/;
100 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/*!*/;
101 SET @@session.sql_mode=0/*!*/;
102 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
103 /*!\C latin1 *//*!*/;
104 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
105 SET @@session.lc_time_names=0/*!*/;
106 SET @@session.collation_database=DEFAULT/*!*/;
107 insert into t1 values(null, "a")
108 /*!*/;
109 SET TIMESTAMP=1773142/*!*/;
110 COMMIT
111 /*!*/;
112 START TRANSACTION
113 /*!*/;
114 SET INSERT_ID=2/*!*/;
115 SET TIMESTAMP=1773142/*!*/;
116 insert into t1 values(null, "b")
117 /*!*/;
118 SET TIMESTAMP=1773142/*!*/;
119 COMMIT
120 /*!*/;
121 START TRANSACTION
122 /*!*/;
123 SET INSERT_ID=3/*!*/;
124 SET TIMESTAMP=1773144/*!*/;
125 insert into t1 values(null, "c")
126 /*!*/;
127 SET TIMESTAMP=1773144/*!*/;
128 COMMIT
129 /*!*/;
130 START TRANSACTION
131 /*!*/;
132 SET INSERT_ID=4/*!*/;
133 SET TIMESTAMP=1773146/*!*/;
134 insert into t1 values(null, "d")
135 /*!*/;
136 SET TIMESTAMP=1773146/*!*/;
137 COMMIT
138 /*!*/;
139 START TRANSACTION
140 /*!*/;
141 SET INSERT_ID=5/*!*/;
142 SET TIMESTAMP=1773146/*!*/;
143 insert into t1 values(null, "e")
144 /*!*/;
145 SET TIMESTAMP=1773146/*!*/;
146 COMMIT
147 /*!*/;
148 DELIMITER ;
149 # End of log file
150 ROLLBACK /* added by mysqlbinlog */;
151 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
152 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
153
154 --- start-position --
155 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
156 /*!40019 SET @@session.max_delayed_threads=0*/;
157 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
158 DELIMITER /*!*/;
159 ROLLBACK/*!*/;
160 START TRANSACTION
161 /*!*/;
162 SET INSERT_ID=3/*!*/;
163 use `test`/*!*/;
164 SET TIMESTAMP=1773144/*!*/;
165 SET @@session.pseudo_thread_id=999999999/*!*/;
166 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/*!*/;
167 SET @@session.sql_mode=0/*!*/;
168 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
169 /*!\C latin1 *//*!*/;
170 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
171 SET @@session.lc_time_names=0/*!*/;
172 SET @@session.collation_database=DEFAULT/*!*/;
173 insert into t1 values(null, "c")
174 /*!*/;
175 SET TIMESTAMP=1773144/*!*/;
176 COMMIT
177 /*!*/;
178 START TRANSACTION
179 /*!*/;
180 SET INSERT_ID=4/*!*/;
181 SET TIMESTAMP=1773146/*!*/;
182 insert into t1 values(null, "d")
183 /*!*/;
184 SET TIMESTAMP=1773146/*!*/;
185 COMMIT
186 /*!*/;
187 START TRANSACTION
188 /*!*/;
189 SET INSERT_ID=5/*!*/;
190 SET TIMESTAMP=1773146/*!*/;
191 insert into t1 values(null, "e")
192 /*!*/;
193 SET TIMESTAMP=1773146/*!*/;
194 COMMIT
195 /*!*/;
196 DELIMITER ;
197 # End of log file
198 ROLLBACK /* added by mysqlbinlog */;
199 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
200 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
201
202 --- stop-position --
203 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
204 /*!40019 SET @@session.max_delayed_threads=0*/;
205 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
206 DELIMITER /*!*/;
207 ROLLBACK/*!*/;
208 use `test`/*!*/;
209 SET TIMESTAMP=1773142/*!*/;
210 SET @@session.pseudo_thread_id=999999999/*!*/;
211 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/*!*/;
212 SET @@session.sql_mode=0/*!*/;
213 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
214 /*!\C latin1 *//*!*/;
215 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
216 SET @@session.lc_time_names=0/*!*/;
217 SET @@session.collation_database=DEFAULT/*!*/;
218 create table t1 (a int auto_increment not null primary key, b char(3))
219 /*!*/;
220 START TRANSACTION
221 /*!*/;
222 SET INSERT_ID=1/*!*/;
223 SET TIMESTAMP=1773142/*!*/;
224 insert into t1 values(null, "a")
225 /*!*/;
226 SET TIMESTAMP=1773142/*!*/;
227 COMMIT
228 /*!*/;
229 START TRANSACTION
230 /*!*/;
231 SET INSERT_ID=2/*!*/;
232 SET TIMESTAMP=1773142/*!*/;
233 insert into t1 values(null, "b")
234 /*!*/;
235 SET TIMESTAMP=1773142/*!*/;
236 COMMIT
237 /*!*/;
238 DELIMITER ;
239 # End of log file
240 ROLLBACK /* added by mysqlbinlog */;
241 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
242 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
243
244 --- start and stop positions ---
245 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
246 /*!40019 SET @@session.max_delayed_threads=0*/;
247 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
248 DELIMITER /*!*/;
249 ROLLBACK/*!*/;
250 START TRANSACTION
251 /*!*/;
252 SET INSERT_ID=3/*!*/;
253 use `test`/*!*/;
254 SET TIMESTAMP=1773144/*!*/;
255 SET @@session.pseudo_thread_id=999999999/*!*/;
256 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/*!*/;
257 SET @@session.sql_mode=0/*!*/;
258 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
259 /*!\C latin1 *//*!*/;
260 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
261 SET @@session.lc_time_names=0/*!*/;
262 SET @@session.collation_database=DEFAULT/*!*/;
263 insert into t1 values(null, "c")
264 /*!*/;
265 DELIMITER ;
266 # End of log file
267 ROLLBACK /* added by mysqlbinlog */;
268 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
269 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
270
271 --- start-datetime --
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 ROLLBACK/*!*/;
277 START TRANSACTION
278 /*!*/;
279 SET INSERT_ID=3/*!*/;
280 use `test`/*!*/;
281 SET TIMESTAMP=1773144/*!*/;
282 SET @@session.pseudo_thread_id=999999999/*!*/;
283 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/*!*/;
284 SET @@session.sql_mode=0/*!*/;
285 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
286 /*!\C latin1 *//*!*/;
287 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
288 SET @@session.lc_time_names=0/*!*/;
289 SET @@session.collation_database=DEFAULT/*!*/;
290 insert into t1 values(null, "c")
291 /*!*/;
292 SET TIMESTAMP=1773144/*!*/;
293 COMMIT
294 /*!*/;
295 START TRANSACTION
296 /*!*/;
297 SET INSERT_ID=4/*!*/;
298 SET TIMESTAMP=1773146/*!*/;
299 insert into t1 values(null, "d")
300 /*!*/;
301 SET TIMESTAMP=1773146/*!*/;
302 COMMIT
303 /*!*/;
304 START TRANSACTION
305 /*!*/;
306 SET INSERT_ID=5/*!*/;
307 SET TIMESTAMP=1773146/*!*/;
308 insert into t1 values(null, "e")
309 /*!*/;
310 SET TIMESTAMP=1773146/*!*/;
311 COMMIT
312 /*!*/;
313 DELIMITER ;
314 # End of log file
315 ROLLBACK /* added by mysqlbinlog */;
316 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
317 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
318
319 --- stop-datetime --
320 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
321 /*!40019 SET @@session.max_delayed_threads=0*/;
322 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
323 DELIMITER /*!*/;
324 ROLLBACK/*!*/;
325 use `test`/*!*/;
326 SET TIMESTAMP=1773142/*!*/;
327 SET @@session.pseudo_thread_id=999999999/*!*/;
328 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/*!*/;
329 SET @@session.sql_mode=0/*!*/;
330 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
331 /*!\C latin1 *//*!*/;
332 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
333 SET @@session.lc_time_names=0/*!*/;
334 SET @@session.collation_database=DEFAULT/*!*/;
335 create table t1 (a int auto_increment not null primary key, b char(3))
336 /*!*/;
337 START TRANSACTION
338 /*!*/;
339 SET INSERT_ID=1/*!*/;
340 SET TIMESTAMP=1773142/*!*/;
341 insert into t1 values(null, "a")
342 /*!*/;
343 SET TIMESTAMP=1773142/*!*/;
344 COMMIT
345 /*!*/;
346 START TRANSACTION
347 /*!*/;
348 SET INSERT_ID=2/*!*/;
349 SET TIMESTAMP=1773142/*!*/;
350 insert into t1 values(null, "b")
351 /*!*/;
352 SET TIMESTAMP=1773142/*!*/;
353 COMMIT
354 /*!*/;
355 DELIMITER ;
356 # End of log file
357 ROLLBACK /* added by mysqlbinlog */;
358 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
359 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
360
361 --- Local with 2 binlogs on command line --
362 flush logs;
363 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
364 /*!40019 SET @@session.max_delayed_threads=0*/;
365 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
366 DELIMITER /*!*/;
367 ROLLBACK/*!*/;
368 use `test`/*!*/;
369 SET TIMESTAMP=1773142/*!*/;
370 SET @@session.pseudo_thread_id=999999999/*!*/;
371 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/*!*/;
372 SET @@session.sql_mode=0/*!*/;
373 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
374 /*!\C latin1 *//*!*/;
375 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
376 SET @@session.lc_time_names=0/*!*/;
377 SET @@session.collation_database=DEFAULT/*!*/;
378 create table t1 (a int auto_increment not null primary key, b char(3))
379 /*!*/;
380 START TRANSACTION
381 /*!*/;
382 SET INSERT_ID=1/*!*/;
383 SET TIMESTAMP=1773142/*!*/;
384 insert into t1 values(null, "a")
385 /*!*/;
386 SET TIMESTAMP=1773142/*!*/;
387 COMMIT
388 /*!*/;
389 START TRANSACTION
390 /*!*/;
391 SET INSERT_ID=2/*!*/;
392 SET TIMESTAMP=1773142/*!*/;
393 insert into t1 values(null, "b")
394 /*!*/;
395 SET TIMESTAMP=1773142/*!*/;
396 COMMIT
397 /*!*/;
398 START TRANSACTION
399 /*!*/;
400 SET INSERT_ID=3/*!*/;
401 SET TIMESTAMP=1773144/*!*/;
402 insert into t1 values(null, "c")
403 /*!*/;
404 SET TIMESTAMP=1773144/*!*/;
405 COMMIT
406 /*!*/;
407 START TRANSACTION
408 /*!*/;
409 SET INSERT_ID=4/*!*/;
410 SET TIMESTAMP=1773146/*!*/;
411 insert into t1 values(null, "d")
412 /*!*/;
413 SET TIMESTAMP=1773146/*!*/;
414 COMMIT
415 /*!*/;
416 START TRANSACTION
417 /*!*/;
418 SET INSERT_ID=5/*!*/;
419 SET TIMESTAMP=1773146/*!*/;
420 insert into t1 values(null, "e")
421 /*!*/;
422 SET TIMESTAMP=1773146/*!*/;
423 COMMIT
424 /*!*/;
425 DELIMITER ;
426 DELIMITER /*!*/;
427 START TRANSACTION
428 /*!*/;
429 SET INSERT_ID=6/*!*/;
430 use `test`/*!*/;
431 SET TIMESTAMP=1773143/*!*/;
432 SET @@session.pseudo_thread_id=999999999/*!*/;
433 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/*!*/;
434 SET @@session.sql_mode=0/*!*/;
435 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
436 /*!\C latin1 *//*!*/;
437 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
438 SET @@session.lc_time_names=0/*!*/;
439 SET @@session.collation_database=DEFAULT/*!*/;
440 insert into t1 values(null, "f")
441 /*!*/;
442 SET TIMESTAMP=1773143/*!*/;
443 COMMIT
444 /*!*/;
445 DELIMITER ;
446 # End of log file
447 ROLLBACK /* added by mysqlbinlog */;
448 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
449 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
450
451 --- offset --
452 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
453 /*!40019 SET @@session.max_delayed_threads=0*/;
454 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
455 DELIMITER /*!*/;
456 ROLLBACK/*!*/;
457 START TRANSACTION
458 /*!*/;
459 SET INSERT_ID=1/*!*/;
460 use `test`/*!*/;
461 SET TIMESTAMP=1773142/*!*/;
462 SET @@session.pseudo_thread_id=999999999/*!*/;
463 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/*!*/;
464 SET @@session.sql_mode=0/*!*/;
465 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
466 /*!\C latin1 *//*!*/;
467 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
468 SET @@session.lc_time_names=0/*!*/;
469 SET @@session.collation_database=DEFAULT/*!*/;
470 insert into t1 values(null, "a")
471 /*!*/;
472 SET TIMESTAMP=1773142/*!*/;
473 COMMIT
474 /*!*/;
475 START TRANSACTION
476 /*!*/;
477 SET INSERT_ID=2/*!*/;
478 SET TIMESTAMP=1773142/*!*/;
479 insert into t1 values(null, "b")
480 /*!*/;
481 SET TIMESTAMP=1773142/*!*/;
482 COMMIT
483 /*!*/;
484 START TRANSACTION
485 /*!*/;
486 SET INSERT_ID=3/*!*/;
487 SET TIMESTAMP=1773144/*!*/;
488 insert into t1 values(null, "c")
489 /*!*/;
490 SET TIMESTAMP=1773144/*!*/;
491 COMMIT
492 /*!*/;
493 START TRANSACTION
494 /*!*/;
495 SET INSERT_ID=4/*!*/;
496 SET TIMESTAMP=1773146/*!*/;
497 insert into t1 values(null, "d")
498 /*!*/;
499 SET TIMESTAMP=1773146/*!*/;
500 COMMIT
501 /*!*/;
502 START TRANSACTION
503 /*!*/;
504 SET INSERT_ID=5/*!*/;
505 SET TIMESTAMP=1773146/*!*/;
506 insert into t1 values(null, "e")
507 /*!*/;
508 SET TIMESTAMP=1773146/*!*/;
509 COMMIT
510 /*!*/;
511 DELIMITER ;
512 DELIMITER /*!*/;
513 START TRANSACTION
514 /*!*/;
515 SET INSERT_ID=6/*!*/;
516 use `test`/*!*/;
517 SET TIMESTAMP=1773143/*!*/;
518 SET @@session.pseudo_thread_id=999999999/*!*/;
519 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/*!*/;
520 SET @@session.sql_mode=0/*!*/;
521 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
522 /*!\C latin1 *//*!*/;
523 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
524 SET @@session.lc_time_names=0/*!*/;
525 SET @@session.collation_database=DEFAULT/*!*/;
526 insert into t1 values(null, "f")
527 /*!*/;
528 SET TIMESTAMP=1773143/*!*/;
529 COMMIT
530 /*!*/;
531 DELIMITER ;
532 # End of log file
533 ROLLBACK /* added by mysqlbinlog */;
534 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
535 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
536
537 --- start-position --
538 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
539 /*!40019 SET @@session.max_delayed_threads=0*/;
540 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
541 DELIMITER /*!*/;
542 ROLLBACK/*!*/;
543 START TRANSACTION
544 /*!*/;
545 SET INSERT_ID=3/*!*/;
546 use `test`/*!*/;
547 SET TIMESTAMP=1773144/*!*/;
548 SET @@session.pseudo_thread_id=999999999/*!*/;
549 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/*!*/;
550 SET @@session.sql_mode=0/*!*/;
551 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
552 /*!\C latin1 *//*!*/;
553 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
554 SET @@session.lc_time_names=0/*!*/;
555 SET @@session.collation_database=DEFAULT/*!*/;
556 insert into t1 values(null, "c")
557 /*!*/;
558 SET TIMESTAMP=1773144/*!*/;
559 COMMIT
560 /*!*/;
561 START TRANSACTION
562 /*!*/;
563 SET INSERT_ID=4/*!*/;
564 SET TIMESTAMP=1773146/*!*/;
565 insert into t1 values(null, "d")
566 /*!*/;
567 SET TIMESTAMP=1773146/*!*/;
568 COMMIT
569 /*!*/;
570 START TRANSACTION
571 /*!*/;
572 SET INSERT_ID=5/*!*/;
573 SET TIMESTAMP=1773146/*!*/;
574 insert into t1 values(null, "e")
575 /*!*/;
576 SET TIMESTAMP=1773146/*!*/;
577 COMMIT
578 /*!*/;
579 DELIMITER ;
580 DELIMITER /*!*/;
581 START TRANSACTION
582 /*!*/;
583 SET INSERT_ID=6/*!*/;
584 use `test`/*!*/;
585 SET TIMESTAMP=1773143/*!*/;
586 SET @@session.pseudo_thread_id=999999999/*!*/;
587 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/*!*/;
588 SET @@session.sql_mode=0/*!*/;
589 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
590 /*!\C latin1 *//*!*/;
591 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
592 SET @@session.lc_time_names=0/*!*/;
593 SET @@session.collation_database=DEFAULT/*!*/;
594 insert into t1 values(null, "f")
595 /*!*/;
596 SET TIMESTAMP=1773143/*!*/;
597 COMMIT
598 /*!*/;
599 DELIMITER ;
600 # End of log file
601 ROLLBACK /* added by mysqlbinlog */;
602 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
603 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
604
605 --- stop-position --
606 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
607 /*!40019 SET @@session.max_delayed_threads=0*/;
608 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
609 DELIMITER /*!*/;
610 ROLLBACK/*!*/;
611 use `test`/*!*/;
612 SET TIMESTAMP=1773142/*!*/;
613 SET @@session.pseudo_thread_id=999999999/*!*/;
614 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/*!*/;
615 SET @@session.sql_mode=0/*!*/;
616 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
617 /*!\C latin1 *//*!*/;
618 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
619 SET @@session.lc_time_names=0/*!*/;
620 SET @@session.collation_database=DEFAULT/*!*/;
621 create table t1 (a int auto_increment not null primary key, b char(3))
622 /*!*/;
623 START TRANSACTION
624 /*!*/;
625 SET INSERT_ID=1/*!*/;
626 SET TIMESTAMP=1773142/*!*/;
627 insert into t1 values(null, "a")
628 /*!*/;
629 SET TIMESTAMP=1773142/*!*/;
630 COMMIT
631 /*!*/;
632 START TRANSACTION
633 /*!*/;
634 SET INSERT_ID=2/*!*/;
635 SET TIMESTAMP=1773142/*!*/;
636 insert into t1 values(null, "b")
637 /*!*/;
638 SET TIMESTAMP=1773142/*!*/;
639 COMMIT
640 /*!*/;
641 START TRANSACTION
642 /*!*/;
643 SET INSERT_ID=3/*!*/;
644 SET TIMESTAMP=1773144/*!*/;
645 insert into t1 values(null, "c")
646 /*!*/;
647 SET TIMESTAMP=1773144/*!*/;
648 COMMIT
649 /*!*/;
650 START TRANSACTION
651 /*!*/;
652 SET INSERT_ID=4/*!*/;
653 SET TIMESTAMP=1773146/*!*/;
654 insert into t1 values(null, "d")
655 /*!*/;
656 SET TIMESTAMP=1773146/*!*/;
657 COMMIT
658 /*!*/;
659 START TRANSACTION
660 /*!*/;
661 SET INSERT_ID=5/*!*/;
662 SET TIMESTAMP=1773146/*!*/;
663 insert into t1 values(null, "e")
664 /*!*/;
665 SET TIMESTAMP=1773146/*!*/;
666 COMMIT
667 /*!*/;
668 DELIMITER ;
669 DELIMITER /*!*/;
670 START TRANSACTION
671 /*!*/;
672 DELIMITER ;
673 # End of log file
674 ROLLBACK /* added by mysqlbinlog */;
675 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
676 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
677
678 --- start-datetime --
679 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
680 /*!40019 SET @@session.max_delayed_threads=0*/;
681 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
682 DELIMITER /*!*/;
683 ROLLBACK/*!*/;
684 START TRANSACTION
685 /*!*/;
686 SET INSERT_ID=3/*!*/;
687 use `test`/*!*/;
688 SET TIMESTAMP=1773144/*!*/;
689 SET @@session.pseudo_thread_id=999999999/*!*/;
690 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/*!*/;
691 SET @@session.sql_mode=0/*!*/;
692 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
693 /*!\C latin1 *//*!*/;
694 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
695 SET @@session.lc_time_names=0/*!*/;
696 SET @@session.collation_database=DEFAULT/*!*/;
697 insert into t1 values(null, "c")
698 /*!*/;
699 SET TIMESTAMP=1773144/*!*/;
700 COMMIT
701 /*!*/;
702 START TRANSACTION
703 /*!*/;
704 SET INSERT_ID=4/*!*/;
705 SET TIMESTAMP=1773146/*!*/;
706 insert into t1 values(null, "d")
707 /*!*/;
708 SET TIMESTAMP=1773146/*!*/;
709 COMMIT
710 /*!*/;
711 START TRANSACTION
712 /*!*/;
713 SET INSERT_ID=5/*!*/;
714 SET TIMESTAMP=1773146/*!*/;
715 insert into t1 values(null, "e")
716 /*!*/;
717 SET TIMESTAMP=1773146/*!*/;
718 COMMIT
719 /*!*/;
720 DELIMITER ;
721 DELIMITER /*!*/;
722 START TRANSACTION
723 /*!*/;
724 SET INSERT_ID=6/*!*/;
725 use `test`/*!*/;
726 SET TIMESTAMP=1773143/*!*/;
727 SET @@session.pseudo_thread_id=999999999/*!*/;
728 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/*!*/;
729 SET @@session.sql_mode=0/*!*/;
730 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
731 /*!\C latin1 *//*!*/;
732 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
733 SET @@session.lc_time_names=0/*!*/;
734 SET @@session.collation_database=DEFAULT/*!*/;
735 insert into t1 values(null, "f")
736 /*!*/;
737 SET TIMESTAMP=1773143/*!*/;
738 COMMIT
739 /*!*/;
740 DELIMITER ;
741 # End of log file
742 ROLLBACK /* added by mysqlbinlog */;
743 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
744 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
745
746 --- stop-datetime --
747 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
748 /*!40019 SET @@session.max_delayed_threads=0*/;
749 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
750 DELIMITER /*!*/;
751 ROLLBACK/*!*/;
752 use `test`/*!*/;
753 SET TIMESTAMP=1773142/*!*/;
754 SET @@session.pseudo_thread_id=999999999/*!*/;
755 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/*!*/;
756 SET @@session.sql_mode=0/*!*/;
757 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
758 /*!\C latin1 *//*!*/;
759 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
760 SET @@session.lc_time_names=0/*!*/;
761 SET @@session.collation_database=DEFAULT/*!*/;
762 create table t1 (a int auto_increment not null primary key, b char(3))
763 /*!*/;
764 START TRANSACTION
765 /*!*/;
766 SET INSERT_ID=1/*!*/;
767 SET TIMESTAMP=1773142/*!*/;
768 insert into t1 values(null, "a")
769 /*!*/;
770 SET TIMESTAMP=1773142/*!*/;
771 COMMIT
772 /*!*/;
773 START TRANSACTION
774 /*!*/;
775 SET INSERT_ID=2/*!*/;
776 SET TIMESTAMP=1773142/*!*/;
777 insert into t1 values(null, "b")
778 /*!*/;
779 SET TIMESTAMP=1773142/*!*/;
780 COMMIT
781 /*!*/;
782 DELIMITER ;
783 # End of log file
784 ROLLBACK /* added by mysqlbinlog */;
785 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
786 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
787
788 --- Remote --
789 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
790 /*!40019 SET @@session.max_delayed_threads=0*/;
791 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
792 DELIMITER /*!*/;
793 ROLLBACK/*!*/;
794 use `test`/*!*/;
795 SET TIMESTAMP=1773142/*!*/;
796 SET @@session.pseudo_thread_id=999999999/*!*/;
797 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/*!*/;
798 SET @@session.sql_mode=0/*!*/;
799 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
800 /*!\C latin1 *//*!*/;
801 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
802 SET @@session.lc_time_names=0/*!*/;
803 SET @@session.collation_database=DEFAULT/*!*/;
804 create table t1 (a int auto_increment not null primary key, b char(3))
805 /*!*/;
806 START TRANSACTION
807 /*!*/;
808 SET INSERT_ID=1/*!*/;
809 SET TIMESTAMP=1773142/*!*/;
810 insert into t1 values(null, "a")
811 /*!*/;
812 SET TIMESTAMP=1773142/*!*/;
813 COMMIT
814 /*!*/;
815 START TRANSACTION
816 /*!*/;
817 SET INSERT_ID=2/*!*/;
818 SET TIMESTAMP=1773142/*!*/;
819 insert into t1 values(null, "b")
820 /*!*/;
821 SET TIMESTAMP=1773142/*!*/;
822 COMMIT
823 /*!*/;
824 START TRANSACTION
825 /*!*/;
826 SET INSERT_ID=3/*!*/;
827 SET TIMESTAMP=1773144/*!*/;
828 insert into t1 values(null, "c")
829 /*!*/;
830 SET TIMESTAMP=1773144/*!*/;
831 COMMIT
832 /*!*/;
833 START TRANSACTION
834 /*!*/;
835 SET INSERT_ID=4/*!*/;
836 SET TIMESTAMP=1773146/*!*/;
837 insert into t1 values(null, "d")
838 /*!*/;
839 SET TIMESTAMP=1773146/*!*/;
840 COMMIT
841 /*!*/;
842 START TRANSACTION
843 /*!*/;
844 SET INSERT_ID=5/*!*/;
845 SET TIMESTAMP=1773146/*!*/;
846 insert into t1 values(null, "e")
847 /*!*/;
848 SET TIMESTAMP=1773146/*!*/;
849 COMMIT
850 /*!*/;
851 DELIMITER ;
852 # End of log file
853 ROLLBACK /* added by mysqlbinlog */;
854 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
855 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
856
857 --- offset --
858 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
859 /*!40019 SET @@session.max_delayed_threads=0*/;
860 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
861 DELIMITER /*!*/;
862 ROLLBACK/*!*/;
863 START TRANSACTION
864 /*!*/;
865 SET INSERT_ID=1/*!*/;
866 use `test`/*!*/;
867 SET TIMESTAMP=1773142/*!*/;
868 SET @@session.pseudo_thread_id=999999999/*!*/;
869 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/*!*/;
870 SET @@session.sql_mode=0/*!*/;
871 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
872 /*!\C latin1 *//*!*/;
873 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
874 SET @@session.lc_time_names=0/*!*/;
875 SET @@session.collation_database=DEFAULT/*!*/;
876 insert into t1 values(null, "a")
877 /*!*/;
878 SET TIMESTAMP=1773142/*!*/;
879 COMMIT
880 /*!*/;
881 START TRANSACTION
882 /*!*/;
883 SET INSERT_ID=2/*!*/;
884 SET TIMESTAMP=1773142/*!*/;
885 insert into t1 values(null, "b")
886 /*!*/;
887 SET TIMESTAMP=1773142/*!*/;
888 COMMIT
889 /*!*/;
890 START TRANSACTION
891 /*!*/;
892 SET INSERT_ID=3/*!*/;
893 SET TIMESTAMP=1773144/*!*/;
894 insert into t1 values(null, "c")
895 /*!*/;
896 SET TIMESTAMP=1773144/*!*/;
897 COMMIT
898 /*!*/;
899 START TRANSACTION
900 /*!*/;
901 SET INSERT_ID=4/*!*/;
902 SET TIMESTAMP=1773146/*!*/;
903 insert into t1 values(null, "d")
904 /*!*/;
905 SET TIMESTAMP=1773146/*!*/;
906 COMMIT
907 /*!*/;
908 START TRANSACTION
909 /*!*/;
910 SET INSERT_ID=5/*!*/;
911 SET TIMESTAMP=1773146/*!*/;
912 insert into t1 values(null, "e")
913 /*!*/;
914 SET TIMESTAMP=1773146/*!*/;
915 COMMIT
916 /*!*/;
917 DELIMITER ;
918 # End of log file
919 ROLLBACK /* added by mysqlbinlog */;
920 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
921 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
922
923 --- start-position --
924 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
925 /*!40019 SET @@session.max_delayed_threads=0*/;
926 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
927 DELIMITER /*!*/;
928 START TRANSACTION
929 /*!*/;
930 SET INSERT_ID=3/*!*/;
931 use `test`/*!*/;
932 SET TIMESTAMP=1773144/*!*/;
933 SET @@session.pseudo_thread_id=999999999/*!*/;
934 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/*!*/;
935 SET @@session.sql_mode=0/*!*/;
936 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
937 /*!\C latin1 *//*!*/;
938 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
939 SET @@session.lc_time_names=0/*!*/;
940 SET @@session.collation_database=DEFAULT/*!*/;
941 insert into t1 values(null, "c")
942 /*!*/;
943 SET TIMESTAMP=1773144/*!*/;
944 COMMIT
945 /*!*/;
946 START TRANSACTION
947 /*!*/;
948 SET INSERT_ID=4/*!*/;
949 SET TIMESTAMP=1773146/*!*/;
950 insert into t1 values(null, "d")
951 /*!*/;
952 SET TIMESTAMP=1773146/*!*/;
953 COMMIT
954 /*!*/;
955 START TRANSACTION
956 /*!*/;
957 SET INSERT_ID=5/*!*/;
958 SET TIMESTAMP=1773146/*!*/;
959 insert into t1 values(null, "e")
960 /*!*/;
961 SET TIMESTAMP=1773146/*!*/;
962 COMMIT
963 /*!*/;
964 DELIMITER ;
965 # End of log file
966 ROLLBACK /* added by mysqlbinlog */;
967 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
968 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
969
970 --- stop-position --
971 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
972 /*!40019 SET @@session.max_delayed_threads=0*/;
973 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
974 DELIMITER /*!*/;
975 ROLLBACK/*!*/;
976 use `test`/*!*/;
977 SET TIMESTAMP=1773142/*!*/;
978 SET @@session.pseudo_thread_id=999999999/*!*/;
979 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/*!*/;
980 SET @@session.sql_mode=0/*!*/;
981 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
982 /*!\C latin1 *//*!*/;
983 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
984 SET @@session.lc_time_names=0/*!*/;
985 SET @@session.collation_database=DEFAULT/*!*/;
986 create table t1 (a int auto_increment not null primary key, b char(3))
987 /*!*/;
988 START TRANSACTION
989 /*!*/;
990 SET INSERT_ID=1/*!*/;
991 SET TIMESTAMP=1773142/*!*/;
992 insert into t1 values(null, "a")
993 /*!*/;
994 SET TIMESTAMP=1773142/*!*/;
995 COMMIT
996 /*!*/;
997 START TRANSACTION
998 /*!*/;
999 SET INSERT_ID=2/*!*/;
1000 SET TIMESTAMP=1773142/*!*/;
1001 insert into t1 values(null, "b")
1002 /*!*/;
1003 SET TIMESTAMP=1773142/*!*/;
1004 COMMIT
1005 /*!*/;
1006 DELIMITER ;
1007 # End of log file
1008 ROLLBACK /* added by mysqlbinlog */;
1009 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
1010 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
1011
1012 --- start and stop positions ---
1013 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
1014 /*!40019 SET @@session.max_delayed_threads=0*/;
1015 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
1016 DELIMITER /*!*/;
1017 START TRANSACTION
1018 /*!*/;
1019 SET INSERT_ID=3/*!*/;
1020 use `test`/*!*/;
1021 SET TIMESTAMP=1773144/*!*/;
1022 SET @@session.pseudo_thread_id=999999999/*!*/;
1023 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/*!*/;
1024 SET @@session.sql_mode=0/*!*/;
1025 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
1026 /*!\C latin1 *//*!*/;
1027 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
1028 SET @@session.lc_time_names=0/*!*/;
1029 SET @@session.collation_database=DEFAULT/*!*/;
1030 insert into t1 values(null, "c")
1031 /*!*/;
1032 DELIMITER ;
1033 # End of log file
1034 ROLLBACK /* added by mysqlbinlog */;
1035 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
1036 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
1037
1038 --- start-datetime --
1039 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
1040 /*!40019 SET @@session.max_delayed_threads=0*/;
1041 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
1042 DELIMITER /*!*/;
1043 ROLLBACK/*!*/;
1044 START TRANSACTION
1045 /*!*/;
1046 SET INSERT_ID=3/*!*/;
1047 use `test`/*!*/;
1048 SET TIMESTAMP=1773144/*!*/;
1049 SET @@session.pseudo_thread_id=999999999/*!*/;
1050 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/*!*/;
1051 SET @@session.sql_mode=0/*!*/;
1052 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
1053 /*!\C latin1 *//*!*/;
1054 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
1055 SET @@session.lc_time_names=0/*!*/;
1056 SET @@session.collation_database=DEFAULT/*!*/;
1057 insert into t1 values(null, "c")
1058 /*!*/;
1059 SET TIMESTAMP=1773144/*!*/;
1060 COMMIT
1061 /*!*/;
1062 START TRANSACTION
1063 /*!*/;
1064 SET INSERT_ID=4/*!*/;
1065 SET TIMESTAMP=1773146/*!*/;
1066 insert into t1 values(null, "d")
1067 /*!*/;
1068 SET TIMESTAMP=1773146/*!*/;
1069 COMMIT
1070 /*!*/;
1071 START TRANSACTION
1072 /*!*/;
1073 SET INSERT_ID=5/*!*/;
1074 SET TIMESTAMP=1773146/*!*/;
1075 insert into t1 values(null, "e")
1076 /*!*/;
1077 SET TIMESTAMP=1773146/*!*/;
1078 COMMIT
1079 /*!*/;
1080 DELIMITER ;
1081 # End of log file
1082 ROLLBACK /* added by mysqlbinlog */;
1083 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
1084 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
1085
1086 --- stop-datetime --
1087 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
1088 /*!40019 SET @@session.max_delayed_threads=0*/;
1089 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
1090 DELIMITER /*!*/;
1091 ROLLBACK/*!*/;
1092 use `test`/*!*/;
1093 SET TIMESTAMP=1773142/*!*/;
1094 SET @@session.pseudo_thread_id=999999999/*!*/;
1095 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/*!*/;
1096 SET @@session.sql_mode=0/*!*/;
1097 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
1098 /*!\C latin1 *//*!*/;
1099 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
1100 SET @@session.lc_time_names=0/*!*/;
1101 SET @@session.collation_database=DEFAULT/*!*/;
1102 create table t1 (a int auto_increment not null primary key, b char(3))
1103 /*!*/;
1104 START TRANSACTION
1105 /*!*/;
1106 SET INSERT_ID=1/*!*/;
1107 SET TIMESTAMP=1773142/*!*/;
1108 insert into t1 values(null, "a")
1109 /*!*/;
1110 SET TIMESTAMP=1773142/*!*/;
1111 COMMIT
1112 /*!*/;
1113 START TRANSACTION
1114 /*!*/;
1115 SET INSERT_ID=2/*!*/;
1116 SET TIMESTAMP=1773142/*!*/;
1117 insert into t1 values(null, "b")
1118 /*!*/;
1119 SET TIMESTAMP=1773142/*!*/;
1120 COMMIT
1121 /*!*/;
1122 DELIMITER ;
1123 # End of log file
1124 ROLLBACK /* added by mysqlbinlog */;
1125 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
1126 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
1127
1128 --- Remote with 2 binlogs on command line --
1129 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
1130 /*!40019 SET @@session.max_delayed_threads=0*/;
1131 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
1132 DELIMITER /*!*/;
1133 ROLLBACK/*!*/;
1134 use `test`/*!*/;
1135 SET TIMESTAMP=1773142/*!*/;
1136 SET @@session.pseudo_thread_id=999999999/*!*/;
1137 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/*!*/;
1138 SET @@session.sql_mode=0/*!*/;
1139 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
1140 /*!\C latin1 *//*!*/;
1141 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
1142 SET @@session.lc_time_names=0/*!*/;
1143 SET @@session.collation_database=DEFAULT/*!*/;
1144 create table t1 (a int auto_increment not null primary key, b char(3))
1145 /*!*/;
1146 START TRANSACTION
1147 /*!*/;
1148 SET INSERT_ID=1/*!*/;
1149 SET TIMESTAMP=1773142/*!*/;
1150 insert into t1 values(null, "a")
1151 /*!*/;
1152 SET TIMESTAMP=1773142/*!*/;
1153 COMMIT
1154 /*!*/;
1155 START TRANSACTION
1156 /*!*/;
1157 SET INSERT_ID=2/*!*/;
1158 SET TIMESTAMP=1773142/*!*/;
1159 insert into t1 values(null, "b")
1160 /*!*/;
1161 SET TIMESTAMP=1773142/*!*/;
1162 COMMIT
1163 /*!*/;
1164 START TRANSACTION
1165 /*!*/;
1166 SET INSERT_ID=3/*!*/;
1167 SET TIMESTAMP=1773144/*!*/;
1168 insert into t1 values(null, "c")
1169 /*!*/;
1170 SET TIMESTAMP=1773144/*!*/;
1171 COMMIT
1172 /*!*/;
1173 START TRANSACTION
1174 /*!*/;
1175 SET INSERT_ID=4/*!*/;
1176 SET TIMESTAMP=1773146/*!*/;
1177 insert into t1 values(null, "d")
1178 /*!*/;
1179 SET TIMESTAMP=1773146/*!*/;
1180 COMMIT
1181 /*!*/;
1182 START TRANSACTION
1183 /*!*/;
1184 SET INSERT_ID=5/*!*/;
1185 SET TIMESTAMP=1773146/*!*/;
1186 insert into t1 values(null, "e")
1187 /*!*/;
1188 SET TIMESTAMP=1773146/*!*/;
1189 COMMIT
1190 /*!*/;
1191 DELIMITER ;
1192 DELIMITER /*!*/;
1193 START TRANSACTION
1194 /*!*/;
1195 SET INSERT_ID=6/*!*/;
1196 use `test`/*!*/;
1197 SET TIMESTAMP=1773143/*!*/;
1198 SET @@session.pseudo_thread_id=999999999/*!*/;
1199 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/*!*/;
1200 SET @@session.sql_mode=0/*!*/;
1201 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
1202 /*!\C latin1 *//*!*/;
1203 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
1204 SET @@session.lc_time_names=0/*!*/;
1205 SET @@session.collation_database=DEFAULT/*!*/;
1206 insert into t1 values(null, "f")
1207 /*!*/;
1208 SET TIMESTAMP=1773143/*!*/;
1209 COMMIT
1210 /*!*/;
1211 DELIMITER ;
1212 # End of log file
1213 ROLLBACK /* added by mysqlbinlog */;
1214 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
1215 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
1216
1217 --- offset --
1218 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
1219 /*!40019 SET @@session.max_delayed_threads=0*/;
1220 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
1221 DELIMITER /*!*/;
1222 ROLLBACK/*!*/;
1223 START TRANSACTION
1224 /*!*/;
1225 SET INSERT_ID=1/*!*/;
1226 use `test`/*!*/;
1227 SET TIMESTAMP=1773142/*!*/;
1228 SET @@session.pseudo_thread_id=999999999/*!*/;
1229 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/*!*/;
1230 SET @@session.sql_mode=0/*!*/;
1231 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
1232 /*!\C latin1 *//*!*/;
1233 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
1234 SET @@session.lc_time_names=0/*!*/;
1235 SET @@session.collation_database=DEFAULT/*!*/;
1236 insert into t1 values(null, "a")
1237 /*!*/;
1238 SET TIMESTAMP=1773142/*!*/;
1239 COMMIT
1240 /*!*/;
1241 START TRANSACTION
1242 /*!*/;
1243 SET INSERT_ID=2/*!*/;
1244 SET TIMESTAMP=1773142/*!*/;
1245 insert into t1 values(null, "b")
1246 /*!*/;
1247 SET TIMESTAMP=1773142/*!*/;
1248 COMMIT
1249 /*!*/;
1250 START TRANSACTION
1251 /*!*/;
1252 SET INSERT_ID=3/*!*/;
1253 SET TIMESTAMP=1773144/*!*/;
1254 insert into t1 values(null, "c")
1255 /*!*/;
1256 SET TIMESTAMP=1773144/*!*/;
1257 COMMIT
1258 /*!*/;
1259 START TRANSACTION
1260 /*!*/;
1261 SET INSERT_ID=4/*!*/;
1262 SET TIMESTAMP=1773146/*!*/;
1263 insert into t1 values(null, "d")
1264 /*!*/;
1265 SET TIMESTAMP=1773146/*!*/;
1266 COMMIT
1267 /*!*/;
1268 START TRANSACTION
1269 /*!*/;
1270 SET INSERT_ID=5/*!*/;
1271 SET TIMESTAMP=1773146/*!*/;
1272 insert into t1 values(null, "e")
1273 /*!*/;
1274 SET TIMESTAMP=1773146/*!*/;
1275 COMMIT
1276 /*!*/;
1277 DELIMITER ;
1278 DELIMITER /*!*/;
1279 START TRANSACTION
1280 /*!*/;
1281 SET INSERT_ID=6/*!*/;
1282 use `test`/*!*/;
1283 SET TIMESTAMP=1773143/*!*/;
1284 SET @@session.pseudo_thread_id=999999999/*!*/;
1285 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/*!*/;
1286 SET @@session.sql_mode=0/*!*/;
1287 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
1288 /*!\C latin1 *//*!*/;
1289 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
1290 SET @@session.lc_time_names=0/*!*/;
1291 SET @@session.collation_database=DEFAULT/*!*/;
1292 insert into t1 values(null, "f")
1293 /*!*/;
1294 SET TIMESTAMP=1773143/*!*/;
1295 COMMIT
1296 /*!*/;
1297 DELIMITER ;
1298 # End of log file
1299 ROLLBACK /* added by mysqlbinlog */;
1300 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
1301 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
1302
1303 --- start-position --
1304 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
1305 /*!40019 SET @@session.max_delayed_threads=0*/;
1306 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
1307 DELIMITER /*!*/;
1308 START TRANSACTION
1309 /*!*/;
1310 SET INSERT_ID=3/*!*/;
1311 use `test`/*!*/;
1312 SET TIMESTAMP=1773144/*!*/;
1313 SET @@session.pseudo_thread_id=999999999/*!*/;
1314 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/*!*/;
1315 SET @@session.sql_mode=0/*!*/;
1316 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
1317 /*!\C latin1 *//*!*/;
1318 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
1319 SET @@session.lc_time_names=0/*!*/;
1320 SET @@session.collation_database=DEFAULT/*!*/;
1321 insert into t1 values(null, "c")
1322 /*!*/;
1323 SET TIMESTAMP=1773144/*!*/;
1324 COMMIT
1325 /*!*/;
1326 START TRANSACTION
1327 /*!*/;
1328 SET INSERT_ID=4/*!*/;
1329 SET TIMESTAMP=1773146/*!*/;
1330 insert into t1 values(null, "d")
1331 /*!*/;
1332 SET TIMESTAMP=1773146/*!*/;
1333 COMMIT
1334 /*!*/;
1335 START TRANSACTION
1336 /*!*/;
1337 SET INSERT_ID=5/*!*/;
1338 SET TIMESTAMP=1773146/*!*/;
1339 insert into t1 values(null, "e")
1340 /*!*/;
1341 SET TIMESTAMP=1773146/*!*/;
1342 COMMIT
1343 /*!*/;
1344 DELIMITER ;
1345 DELIMITER /*!*/;
1346 START TRANSACTION
1347 /*!*/;
1348 SET INSERT_ID=6/*!*/;
1349 use `test`/*!*/;
1350 SET TIMESTAMP=1773143/*!*/;
1351 SET @@session.pseudo_thread_id=999999999/*!*/;
1352 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/*!*/;
1353 SET @@session.sql_mode=0/*!*/;
1354 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
1355 /*!\C latin1 *//*!*/;
1356 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
1357 SET @@session.lc_time_names=0/*!*/;
1358 SET @@session.collation_database=DEFAULT/*!*/;
1359 insert into t1 values(null, "f")
1360 /*!*/;
1361 SET TIMESTAMP=1773143/*!*/;
1362 COMMIT
1363 /*!*/;
1364 DELIMITER ;
1365 # End of log file
1366 ROLLBACK /* added by mysqlbinlog */;
1367 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
1368 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
1369
1370 --- stop-position --
1371 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
1372 /*!40019 SET @@session.max_delayed_threads=0*/;
1373 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
1374 DELIMITER /*!*/;
1375 ROLLBACK/*!*/;
1376 use `test`/*!*/;
1377 SET TIMESTAMP=1773142/*!*/;
1378 SET @@session.pseudo_thread_id=999999999/*!*/;
1379 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/*!*/;
1380 SET @@session.sql_mode=0/*!*/;
1381 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
1382 /*!\C latin1 *//*!*/;
1383 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
1384 SET @@session.lc_time_names=0/*!*/;
1385 SET @@session.collation_database=DEFAULT/*!*/;
1386 create table t1 (a int auto_increment not null primary key, b char(3))
1387 /*!*/;
1388 START TRANSACTION
1389 /*!*/;
1390 SET INSERT_ID=1/*!*/;
1391 SET TIMESTAMP=1773142/*!*/;
1392 insert into t1 values(null, "a")
1393 /*!*/;
1394 SET TIMESTAMP=1773142/*!*/;
1395 COMMIT
1396 /*!*/;
1397 START TRANSACTION
1398 /*!*/;
1399 SET INSERT_ID=2/*!*/;
1400 SET TIMESTAMP=1773142/*!*/;
1401 insert into t1 values(null, "b")
1402 /*!*/;
1403 SET TIMESTAMP=1773142/*!*/;
1404 COMMIT
1405 /*!*/;
1406 START TRANSACTION
1407 /*!*/;
1408 SET INSERT_ID=3/*!*/;
1409 SET TIMESTAMP=1773144/*!*/;
1410 insert into t1 values(null, "c")
1411 /*!*/;
1412 SET TIMESTAMP=1773144/*!*/;
1413 COMMIT
1414 /*!*/;
1415 START TRANSACTION
1416 /*!*/;
1417 SET INSERT_ID=4/*!*/;
1418 SET TIMESTAMP=1773146/*!*/;
1419 insert into t1 values(null, "d")
1420 /*!*/;
1421 SET TIMESTAMP=1773146/*!*/;
1422 COMMIT
1423 /*!*/;
1424 START TRANSACTION
1425 /*!*/;
1426 SET INSERT_ID=5/*!*/;
1427 SET TIMESTAMP=1773146/*!*/;
1428 insert into t1 values(null, "e")
1429 /*!*/;
1430 SET TIMESTAMP=1773146/*!*/;
1431 COMMIT
1432 /*!*/;
1433 DELIMITER ;
1434 DELIMITER /*!*/;
1435 DELIMITER ;
1436 # End of log file
1437 ROLLBACK /* added by mysqlbinlog */;
1438 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
1439 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
1440
1441 --- start-datetime --
1442 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
1443 /*!40019 SET @@session.max_delayed_threads=0*/;
1444 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
1445 DELIMITER /*!*/;
1446 ROLLBACK/*!*/;
1447 START TRANSACTION
1448 /*!*/;
1449 SET INSERT_ID=3/*!*/;
1450 use `test`/*!*/;
1451 SET TIMESTAMP=1773144/*!*/;
1452 SET @@session.pseudo_thread_id=999999999/*!*/;
1453 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/*!*/;
1454 SET @@session.sql_mode=0/*!*/;
1455 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
1456 /*!\C latin1 *//*!*/;
1457 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
1458 SET @@session.lc_time_names=0/*!*/;
1459 SET @@session.collation_database=DEFAULT/*!*/;
1460 insert into t1 values(null, "c")
1461 /*!*/;
1462 SET TIMESTAMP=1773144/*!*/;
1463 COMMIT
1464 /*!*/;
1465 START TRANSACTION
1466 /*!*/;
1467 SET INSERT_ID=4/*!*/;
1468 SET TIMESTAMP=1773146/*!*/;
1469 insert into t1 values(null, "d")
1470 /*!*/;
1471 SET TIMESTAMP=1773146/*!*/;
1472 COMMIT
1473 /*!*/;
1474 START TRANSACTION
1475 /*!*/;
1476 SET INSERT_ID=5/*!*/;
1477 SET TIMESTAMP=1773146/*!*/;
1478 insert into t1 values(null, "e")
1479 /*!*/;
1480 SET TIMESTAMP=1773146/*!*/;
1481 COMMIT
1482 /*!*/;
1483 DELIMITER ;
1484 DELIMITER /*!*/;
1485 START TRANSACTION
1486 /*!*/;
1487 SET INSERT_ID=6/*!*/;
1488 use `test`/*!*/;
1489 SET TIMESTAMP=1773143/*!*/;
1490 SET @@session.pseudo_thread_id=999999999/*!*/;
1491 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/*!*/;
1492 SET @@session.sql_mode=0/*!*/;
1493 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
1494 /*!\C latin1 *//*!*/;
1495 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
1496 SET @@session.lc_time_names=0/*!*/;
1497 SET @@session.collation_database=DEFAULT/*!*/;
1498 insert into t1 values(null, "f")
1499 /*!*/;
1500 SET TIMESTAMP=1773143/*!*/;
1501 COMMIT
1502 /*!*/;
1503 DELIMITER ;
1504 # End of log file
1505 ROLLBACK /* added by mysqlbinlog */;
1506 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
1507 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
1508
1509 --- stop-datetime --
1510 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
1511 /*!40019 SET @@session.max_delayed_threads=0*/;
1512 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
1513 DELIMITER /*!*/;
1514 ROLLBACK/*!*/;
1515 use `test`/*!*/;
1516 SET TIMESTAMP=1773142/*!*/;
1517 SET @@session.pseudo_thread_id=999999999/*!*/;
1518 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/*!*/;
1519 SET @@session.sql_mode=0/*!*/;
1520 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
1521 /*!\C latin1 *//*!*/;
1522 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
1523 SET @@session.lc_time_names=0/*!*/;
1524 SET @@session.collation_database=DEFAULT/*!*/;
1525 create table t1 (a int auto_increment not null primary key, b char(3))
1526 /*!*/;
1527 START TRANSACTION
1528 /*!*/;
1529 SET INSERT_ID=1/*!*/;
1530 SET TIMESTAMP=1773142/*!*/;
1531 insert into t1 values(null, "a")
1532 /*!*/;
1533 SET TIMESTAMP=1773142/*!*/;
1534 COMMIT
1535 /*!*/;
1536 START TRANSACTION
1537 /*!*/;
1538 SET INSERT_ID=2/*!*/;
1539 SET TIMESTAMP=1773142/*!*/;
1540 insert into t1 values(null, "b")
1541 /*!*/;
1542 SET TIMESTAMP=1773142/*!*/;
1543 COMMIT
1544 /*!*/;
1545 DELIMITER ;
1546 # End of log file
1547 ROLLBACK /* added by mysqlbinlog */;
1548 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
1549 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
1550
1551 --- to-last-log --
1552 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
1553 /*!40019 SET @@session.max_delayed_threads=0*/;
1554 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
1555 DELIMITER /*!*/;
1556 ROLLBACK/*!*/;
1557 use `test`/*!*/;
1558 SET TIMESTAMP=1773142/*!*/;
1559 SET @@session.pseudo_thread_id=999999999/*!*/;
1560 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/*!*/;
1561 SET @@session.sql_mode=0/*!*/;
1562 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
1563 /*!\C latin1 *//*!*/;
1564 SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/;
1565 SET @@session.lc_time_names=0/*!*/;
1566 SET @@session.collation_database=DEFAULT/*!*/;
1567 create table t1 (a int auto_increment not null primary key, b char(3))
1568 /*!*/;
1569 START TRANSACTION
1570 /*!*/;
1571 SET INSERT_ID=1/*!*/;
1572 SET TIMESTAMP=1773142/*!*/;
1573 insert into t1 values(null, "a")
1574 /*!*/;
1575 SET TIMESTAMP=1773142/*!*/;
1576 COMMIT
1577 /*!*/;
1578 START TRANSACTION
1579 /*!*/;
1580 SET INSERT_ID=2/*!*/;
1581 SET TIMESTAMP=1773142/*!*/;
1582 insert into t1 values(null, "b")
1583 /*!*/;
1584 SET TIMESTAMP=1773142/*!*/;
1585 COMMIT
1586 /*!*/;
1587 START TRANSACTION
1588 /*!*/;
1589 SET INSERT_ID=3/*!*/;
1590 SET TIMESTAMP=1773144/*!*/;
1591 insert into t1 values(null, "c")
1592 /*!*/;
1593 SET TIMESTAMP=1773144/*!*/;
1594 COMMIT
1595 /*!*/;
1596 START TRANSACTION
1597 /*!*/;
1598 SET INSERT_ID=4/*!*/;
1599 SET TIMESTAMP=1773146/*!*/;
1600 insert into t1 values(null, "d")
1601 /*!*/;
1602 SET TIMESTAMP=1773146/*!*/;
1603 COMMIT
1604 /*!*/;
1605 START TRANSACTION
1606 /*!*/;
1607 SET INSERT_ID=5/*!*/;
1608 SET TIMESTAMP=1773146/*!*/;
1609 insert into t1 values(null, "e")
1610 /*!*/;
1611 SET TIMESTAMP=1773146/*!*/;
1612 COMMIT
1613 /*!*/;
1614 START TRANSACTION
1615 /*!*/;
1616 SET INSERT_ID=6/*!*/;
1617 SET TIMESTAMP=1773143/*!*/;
1618 insert into t1 values(null, "f")
1619 /*!*/;
1620 SET TIMESTAMP=1773143/*!*/;
1621 COMMIT
1622 /*!*/;
1623 DELIMITER ;
1624 # End of log file
1625 ROLLBACK /* added by mysqlbinlog */;
1626 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
1627 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
1628
1629 --- end of test --
1630 drop table t1;
1631 set global binlog_checksum=default;