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