diff options
Diffstat (limited to 'mysql-test/suite/binlog/r/binlog_mysqlbinlog2.result')
| -rw-r--r-- | mysql-test/suite/binlog/r/binlog_mysqlbinlog2.result | 1631 |
1 files changed, 1631 insertions, 0 deletions
diff --git a/mysql-test/suite/binlog/r/binlog_mysqlbinlog2.result b/mysql-test/suite/binlog/r/binlog_mysqlbinlog2.result new file mode 100644 index 00000000..1d6e9424 --- /dev/null +++ b/mysql-test/suite/binlog/r/binlog_mysqlbinlog2.result @@ -0,0 +1,1631 @@ +set sql_mode=""; +set global binlog_checksum=NONE; +drop table if exists t1; +set @a=UNIX_TIMESTAMP("1970-01-21 15:32:22"); +set timestamp=@a; +reset master; +create table t1 (a int auto_increment not null primary key, b char(3)); +insert into t1 values(null, "a"); +insert into t1 values(null, "b"); +set timestamp=@a+2; +insert into t1 values(null, "c"); +set timestamp=@a+4; +insert into t1 values(null, "d"); +insert into t1 values(null, "e"); +flush logs; +set timestamp=@a+1; +insert into t1 values(null, "f"); + +--- Local -- +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; +/*!40019 SET @@session.max_insert_delayed_threads=0*/; +/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; +DELIMITER /*!*/; +ROLLBACK/*!*/; +use `test`/*!*/; +SET TIMESTAMP=1773142/*!*/; +SET @@session.pseudo_thread_id=999999999/*!*/; +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/*!*/; +SET @@session.sql_mode=0/*!*/; +SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; +/*!\C latin1 *//*!*/; +SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/; +SET @@session.lc_time_names=0/*!*/; +SET @@session.collation_database=DEFAULT/*!*/; +create table t1 (a int auto_increment not null primary key, b char(3)) +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=1/*!*/; +SET TIMESTAMP=1773142/*!*/; +insert into t1 values(null, "a") +/*!*/; +SET TIMESTAMP=1773142/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=2/*!*/; +SET TIMESTAMP=1773142/*!*/; +insert into t1 values(null, "b") +/*!*/; +SET TIMESTAMP=1773142/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=3/*!*/; +SET TIMESTAMP=1773144/*!*/; +insert into t1 values(null, "c") +/*!*/; +SET TIMESTAMP=1773144/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=4/*!*/; +SET TIMESTAMP=1773146/*!*/; +insert into t1 values(null, "d") +/*!*/; +SET TIMESTAMP=1773146/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=5/*!*/; +SET TIMESTAMP=1773146/*!*/; +insert into t1 values(null, "e") +/*!*/; +SET TIMESTAMP=1773146/*!*/; +COMMIT +/*!*/; +DELIMITER ; +# End of log file +ROLLBACK /* added by mysqlbinlog */; +/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; + +--- offset -- +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; +/*!40019 SET @@session.max_insert_delayed_threads=0*/; +/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; +DELIMITER /*!*/; +ROLLBACK/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=1/*!*/; +use `test`/*!*/; +SET TIMESTAMP=1773142/*!*/; +SET @@session.pseudo_thread_id=999999999/*!*/; +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/*!*/; +SET @@session.sql_mode=0/*!*/; +SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; +/*!\C latin1 *//*!*/; +SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/; +SET @@session.lc_time_names=0/*!*/; +SET @@session.collation_database=DEFAULT/*!*/; +insert into t1 values(null, "a") +/*!*/; +SET TIMESTAMP=1773142/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=2/*!*/; +SET TIMESTAMP=1773142/*!*/; +insert into t1 values(null, "b") +/*!*/; +SET TIMESTAMP=1773142/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=3/*!*/; +SET TIMESTAMP=1773144/*!*/; +insert into t1 values(null, "c") +/*!*/; +SET TIMESTAMP=1773144/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=4/*!*/; +SET TIMESTAMP=1773146/*!*/; +insert into t1 values(null, "d") +/*!*/; +SET TIMESTAMP=1773146/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=5/*!*/; +SET TIMESTAMP=1773146/*!*/; +insert into t1 values(null, "e") +/*!*/; +SET TIMESTAMP=1773146/*!*/; +COMMIT +/*!*/; +DELIMITER ; +# End of log file +ROLLBACK /* added by mysqlbinlog */; +/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; + +--- start-position -- +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; +/*!40019 SET @@session.max_insert_delayed_threads=0*/; +/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; +DELIMITER /*!*/; +ROLLBACK/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=3/*!*/; +use `test`/*!*/; +SET TIMESTAMP=1773144/*!*/; +SET @@session.pseudo_thread_id=999999999/*!*/; +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/*!*/; +SET @@session.sql_mode=0/*!*/; +SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; +/*!\C latin1 *//*!*/; +SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/; +SET @@session.lc_time_names=0/*!*/; +SET @@session.collation_database=DEFAULT/*!*/; +insert into t1 values(null, "c") +/*!*/; +SET TIMESTAMP=1773144/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=4/*!*/; +SET TIMESTAMP=1773146/*!*/; +insert into t1 values(null, "d") +/*!*/; +SET TIMESTAMP=1773146/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=5/*!*/; +SET TIMESTAMP=1773146/*!*/; +insert into t1 values(null, "e") +/*!*/; +SET TIMESTAMP=1773146/*!*/; +COMMIT +/*!*/; +DELIMITER ; +# End of log file +ROLLBACK /* added by mysqlbinlog */; +/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; + +--- stop-position -- +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; +/*!40019 SET @@session.max_insert_delayed_threads=0*/; +/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; +DELIMITER /*!*/; +ROLLBACK/*!*/; +use `test`/*!*/; +SET TIMESTAMP=1773142/*!*/; +SET @@session.pseudo_thread_id=999999999/*!*/; +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/*!*/; +SET @@session.sql_mode=0/*!*/; +SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; +/*!\C latin1 *//*!*/; +SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/; +SET @@session.lc_time_names=0/*!*/; +SET @@session.collation_database=DEFAULT/*!*/; +create table t1 (a int auto_increment not null primary key, b char(3)) +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=1/*!*/; +SET TIMESTAMP=1773142/*!*/; +insert into t1 values(null, "a") +/*!*/; +SET TIMESTAMP=1773142/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=2/*!*/; +SET TIMESTAMP=1773142/*!*/; +insert into t1 values(null, "b") +/*!*/; +SET TIMESTAMP=1773142/*!*/; +COMMIT +/*!*/; +DELIMITER ; +# End of log file +ROLLBACK /* added by mysqlbinlog */; +/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; + +--- start and stop positions --- +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; +/*!40019 SET @@session.max_insert_delayed_threads=0*/; +/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; +DELIMITER /*!*/; +ROLLBACK/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=3/*!*/; +use `test`/*!*/; +SET TIMESTAMP=1773144/*!*/; +SET @@session.pseudo_thread_id=999999999/*!*/; +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/*!*/; +SET @@session.sql_mode=0/*!*/; +SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; +/*!\C latin1 *//*!*/; +SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/; +SET @@session.lc_time_names=0/*!*/; +SET @@session.collation_database=DEFAULT/*!*/; +insert into t1 values(null, "c") +/*!*/; +DELIMITER ; +# End of log file +ROLLBACK /* added by mysqlbinlog */; +/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; + +--- start-datetime -- +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; +/*!40019 SET @@session.max_insert_delayed_threads=0*/; +/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; +DELIMITER /*!*/; +ROLLBACK/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=3/*!*/; +use `test`/*!*/; +SET TIMESTAMP=1773144/*!*/; +SET @@session.pseudo_thread_id=999999999/*!*/; +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/*!*/; +SET @@session.sql_mode=0/*!*/; +SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; +/*!\C latin1 *//*!*/; +SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/; +SET @@session.lc_time_names=0/*!*/; +SET @@session.collation_database=DEFAULT/*!*/; +insert into t1 values(null, "c") +/*!*/; +SET TIMESTAMP=1773144/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=4/*!*/; +SET TIMESTAMP=1773146/*!*/; +insert into t1 values(null, "d") +/*!*/; +SET TIMESTAMP=1773146/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=5/*!*/; +SET TIMESTAMP=1773146/*!*/; +insert into t1 values(null, "e") +/*!*/; +SET TIMESTAMP=1773146/*!*/; +COMMIT +/*!*/; +DELIMITER ; +# End of log file +ROLLBACK /* added by mysqlbinlog */; +/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; + +--- stop-datetime -- +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; +/*!40019 SET @@session.max_insert_delayed_threads=0*/; +/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; +DELIMITER /*!*/; +ROLLBACK/*!*/; +use `test`/*!*/; +SET TIMESTAMP=1773142/*!*/; +SET @@session.pseudo_thread_id=999999999/*!*/; +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/*!*/; +SET @@session.sql_mode=0/*!*/; +SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; +/*!\C latin1 *//*!*/; +SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/; +SET @@session.lc_time_names=0/*!*/; +SET @@session.collation_database=DEFAULT/*!*/; +create table t1 (a int auto_increment not null primary key, b char(3)) +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=1/*!*/; +SET TIMESTAMP=1773142/*!*/; +insert into t1 values(null, "a") +/*!*/; +SET TIMESTAMP=1773142/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=2/*!*/; +SET TIMESTAMP=1773142/*!*/; +insert into t1 values(null, "b") +/*!*/; +SET TIMESTAMP=1773142/*!*/; +COMMIT +/*!*/; +DELIMITER ; +# End of log file +ROLLBACK /* added by mysqlbinlog */; +/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; + +--- Local with 2 binlogs on command line -- +flush logs; +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; +/*!40019 SET @@session.max_insert_delayed_threads=0*/; +/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; +DELIMITER /*!*/; +ROLLBACK/*!*/; +use `test`/*!*/; +SET TIMESTAMP=1773142/*!*/; +SET @@session.pseudo_thread_id=999999999/*!*/; +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/*!*/; +SET @@session.sql_mode=0/*!*/; +SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; +/*!\C latin1 *//*!*/; +SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/; +SET @@session.lc_time_names=0/*!*/; +SET @@session.collation_database=DEFAULT/*!*/; +create table t1 (a int auto_increment not null primary key, b char(3)) +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=1/*!*/; +SET TIMESTAMP=1773142/*!*/; +insert into t1 values(null, "a") +/*!*/; +SET TIMESTAMP=1773142/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=2/*!*/; +SET TIMESTAMP=1773142/*!*/; +insert into t1 values(null, "b") +/*!*/; +SET TIMESTAMP=1773142/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=3/*!*/; +SET TIMESTAMP=1773144/*!*/; +insert into t1 values(null, "c") +/*!*/; +SET TIMESTAMP=1773144/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=4/*!*/; +SET TIMESTAMP=1773146/*!*/; +insert into t1 values(null, "d") +/*!*/; +SET TIMESTAMP=1773146/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=5/*!*/; +SET TIMESTAMP=1773146/*!*/; +insert into t1 values(null, "e") +/*!*/; +SET TIMESTAMP=1773146/*!*/; +COMMIT +/*!*/; +DELIMITER ; +DELIMITER /*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=6/*!*/; +use `test`/*!*/; +SET TIMESTAMP=1773143/*!*/; +SET @@session.pseudo_thread_id=999999999/*!*/; +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/*!*/; +SET @@session.sql_mode=0/*!*/; +SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; +/*!\C latin1 *//*!*/; +SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/; +SET @@session.lc_time_names=0/*!*/; +SET @@session.collation_database=DEFAULT/*!*/; +insert into t1 values(null, "f") +/*!*/; +SET TIMESTAMP=1773143/*!*/; +COMMIT +/*!*/; +DELIMITER ; +# End of log file +ROLLBACK /* added by mysqlbinlog */; +/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; + +--- offset -- +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; +/*!40019 SET @@session.max_insert_delayed_threads=0*/; +/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; +DELIMITER /*!*/; +ROLLBACK/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=1/*!*/; +use `test`/*!*/; +SET TIMESTAMP=1773142/*!*/; +SET @@session.pseudo_thread_id=999999999/*!*/; +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/*!*/; +SET @@session.sql_mode=0/*!*/; +SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; +/*!\C latin1 *//*!*/; +SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/; +SET @@session.lc_time_names=0/*!*/; +SET @@session.collation_database=DEFAULT/*!*/; +insert into t1 values(null, "a") +/*!*/; +SET TIMESTAMP=1773142/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=2/*!*/; +SET TIMESTAMP=1773142/*!*/; +insert into t1 values(null, "b") +/*!*/; +SET TIMESTAMP=1773142/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=3/*!*/; +SET TIMESTAMP=1773144/*!*/; +insert into t1 values(null, "c") +/*!*/; +SET TIMESTAMP=1773144/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=4/*!*/; +SET TIMESTAMP=1773146/*!*/; +insert into t1 values(null, "d") +/*!*/; +SET TIMESTAMP=1773146/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=5/*!*/; +SET TIMESTAMP=1773146/*!*/; +insert into t1 values(null, "e") +/*!*/; +SET TIMESTAMP=1773146/*!*/; +COMMIT +/*!*/; +DELIMITER ; +DELIMITER /*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=6/*!*/; +use `test`/*!*/; +SET TIMESTAMP=1773143/*!*/; +SET @@session.pseudo_thread_id=999999999/*!*/; +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/*!*/; +SET @@session.sql_mode=0/*!*/; +SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; +/*!\C latin1 *//*!*/; +SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/; +SET @@session.lc_time_names=0/*!*/; +SET @@session.collation_database=DEFAULT/*!*/; +insert into t1 values(null, "f") +/*!*/; +SET TIMESTAMP=1773143/*!*/; +COMMIT +/*!*/; +DELIMITER ; +# End of log file +ROLLBACK /* added by mysqlbinlog */; +/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; + +--- start-position -- +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; +/*!40019 SET @@session.max_insert_delayed_threads=0*/; +/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; +DELIMITER /*!*/; +ROLLBACK/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=3/*!*/; +use `test`/*!*/; +SET TIMESTAMP=1773144/*!*/; +SET @@session.pseudo_thread_id=999999999/*!*/; +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/*!*/; +SET @@session.sql_mode=0/*!*/; +SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; +/*!\C latin1 *//*!*/; +SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/; +SET @@session.lc_time_names=0/*!*/; +SET @@session.collation_database=DEFAULT/*!*/; +insert into t1 values(null, "c") +/*!*/; +SET TIMESTAMP=1773144/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=4/*!*/; +SET TIMESTAMP=1773146/*!*/; +insert into t1 values(null, "d") +/*!*/; +SET TIMESTAMP=1773146/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=5/*!*/; +SET TIMESTAMP=1773146/*!*/; +insert into t1 values(null, "e") +/*!*/; +SET TIMESTAMP=1773146/*!*/; +COMMIT +/*!*/; +DELIMITER ; +DELIMITER /*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=6/*!*/; +use `test`/*!*/; +SET TIMESTAMP=1773143/*!*/; +SET @@session.pseudo_thread_id=999999999/*!*/; +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/*!*/; +SET @@session.sql_mode=0/*!*/; +SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; +/*!\C latin1 *//*!*/; +SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/; +SET @@session.lc_time_names=0/*!*/; +SET @@session.collation_database=DEFAULT/*!*/; +insert into t1 values(null, "f") +/*!*/; +SET TIMESTAMP=1773143/*!*/; +COMMIT +/*!*/; +DELIMITER ; +# End of log file +ROLLBACK /* added by mysqlbinlog */; +/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; + +--- stop-position -- +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; +/*!40019 SET @@session.max_insert_delayed_threads=0*/; +/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; +DELIMITER /*!*/; +ROLLBACK/*!*/; +use `test`/*!*/; +SET TIMESTAMP=1773142/*!*/; +SET @@session.pseudo_thread_id=999999999/*!*/; +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/*!*/; +SET @@session.sql_mode=0/*!*/; +SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; +/*!\C latin1 *//*!*/; +SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/; +SET @@session.lc_time_names=0/*!*/; +SET @@session.collation_database=DEFAULT/*!*/; +create table t1 (a int auto_increment not null primary key, b char(3)) +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=1/*!*/; +SET TIMESTAMP=1773142/*!*/; +insert into t1 values(null, "a") +/*!*/; +SET TIMESTAMP=1773142/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=2/*!*/; +SET TIMESTAMP=1773142/*!*/; +insert into t1 values(null, "b") +/*!*/; +SET TIMESTAMP=1773142/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=3/*!*/; +SET TIMESTAMP=1773144/*!*/; +insert into t1 values(null, "c") +/*!*/; +SET TIMESTAMP=1773144/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=4/*!*/; +SET TIMESTAMP=1773146/*!*/; +insert into t1 values(null, "d") +/*!*/; +SET TIMESTAMP=1773146/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=5/*!*/; +SET TIMESTAMP=1773146/*!*/; +insert into t1 values(null, "e") +/*!*/; +SET TIMESTAMP=1773146/*!*/; +COMMIT +/*!*/; +DELIMITER ; +DELIMITER /*!*/; +START TRANSACTION +/*!*/; +DELIMITER ; +# End of log file +ROLLBACK /* added by mysqlbinlog */; +/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; + +--- start-datetime -- +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; +/*!40019 SET @@session.max_insert_delayed_threads=0*/; +/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; +DELIMITER /*!*/; +ROLLBACK/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=3/*!*/; +use `test`/*!*/; +SET TIMESTAMP=1773144/*!*/; +SET @@session.pseudo_thread_id=999999999/*!*/; +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/*!*/; +SET @@session.sql_mode=0/*!*/; +SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; +/*!\C latin1 *//*!*/; +SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/; +SET @@session.lc_time_names=0/*!*/; +SET @@session.collation_database=DEFAULT/*!*/; +insert into t1 values(null, "c") +/*!*/; +SET TIMESTAMP=1773144/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=4/*!*/; +SET TIMESTAMP=1773146/*!*/; +insert into t1 values(null, "d") +/*!*/; +SET TIMESTAMP=1773146/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=5/*!*/; +SET TIMESTAMP=1773146/*!*/; +insert into t1 values(null, "e") +/*!*/; +SET TIMESTAMP=1773146/*!*/; +COMMIT +/*!*/; +DELIMITER ; +DELIMITER /*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=6/*!*/; +use `test`/*!*/; +SET TIMESTAMP=1773143/*!*/; +SET @@session.pseudo_thread_id=999999999/*!*/; +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/*!*/; +SET @@session.sql_mode=0/*!*/; +SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; +/*!\C latin1 *//*!*/; +SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/; +SET @@session.lc_time_names=0/*!*/; +SET @@session.collation_database=DEFAULT/*!*/; +insert into t1 values(null, "f") +/*!*/; +SET TIMESTAMP=1773143/*!*/; +COMMIT +/*!*/; +DELIMITER ; +# End of log file +ROLLBACK /* added by mysqlbinlog */; +/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; + +--- stop-datetime -- +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; +/*!40019 SET @@session.max_insert_delayed_threads=0*/; +/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; +DELIMITER /*!*/; +ROLLBACK/*!*/; +use `test`/*!*/; +SET TIMESTAMP=1773142/*!*/; +SET @@session.pseudo_thread_id=999999999/*!*/; +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/*!*/; +SET @@session.sql_mode=0/*!*/; +SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; +/*!\C latin1 *//*!*/; +SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/; +SET @@session.lc_time_names=0/*!*/; +SET @@session.collation_database=DEFAULT/*!*/; +create table t1 (a int auto_increment not null primary key, b char(3)) +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=1/*!*/; +SET TIMESTAMP=1773142/*!*/; +insert into t1 values(null, "a") +/*!*/; +SET TIMESTAMP=1773142/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=2/*!*/; +SET TIMESTAMP=1773142/*!*/; +insert into t1 values(null, "b") +/*!*/; +SET TIMESTAMP=1773142/*!*/; +COMMIT +/*!*/; +DELIMITER ; +# End of log file +ROLLBACK /* added by mysqlbinlog */; +/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; + +--- Remote -- +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; +/*!40019 SET @@session.max_insert_delayed_threads=0*/; +/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; +DELIMITER /*!*/; +ROLLBACK/*!*/; +use `test`/*!*/; +SET TIMESTAMP=1773142/*!*/; +SET @@session.pseudo_thread_id=999999999/*!*/; +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/*!*/; +SET @@session.sql_mode=0/*!*/; +SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; +/*!\C latin1 *//*!*/; +SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/; +SET @@session.lc_time_names=0/*!*/; +SET @@session.collation_database=DEFAULT/*!*/; +create table t1 (a int auto_increment not null primary key, b char(3)) +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=1/*!*/; +SET TIMESTAMP=1773142/*!*/; +insert into t1 values(null, "a") +/*!*/; +SET TIMESTAMP=1773142/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=2/*!*/; +SET TIMESTAMP=1773142/*!*/; +insert into t1 values(null, "b") +/*!*/; +SET TIMESTAMP=1773142/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=3/*!*/; +SET TIMESTAMP=1773144/*!*/; +insert into t1 values(null, "c") +/*!*/; +SET TIMESTAMP=1773144/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=4/*!*/; +SET TIMESTAMP=1773146/*!*/; +insert into t1 values(null, "d") +/*!*/; +SET TIMESTAMP=1773146/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=5/*!*/; +SET TIMESTAMP=1773146/*!*/; +insert into t1 values(null, "e") +/*!*/; +SET TIMESTAMP=1773146/*!*/; +COMMIT +/*!*/; +DELIMITER ; +# End of log file +ROLLBACK /* added by mysqlbinlog */; +/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; + +--- offset -- +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; +/*!40019 SET @@session.max_insert_delayed_threads=0*/; +/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; +DELIMITER /*!*/; +ROLLBACK/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=1/*!*/; +use `test`/*!*/; +SET TIMESTAMP=1773142/*!*/; +SET @@session.pseudo_thread_id=999999999/*!*/; +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/*!*/; +SET @@session.sql_mode=0/*!*/; +SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; +/*!\C latin1 *//*!*/; +SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/; +SET @@session.lc_time_names=0/*!*/; +SET @@session.collation_database=DEFAULT/*!*/; +insert into t1 values(null, "a") +/*!*/; +SET TIMESTAMP=1773142/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=2/*!*/; +SET TIMESTAMP=1773142/*!*/; +insert into t1 values(null, "b") +/*!*/; +SET TIMESTAMP=1773142/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=3/*!*/; +SET TIMESTAMP=1773144/*!*/; +insert into t1 values(null, "c") +/*!*/; +SET TIMESTAMP=1773144/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=4/*!*/; +SET TIMESTAMP=1773146/*!*/; +insert into t1 values(null, "d") +/*!*/; +SET TIMESTAMP=1773146/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=5/*!*/; +SET TIMESTAMP=1773146/*!*/; +insert into t1 values(null, "e") +/*!*/; +SET TIMESTAMP=1773146/*!*/; +COMMIT +/*!*/; +DELIMITER ; +# End of log file +ROLLBACK /* added by mysqlbinlog */; +/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; + +--- start-position -- +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; +/*!40019 SET @@session.max_insert_delayed_threads=0*/; +/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; +DELIMITER /*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=3/*!*/; +use `test`/*!*/; +SET TIMESTAMP=1773144/*!*/; +SET @@session.pseudo_thread_id=999999999/*!*/; +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/*!*/; +SET @@session.sql_mode=0/*!*/; +SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; +/*!\C latin1 *//*!*/; +SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/; +SET @@session.lc_time_names=0/*!*/; +SET @@session.collation_database=DEFAULT/*!*/; +insert into t1 values(null, "c") +/*!*/; +SET TIMESTAMP=1773144/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=4/*!*/; +SET TIMESTAMP=1773146/*!*/; +insert into t1 values(null, "d") +/*!*/; +SET TIMESTAMP=1773146/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=5/*!*/; +SET TIMESTAMP=1773146/*!*/; +insert into t1 values(null, "e") +/*!*/; +SET TIMESTAMP=1773146/*!*/; +COMMIT +/*!*/; +DELIMITER ; +# End of log file +ROLLBACK /* added by mysqlbinlog */; +/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; + +--- stop-position -- +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; +/*!40019 SET @@session.max_insert_delayed_threads=0*/; +/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; +DELIMITER /*!*/; +ROLLBACK/*!*/; +use `test`/*!*/; +SET TIMESTAMP=1773142/*!*/; +SET @@session.pseudo_thread_id=999999999/*!*/; +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/*!*/; +SET @@session.sql_mode=0/*!*/; +SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; +/*!\C latin1 *//*!*/; +SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/; +SET @@session.lc_time_names=0/*!*/; +SET @@session.collation_database=DEFAULT/*!*/; +create table t1 (a int auto_increment not null primary key, b char(3)) +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=1/*!*/; +SET TIMESTAMP=1773142/*!*/; +insert into t1 values(null, "a") +/*!*/; +SET TIMESTAMP=1773142/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=2/*!*/; +SET TIMESTAMP=1773142/*!*/; +insert into t1 values(null, "b") +/*!*/; +SET TIMESTAMP=1773142/*!*/; +COMMIT +/*!*/; +DELIMITER ; +# End of log file +ROLLBACK /* added by mysqlbinlog */; +/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; + +--- start and stop positions --- +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; +/*!40019 SET @@session.max_insert_delayed_threads=0*/; +/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; +DELIMITER /*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=3/*!*/; +use `test`/*!*/; +SET TIMESTAMP=1773144/*!*/; +SET @@session.pseudo_thread_id=999999999/*!*/; +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/*!*/; +SET @@session.sql_mode=0/*!*/; +SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; +/*!\C latin1 *//*!*/; +SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/; +SET @@session.lc_time_names=0/*!*/; +SET @@session.collation_database=DEFAULT/*!*/; +insert into t1 values(null, "c") +/*!*/; +DELIMITER ; +# End of log file +ROLLBACK /* added by mysqlbinlog */; +/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; + +--- start-datetime -- +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; +/*!40019 SET @@session.max_insert_delayed_threads=0*/; +/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; +DELIMITER /*!*/; +ROLLBACK/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=3/*!*/; +use `test`/*!*/; +SET TIMESTAMP=1773144/*!*/; +SET @@session.pseudo_thread_id=999999999/*!*/; +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/*!*/; +SET @@session.sql_mode=0/*!*/; +SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; +/*!\C latin1 *//*!*/; +SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/; +SET @@session.lc_time_names=0/*!*/; +SET @@session.collation_database=DEFAULT/*!*/; +insert into t1 values(null, "c") +/*!*/; +SET TIMESTAMP=1773144/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=4/*!*/; +SET TIMESTAMP=1773146/*!*/; +insert into t1 values(null, "d") +/*!*/; +SET TIMESTAMP=1773146/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=5/*!*/; +SET TIMESTAMP=1773146/*!*/; +insert into t1 values(null, "e") +/*!*/; +SET TIMESTAMP=1773146/*!*/; +COMMIT +/*!*/; +DELIMITER ; +# End of log file +ROLLBACK /* added by mysqlbinlog */; +/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; + +--- stop-datetime -- +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; +/*!40019 SET @@session.max_insert_delayed_threads=0*/; +/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; +DELIMITER /*!*/; +ROLLBACK/*!*/; +use `test`/*!*/; +SET TIMESTAMP=1773142/*!*/; +SET @@session.pseudo_thread_id=999999999/*!*/; +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/*!*/; +SET @@session.sql_mode=0/*!*/; +SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; +/*!\C latin1 *//*!*/; +SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/; +SET @@session.lc_time_names=0/*!*/; +SET @@session.collation_database=DEFAULT/*!*/; +create table t1 (a int auto_increment not null primary key, b char(3)) +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=1/*!*/; +SET TIMESTAMP=1773142/*!*/; +insert into t1 values(null, "a") +/*!*/; +SET TIMESTAMP=1773142/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=2/*!*/; +SET TIMESTAMP=1773142/*!*/; +insert into t1 values(null, "b") +/*!*/; +SET TIMESTAMP=1773142/*!*/; +COMMIT +/*!*/; +DELIMITER ; +# End of log file +ROLLBACK /* added by mysqlbinlog */; +/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; + +--- Remote with 2 binlogs on command line -- +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; +/*!40019 SET @@session.max_insert_delayed_threads=0*/; +/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; +DELIMITER /*!*/; +ROLLBACK/*!*/; +use `test`/*!*/; +SET TIMESTAMP=1773142/*!*/; +SET @@session.pseudo_thread_id=999999999/*!*/; +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/*!*/; +SET @@session.sql_mode=0/*!*/; +SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; +/*!\C latin1 *//*!*/; +SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/; +SET @@session.lc_time_names=0/*!*/; +SET @@session.collation_database=DEFAULT/*!*/; +create table t1 (a int auto_increment not null primary key, b char(3)) +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=1/*!*/; +SET TIMESTAMP=1773142/*!*/; +insert into t1 values(null, "a") +/*!*/; +SET TIMESTAMP=1773142/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=2/*!*/; +SET TIMESTAMP=1773142/*!*/; +insert into t1 values(null, "b") +/*!*/; +SET TIMESTAMP=1773142/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=3/*!*/; +SET TIMESTAMP=1773144/*!*/; +insert into t1 values(null, "c") +/*!*/; +SET TIMESTAMP=1773144/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=4/*!*/; +SET TIMESTAMP=1773146/*!*/; +insert into t1 values(null, "d") +/*!*/; +SET TIMESTAMP=1773146/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=5/*!*/; +SET TIMESTAMP=1773146/*!*/; +insert into t1 values(null, "e") +/*!*/; +SET TIMESTAMP=1773146/*!*/; +COMMIT +/*!*/; +DELIMITER ; +DELIMITER /*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=6/*!*/; +use `test`/*!*/; +SET TIMESTAMP=1773143/*!*/; +SET @@session.pseudo_thread_id=999999999/*!*/; +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/*!*/; +SET @@session.sql_mode=0/*!*/; +SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; +/*!\C latin1 *//*!*/; +SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/; +SET @@session.lc_time_names=0/*!*/; +SET @@session.collation_database=DEFAULT/*!*/; +insert into t1 values(null, "f") +/*!*/; +SET TIMESTAMP=1773143/*!*/; +COMMIT +/*!*/; +DELIMITER ; +# End of log file +ROLLBACK /* added by mysqlbinlog */; +/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; + +--- offset -- +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; +/*!40019 SET @@session.max_insert_delayed_threads=0*/; +/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; +DELIMITER /*!*/; +ROLLBACK/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=1/*!*/; +use `test`/*!*/; +SET TIMESTAMP=1773142/*!*/; +SET @@session.pseudo_thread_id=999999999/*!*/; +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/*!*/; +SET @@session.sql_mode=0/*!*/; +SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; +/*!\C latin1 *//*!*/; +SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/; +SET @@session.lc_time_names=0/*!*/; +SET @@session.collation_database=DEFAULT/*!*/; +insert into t1 values(null, "a") +/*!*/; +SET TIMESTAMP=1773142/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=2/*!*/; +SET TIMESTAMP=1773142/*!*/; +insert into t1 values(null, "b") +/*!*/; +SET TIMESTAMP=1773142/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=3/*!*/; +SET TIMESTAMP=1773144/*!*/; +insert into t1 values(null, "c") +/*!*/; +SET TIMESTAMP=1773144/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=4/*!*/; +SET TIMESTAMP=1773146/*!*/; +insert into t1 values(null, "d") +/*!*/; +SET TIMESTAMP=1773146/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=5/*!*/; +SET TIMESTAMP=1773146/*!*/; +insert into t1 values(null, "e") +/*!*/; +SET TIMESTAMP=1773146/*!*/; +COMMIT +/*!*/; +DELIMITER ; +DELIMITER /*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=6/*!*/; +use `test`/*!*/; +SET TIMESTAMP=1773143/*!*/; +SET @@session.pseudo_thread_id=999999999/*!*/; +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/*!*/; +SET @@session.sql_mode=0/*!*/; +SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; +/*!\C latin1 *//*!*/; +SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/; +SET @@session.lc_time_names=0/*!*/; +SET @@session.collation_database=DEFAULT/*!*/; +insert into t1 values(null, "f") +/*!*/; +SET TIMESTAMP=1773143/*!*/; +COMMIT +/*!*/; +DELIMITER ; +# End of log file +ROLLBACK /* added by mysqlbinlog */; +/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; + +--- start-position -- +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; +/*!40019 SET @@session.max_insert_delayed_threads=0*/; +/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; +DELIMITER /*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=3/*!*/; +use `test`/*!*/; +SET TIMESTAMP=1773144/*!*/; +SET @@session.pseudo_thread_id=999999999/*!*/; +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/*!*/; +SET @@session.sql_mode=0/*!*/; +SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; +/*!\C latin1 *//*!*/; +SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/; +SET @@session.lc_time_names=0/*!*/; +SET @@session.collation_database=DEFAULT/*!*/; +insert into t1 values(null, "c") +/*!*/; +SET TIMESTAMP=1773144/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=4/*!*/; +SET TIMESTAMP=1773146/*!*/; +insert into t1 values(null, "d") +/*!*/; +SET TIMESTAMP=1773146/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=5/*!*/; +SET TIMESTAMP=1773146/*!*/; +insert into t1 values(null, "e") +/*!*/; +SET TIMESTAMP=1773146/*!*/; +COMMIT +/*!*/; +DELIMITER ; +DELIMITER /*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=6/*!*/; +use `test`/*!*/; +SET TIMESTAMP=1773143/*!*/; +SET @@session.pseudo_thread_id=999999999/*!*/; +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/*!*/; +SET @@session.sql_mode=0/*!*/; +SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; +/*!\C latin1 *//*!*/; +SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/; +SET @@session.lc_time_names=0/*!*/; +SET @@session.collation_database=DEFAULT/*!*/; +insert into t1 values(null, "f") +/*!*/; +SET TIMESTAMP=1773143/*!*/; +COMMIT +/*!*/; +DELIMITER ; +# End of log file +ROLLBACK /* added by mysqlbinlog */; +/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; + +--- stop-position -- +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; +/*!40019 SET @@session.max_insert_delayed_threads=0*/; +/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; +DELIMITER /*!*/; +ROLLBACK/*!*/; +use `test`/*!*/; +SET TIMESTAMP=1773142/*!*/; +SET @@session.pseudo_thread_id=999999999/*!*/; +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/*!*/; +SET @@session.sql_mode=0/*!*/; +SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; +/*!\C latin1 *//*!*/; +SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/; +SET @@session.lc_time_names=0/*!*/; +SET @@session.collation_database=DEFAULT/*!*/; +create table t1 (a int auto_increment not null primary key, b char(3)) +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=1/*!*/; +SET TIMESTAMP=1773142/*!*/; +insert into t1 values(null, "a") +/*!*/; +SET TIMESTAMP=1773142/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=2/*!*/; +SET TIMESTAMP=1773142/*!*/; +insert into t1 values(null, "b") +/*!*/; +SET TIMESTAMP=1773142/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=3/*!*/; +SET TIMESTAMP=1773144/*!*/; +insert into t1 values(null, "c") +/*!*/; +SET TIMESTAMP=1773144/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=4/*!*/; +SET TIMESTAMP=1773146/*!*/; +insert into t1 values(null, "d") +/*!*/; +SET TIMESTAMP=1773146/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=5/*!*/; +SET TIMESTAMP=1773146/*!*/; +insert into t1 values(null, "e") +/*!*/; +SET TIMESTAMP=1773146/*!*/; +COMMIT +/*!*/; +DELIMITER ; +DELIMITER /*!*/; +DELIMITER ; +# End of log file +ROLLBACK /* added by mysqlbinlog */; +/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; + +--- start-datetime -- +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; +/*!40019 SET @@session.max_insert_delayed_threads=0*/; +/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; +DELIMITER /*!*/; +ROLLBACK/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=3/*!*/; +use `test`/*!*/; +SET TIMESTAMP=1773144/*!*/; +SET @@session.pseudo_thread_id=999999999/*!*/; +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/*!*/; +SET @@session.sql_mode=0/*!*/; +SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; +/*!\C latin1 *//*!*/; +SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/; +SET @@session.lc_time_names=0/*!*/; +SET @@session.collation_database=DEFAULT/*!*/; +insert into t1 values(null, "c") +/*!*/; +SET TIMESTAMP=1773144/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=4/*!*/; +SET TIMESTAMP=1773146/*!*/; +insert into t1 values(null, "d") +/*!*/; +SET TIMESTAMP=1773146/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=5/*!*/; +SET TIMESTAMP=1773146/*!*/; +insert into t1 values(null, "e") +/*!*/; +SET TIMESTAMP=1773146/*!*/; +COMMIT +/*!*/; +DELIMITER ; +DELIMITER /*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=6/*!*/; +use `test`/*!*/; +SET TIMESTAMP=1773143/*!*/; +SET @@session.pseudo_thread_id=999999999/*!*/; +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/*!*/; +SET @@session.sql_mode=0/*!*/; +SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; +/*!\C latin1 *//*!*/; +SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/; +SET @@session.lc_time_names=0/*!*/; +SET @@session.collation_database=DEFAULT/*!*/; +insert into t1 values(null, "f") +/*!*/; +SET TIMESTAMP=1773143/*!*/; +COMMIT +/*!*/; +DELIMITER ; +# End of log file +ROLLBACK /* added by mysqlbinlog */; +/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; + +--- stop-datetime -- +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; +/*!40019 SET @@session.max_insert_delayed_threads=0*/; +/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; +DELIMITER /*!*/; +ROLLBACK/*!*/; +use `test`/*!*/; +SET TIMESTAMP=1773142/*!*/; +SET @@session.pseudo_thread_id=999999999/*!*/; +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/*!*/; +SET @@session.sql_mode=0/*!*/; +SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; +/*!\C latin1 *//*!*/; +SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/; +SET @@session.lc_time_names=0/*!*/; +SET @@session.collation_database=DEFAULT/*!*/; +create table t1 (a int auto_increment not null primary key, b char(3)) +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=1/*!*/; +SET TIMESTAMP=1773142/*!*/; +insert into t1 values(null, "a") +/*!*/; +SET TIMESTAMP=1773142/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=2/*!*/; +SET TIMESTAMP=1773142/*!*/; +insert into t1 values(null, "b") +/*!*/; +SET TIMESTAMP=1773142/*!*/; +COMMIT +/*!*/; +DELIMITER ; +# End of log file +ROLLBACK /* added by mysqlbinlog */; +/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; + +--- to-last-log -- +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; +/*!40019 SET @@session.max_insert_delayed_threads=0*/; +/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; +DELIMITER /*!*/; +ROLLBACK/*!*/; +use `test`/*!*/; +SET TIMESTAMP=1773142/*!*/; +SET @@session.pseudo_thread_id=999999999/*!*/; +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/*!*/; +SET @@session.sql_mode=0/*!*/; +SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; +/*!\C latin1 *//*!*/; +SET @@session.character_set_client=X,@@session.collation_connection=X,@@session.collation_server=X/*!*/; +SET @@session.lc_time_names=0/*!*/; +SET @@session.collation_database=DEFAULT/*!*/; +create table t1 (a int auto_increment not null primary key, b char(3)) +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=1/*!*/; +SET TIMESTAMP=1773142/*!*/; +insert into t1 values(null, "a") +/*!*/; +SET TIMESTAMP=1773142/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=2/*!*/; +SET TIMESTAMP=1773142/*!*/; +insert into t1 values(null, "b") +/*!*/; +SET TIMESTAMP=1773142/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=3/*!*/; +SET TIMESTAMP=1773144/*!*/; +insert into t1 values(null, "c") +/*!*/; +SET TIMESTAMP=1773144/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=4/*!*/; +SET TIMESTAMP=1773146/*!*/; +insert into t1 values(null, "d") +/*!*/; +SET TIMESTAMP=1773146/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=5/*!*/; +SET TIMESTAMP=1773146/*!*/; +insert into t1 values(null, "e") +/*!*/; +SET TIMESTAMP=1773146/*!*/; +COMMIT +/*!*/; +START TRANSACTION +/*!*/; +SET INSERT_ID=6/*!*/; +SET TIMESTAMP=1773143/*!*/; +insert into t1 values(null, "f") +/*!*/; +SET TIMESTAMP=1773143/*!*/; +COMMIT +/*!*/; +DELIMITER ; +# End of log file +ROLLBACK /* added by mysqlbinlog */; +/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; +/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; + +--- end of test -- +drop table t1; +set global binlog_checksum=default; |