diff options
Diffstat (limited to 'mysql-test/r/mysqlbinlog2.result')
| -rw-r--r-- | mysql-test/r/mysqlbinlog2.result | 1685 |
1 files changed, 0 insertions, 1685 deletions
diff --git a/mysql-test/r/mysqlbinlog2.result b/mysql-test/r/mysqlbinlog2.result deleted file mode 100644 index bf65bab602d..00000000000 --- a/mysql-test/r/mysqlbinlog2.result +++ /dev/null @@ -1,1685 +0,0 @@ -drop table if exists t1; -reset master; -set @a=UNIX_TIMESTAMP("2020-01-21 15:32:22"); -set timestamp=@a; -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 -- -/*!40019 SET @@session.max_insert_delayed_threads=0*/; -/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; -DELIMITER /*!*/; -ROLLBACK/*!*/; -use `test`/*!*/; -SET TIMESTAMP=1579609942/*!*/; -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/*!*/; -SET @@session.sql_mode=0/*!*/; -SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; -/*!\C latin1 *//*!*/; -SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; -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)) -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=1/*!*/; -SET TIMESTAMP=1579609942/*!*/; -insert into t1 values(null, "a") -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=2/*!*/; -SET TIMESTAMP=1579609942/*!*/; -insert into t1 values(null, "b") -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609944/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=3/*!*/; -SET TIMESTAMP=1579609944/*!*/; -insert into t1 values(null, "c") -/*!*/; -SET TIMESTAMP=1579609944/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=4/*!*/; -SET TIMESTAMP=1579609946/*!*/; -insert into t1 values(null, "d") -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=5/*!*/; -SET TIMESTAMP=1579609946/*!*/; -insert into t1 values(null, "e") -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -COMMIT -/*!*/; -DELIMITER ; -# End of log file -ROLLBACK /* added by mysqlbinlog */; -/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; - ---- offset -- -/*!40019 SET @@session.max_insert_delayed_threads=0*/; -/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; -DELIMITER /*!*/; -ROLLBACK/*!*/; -SET TIMESTAMP=1579609942/*!*/; -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/*!*/; -SET @@session.sql_mode=0/*!*/; -SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; -/*!\C latin1 *//*!*/; -SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; -SET @@session.lc_time_names=0/*!*/; -SET @@session.collation_database=DEFAULT/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=1/*!*/; -use `test`/*!*/; -SET TIMESTAMP=1579609942/*!*/; -insert into t1 values(null, "a") -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=2/*!*/; -SET TIMESTAMP=1579609942/*!*/; -insert into t1 values(null, "b") -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609944/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=3/*!*/; -SET TIMESTAMP=1579609944/*!*/; -insert into t1 values(null, "c") -/*!*/; -SET TIMESTAMP=1579609944/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=4/*!*/; -SET TIMESTAMP=1579609946/*!*/; -insert into t1 values(null, "d") -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=5/*!*/; -SET TIMESTAMP=1579609946/*!*/; -insert into t1 values(null, "e") -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -COMMIT -/*!*/; -DELIMITER ; -# End of log file -ROLLBACK /* added by mysqlbinlog */; -/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; - ---- start-position -- -/*!40019 SET @@session.max_insert_delayed_threads=0*/; -/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; -DELIMITER /*!*/; -ROLLBACK/*!*/; -SET TIMESTAMP=1579609944/*!*/; -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/*!*/; -SET @@session.sql_mode=0/*!*/; -SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; -/*!\C latin1 *//*!*/; -SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; -SET @@session.lc_time_names=0/*!*/; -SET @@session.collation_database=DEFAULT/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=3/*!*/; -use `test`/*!*/; -SET TIMESTAMP=1579609944/*!*/; -insert into t1 values(null, "c") -/*!*/; -SET TIMESTAMP=1579609944/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=4/*!*/; -SET TIMESTAMP=1579609946/*!*/; -insert into t1 values(null, "d") -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=5/*!*/; -SET TIMESTAMP=1579609946/*!*/; -insert into t1 values(null, "e") -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -COMMIT -/*!*/; -DELIMITER ; -# End of log file -ROLLBACK /* added by mysqlbinlog */; -/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; - ---- stop-position -- -/*!40019 SET @@session.max_insert_delayed_threads=0*/; -/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; -DELIMITER /*!*/; -ROLLBACK/*!*/; -use `test`/*!*/; -SET TIMESTAMP=1579609942/*!*/; -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/*!*/; -SET @@session.sql_mode=0/*!*/; -SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; -/*!\C latin1 *//*!*/; -SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; -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)) -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=1/*!*/; -SET TIMESTAMP=1579609942/*!*/; -insert into t1 values(null, "a") -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=2/*!*/; -SET TIMESTAMP=1579609942/*!*/; -insert into t1 values(null, "b") -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -COMMIT -/*!*/; -DELIMITER ; -# End of log file -ROLLBACK /* added by mysqlbinlog */; -/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; - ---- start and stop positions --- -/*!40019 SET @@session.max_insert_delayed_threads=0*/; -/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; -DELIMITER /*!*/; -ROLLBACK/*!*/; -SET TIMESTAMP=1579609944/*!*/; -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/*!*/; -SET @@session.sql_mode=0/*!*/; -SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; -/*!\C latin1 *//*!*/; -SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; -SET @@session.lc_time_names=0/*!*/; -SET @@session.collation_database=DEFAULT/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=3/*!*/; -use `test`/*!*/; -SET TIMESTAMP=1579609944/*!*/; -insert into t1 values(null, "c") -/*!*/; -DELIMITER ; -# End of log file -ROLLBACK /* added by mysqlbinlog */; -/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; - ---- start-datetime -- -/*!40019 SET @@session.max_insert_delayed_threads=0*/; -/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; -DELIMITER /*!*/; -ROLLBACK/*!*/; -SET TIMESTAMP=1579609944/*!*/; -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/*!*/; -SET @@session.sql_mode=0/*!*/; -SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; -/*!\C latin1 *//*!*/; -SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; -SET @@session.lc_time_names=0/*!*/; -SET @@session.collation_database=DEFAULT/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=3/*!*/; -use `test`/*!*/; -SET TIMESTAMP=1579609944/*!*/; -insert into t1 values(null, "c") -/*!*/; -SET TIMESTAMP=1579609944/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=4/*!*/; -SET TIMESTAMP=1579609946/*!*/; -insert into t1 values(null, "d") -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=5/*!*/; -SET TIMESTAMP=1579609946/*!*/; -insert into t1 values(null, "e") -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -COMMIT -/*!*/; -DELIMITER ; -# End of log file -ROLLBACK /* added by mysqlbinlog */; -/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; - ---- stop-datetime -- -/*!40019 SET @@session.max_insert_delayed_threads=0*/; -/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; -DELIMITER /*!*/; -ROLLBACK/*!*/; -use `test`/*!*/; -SET TIMESTAMP=1579609942/*!*/; -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/*!*/; -SET @@session.sql_mode=0/*!*/; -SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; -/*!\C latin1 *//*!*/; -SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; -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)) -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=1/*!*/; -SET TIMESTAMP=1579609942/*!*/; -insert into t1 values(null, "a") -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=2/*!*/; -SET TIMESTAMP=1579609942/*!*/; -insert into t1 values(null, "b") -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -COMMIT -/*!*/; -DELIMITER ; -# End of log file -ROLLBACK /* added by mysqlbinlog */; -/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; - ---- Local with 2 binlogs on command line -- -flush logs; -/*!40019 SET @@session.max_insert_delayed_threads=0*/; -/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; -DELIMITER /*!*/; -ROLLBACK/*!*/; -use `test`/*!*/; -SET TIMESTAMP=1579609942/*!*/; -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/*!*/; -SET @@session.sql_mode=0/*!*/; -SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; -/*!\C latin1 *//*!*/; -SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; -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)) -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=1/*!*/; -SET TIMESTAMP=1579609942/*!*/; -insert into t1 values(null, "a") -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=2/*!*/; -SET TIMESTAMP=1579609942/*!*/; -insert into t1 values(null, "b") -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609944/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=3/*!*/; -SET TIMESTAMP=1579609944/*!*/; -insert into t1 values(null, "c") -/*!*/; -SET TIMESTAMP=1579609944/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=4/*!*/; -SET TIMESTAMP=1579609946/*!*/; -insert into t1 values(null, "d") -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=5/*!*/; -SET TIMESTAMP=1579609946/*!*/; -insert into t1 values(null, "e") -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -COMMIT -/*!*/; -DELIMITER ; -DELIMITER /*!*/; -SET TIMESTAMP=1579609943/*!*/; -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/*!*/; -SET @@session.sql_mode=0/*!*/; -SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; -/*!\C latin1 *//*!*/; -SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; -SET @@session.lc_time_names=0/*!*/; -SET @@session.collation_database=DEFAULT/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=6/*!*/; -use `test`/*!*/; -SET TIMESTAMP=1579609943/*!*/; -insert into t1 values(null, "f") -/*!*/; -SET TIMESTAMP=1579609943/*!*/; -COMMIT -/*!*/; -DELIMITER ; -# End of log file -ROLLBACK /* added by mysqlbinlog */; -/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; - ---- offset -- -/*!40019 SET @@session.max_insert_delayed_threads=0*/; -/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; -DELIMITER /*!*/; -ROLLBACK/*!*/; -SET TIMESTAMP=1579609942/*!*/; -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/*!*/; -SET @@session.sql_mode=0/*!*/; -SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; -/*!\C latin1 *//*!*/; -SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; -SET @@session.lc_time_names=0/*!*/; -SET @@session.collation_database=DEFAULT/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=1/*!*/; -use `test`/*!*/; -SET TIMESTAMP=1579609942/*!*/; -insert into t1 values(null, "a") -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=2/*!*/; -SET TIMESTAMP=1579609942/*!*/; -insert into t1 values(null, "b") -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609944/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=3/*!*/; -SET TIMESTAMP=1579609944/*!*/; -insert into t1 values(null, "c") -/*!*/; -SET TIMESTAMP=1579609944/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=4/*!*/; -SET TIMESTAMP=1579609946/*!*/; -insert into t1 values(null, "d") -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=5/*!*/; -SET TIMESTAMP=1579609946/*!*/; -insert into t1 values(null, "e") -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -COMMIT -/*!*/; -DELIMITER ; -DELIMITER /*!*/; -SET TIMESTAMP=1579609943/*!*/; -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/*!*/; -SET @@session.sql_mode=0/*!*/; -SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; -/*!\C latin1 *//*!*/; -SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; -SET @@session.lc_time_names=0/*!*/; -SET @@session.collation_database=DEFAULT/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=6/*!*/; -use `test`/*!*/; -SET TIMESTAMP=1579609943/*!*/; -insert into t1 values(null, "f") -/*!*/; -SET TIMESTAMP=1579609943/*!*/; -COMMIT -/*!*/; -DELIMITER ; -# End of log file -ROLLBACK /* added by mysqlbinlog */; -/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; - ---- start-position -- -/*!40019 SET @@session.max_insert_delayed_threads=0*/; -/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; -DELIMITER /*!*/; -ROLLBACK/*!*/; -SET TIMESTAMP=1579609944/*!*/; -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/*!*/; -SET @@session.sql_mode=0/*!*/; -SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; -/*!\C latin1 *//*!*/; -SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; -SET @@session.lc_time_names=0/*!*/; -SET @@session.collation_database=DEFAULT/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=3/*!*/; -use `test`/*!*/; -SET TIMESTAMP=1579609944/*!*/; -insert into t1 values(null, "c") -/*!*/; -SET TIMESTAMP=1579609944/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=4/*!*/; -SET TIMESTAMP=1579609946/*!*/; -insert into t1 values(null, "d") -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=5/*!*/; -SET TIMESTAMP=1579609946/*!*/; -insert into t1 values(null, "e") -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -COMMIT -/*!*/; -DELIMITER ; -DELIMITER /*!*/; -SET TIMESTAMP=1579609943/*!*/; -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/*!*/; -SET @@session.sql_mode=0/*!*/; -SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; -/*!\C latin1 *//*!*/; -SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; -SET @@session.lc_time_names=0/*!*/; -SET @@session.collation_database=DEFAULT/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=6/*!*/; -use `test`/*!*/; -SET TIMESTAMP=1579609943/*!*/; -insert into t1 values(null, "f") -/*!*/; -SET TIMESTAMP=1579609943/*!*/; -COMMIT -/*!*/; -DELIMITER ; -# End of log file -ROLLBACK /* added by mysqlbinlog */; -/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; - ---- stop-position -- -/*!40019 SET @@session.max_insert_delayed_threads=0*/; -/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; -DELIMITER /*!*/; -ROLLBACK/*!*/; -use `test`/*!*/; -SET TIMESTAMP=1579609942/*!*/; -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/*!*/; -SET @@session.sql_mode=0/*!*/; -SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; -/*!\C latin1 *//*!*/; -SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; -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)) -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=1/*!*/; -SET TIMESTAMP=1579609942/*!*/; -insert into t1 values(null, "a") -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=2/*!*/; -SET TIMESTAMP=1579609942/*!*/; -insert into t1 values(null, "b") -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609944/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=3/*!*/; -SET TIMESTAMP=1579609944/*!*/; -insert into t1 values(null, "c") -/*!*/; -SET TIMESTAMP=1579609944/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=4/*!*/; -SET TIMESTAMP=1579609946/*!*/; -insert into t1 values(null, "d") -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=5/*!*/; -SET TIMESTAMP=1579609946/*!*/; -insert into t1 values(null, "e") -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -COMMIT -/*!*/; -DELIMITER ; -DELIMITER /*!*/; -SET TIMESTAMP=1579609943/*!*/; -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/*!*/; -SET @@session.sql_mode=0/*!*/; -SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; -/*!\C latin1 *//*!*/; -SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; -SET @@session.lc_time_names=0/*!*/; -SET @@session.collation_database=DEFAULT/*!*/; -BEGIN -/*!*/; -DELIMITER ; -# End of log file -ROLLBACK /* added by mysqlbinlog */; -/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; - ---- start-datetime -- -/*!40019 SET @@session.max_insert_delayed_threads=0*/; -/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; -DELIMITER /*!*/; -ROLLBACK/*!*/; -SET TIMESTAMP=1579609944/*!*/; -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/*!*/; -SET @@session.sql_mode=0/*!*/; -SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; -/*!\C latin1 *//*!*/; -SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; -SET @@session.lc_time_names=0/*!*/; -SET @@session.collation_database=DEFAULT/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=3/*!*/; -use `test`/*!*/; -SET TIMESTAMP=1579609944/*!*/; -insert into t1 values(null, "c") -/*!*/; -SET TIMESTAMP=1579609944/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=4/*!*/; -SET TIMESTAMP=1579609946/*!*/; -insert into t1 values(null, "d") -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=5/*!*/; -SET TIMESTAMP=1579609946/*!*/; -insert into t1 values(null, "e") -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -COMMIT -/*!*/; -DELIMITER ; -DELIMITER /*!*/; -SET TIMESTAMP=1579609943/*!*/; -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/*!*/; -SET @@session.sql_mode=0/*!*/; -SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; -/*!\C latin1 *//*!*/; -SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; -SET @@session.lc_time_names=0/*!*/; -SET @@session.collation_database=DEFAULT/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=6/*!*/; -use `test`/*!*/; -SET TIMESTAMP=1579609943/*!*/; -insert into t1 values(null, "f") -/*!*/; -SET TIMESTAMP=1579609943/*!*/; -COMMIT -/*!*/; -DELIMITER ; -# End of log file -ROLLBACK /* added by mysqlbinlog */; -/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; - ---- stop-datetime -- -/*!40019 SET @@session.max_insert_delayed_threads=0*/; -/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; -DELIMITER /*!*/; -ROLLBACK/*!*/; -use `test`/*!*/; -SET TIMESTAMP=1579609942/*!*/; -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/*!*/; -SET @@session.sql_mode=0/*!*/; -SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; -/*!\C latin1 *//*!*/; -SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; -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)) -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=1/*!*/; -SET TIMESTAMP=1579609942/*!*/; -insert into t1 values(null, "a") -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=2/*!*/; -SET TIMESTAMP=1579609942/*!*/; -insert into t1 values(null, "b") -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -COMMIT -/*!*/; -DELIMITER ; -# End of log file -ROLLBACK /* added by mysqlbinlog */; -/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; - ---- Remote -- -/*!40019 SET @@session.max_insert_delayed_threads=0*/; -/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; -DELIMITER /*!*/; -ROLLBACK/*!*/; -use `test`/*!*/; -SET TIMESTAMP=1579609942/*!*/; -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/*!*/; -SET @@session.sql_mode=0/*!*/; -SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; -/*!\C latin1 *//*!*/; -SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; -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)) -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=1/*!*/; -SET TIMESTAMP=1579609942/*!*/; -insert into t1 values(null, "a") -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=2/*!*/; -SET TIMESTAMP=1579609942/*!*/; -insert into t1 values(null, "b") -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609944/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=3/*!*/; -SET TIMESTAMP=1579609944/*!*/; -insert into t1 values(null, "c") -/*!*/; -SET TIMESTAMP=1579609944/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=4/*!*/; -SET TIMESTAMP=1579609946/*!*/; -insert into t1 values(null, "d") -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=5/*!*/; -SET TIMESTAMP=1579609946/*!*/; -insert into t1 values(null, "e") -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -COMMIT -/*!*/; -DELIMITER ; -# End of log file -ROLLBACK /* added by mysqlbinlog */; -/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; - ---- offset -- -/*!40019 SET @@session.max_insert_delayed_threads=0*/; -/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; -DELIMITER /*!*/; -ROLLBACK/*!*/; -SET TIMESTAMP=1579609942/*!*/; -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/*!*/; -SET @@session.sql_mode=0/*!*/; -SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; -/*!\C latin1 *//*!*/; -SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; -SET @@session.lc_time_names=0/*!*/; -SET @@session.collation_database=DEFAULT/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=1/*!*/; -use `test`/*!*/; -SET TIMESTAMP=1579609942/*!*/; -insert into t1 values(null, "a") -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=2/*!*/; -SET TIMESTAMP=1579609942/*!*/; -insert into t1 values(null, "b") -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609944/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=3/*!*/; -SET TIMESTAMP=1579609944/*!*/; -insert into t1 values(null, "c") -/*!*/; -SET TIMESTAMP=1579609944/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=4/*!*/; -SET TIMESTAMP=1579609946/*!*/; -insert into t1 values(null, "d") -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=5/*!*/; -SET TIMESTAMP=1579609946/*!*/; -insert into t1 values(null, "e") -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -COMMIT -/*!*/; -DELIMITER ; -# End of log file -ROLLBACK /* added by mysqlbinlog */; -/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; - ---- start-position -- -/*!40019 SET @@session.max_insert_delayed_threads=0*/; -/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; -DELIMITER /*!*/; -SET TIMESTAMP=1579609944/*!*/; -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/*!*/; -SET @@session.sql_mode=0/*!*/; -SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; -/*!\C latin1 *//*!*/; -SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; -SET @@session.lc_time_names=0/*!*/; -SET @@session.collation_database=DEFAULT/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=3/*!*/; -use `test`/*!*/; -SET TIMESTAMP=1579609944/*!*/; -insert into t1 values(null, "c") -/*!*/; -SET TIMESTAMP=1579609944/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=4/*!*/; -SET TIMESTAMP=1579609946/*!*/; -insert into t1 values(null, "d") -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=5/*!*/; -SET TIMESTAMP=1579609946/*!*/; -insert into t1 values(null, "e") -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -COMMIT -/*!*/; -DELIMITER ; -# End of log file -ROLLBACK /* added by mysqlbinlog */; -/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; - ---- stop-position -- -/*!40019 SET @@session.max_insert_delayed_threads=0*/; -/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; -DELIMITER /*!*/; -ROLLBACK/*!*/; -use `test`/*!*/; -SET TIMESTAMP=1579609942/*!*/; -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/*!*/; -SET @@session.sql_mode=0/*!*/; -SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; -/*!\C latin1 *//*!*/; -SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; -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)) -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=1/*!*/; -SET TIMESTAMP=1579609942/*!*/; -insert into t1 values(null, "a") -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=2/*!*/; -SET TIMESTAMP=1579609942/*!*/; -insert into t1 values(null, "b") -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -COMMIT -/*!*/; -DELIMITER ; -# End of log file -ROLLBACK /* added by mysqlbinlog */; -/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; - ---- start and stop positions --- -/*!40019 SET @@session.max_insert_delayed_threads=0*/; -/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; -DELIMITER /*!*/; -SET TIMESTAMP=1579609944/*!*/; -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/*!*/; -SET @@session.sql_mode=0/*!*/; -SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; -/*!\C latin1 *//*!*/; -SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; -SET @@session.lc_time_names=0/*!*/; -SET @@session.collation_database=DEFAULT/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=3/*!*/; -use `test`/*!*/; -SET TIMESTAMP=1579609944/*!*/; -insert into t1 values(null, "c") -/*!*/; -DELIMITER ; -# End of log file -ROLLBACK /* added by mysqlbinlog */; -/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; - ---- start-datetime -- -/*!40019 SET @@session.max_insert_delayed_threads=0*/; -/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; -DELIMITER /*!*/; -ROLLBACK/*!*/; -SET TIMESTAMP=1579609944/*!*/; -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/*!*/; -SET @@session.sql_mode=0/*!*/; -SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; -/*!\C latin1 *//*!*/; -SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; -SET @@session.lc_time_names=0/*!*/; -SET @@session.collation_database=DEFAULT/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=3/*!*/; -use `test`/*!*/; -SET TIMESTAMP=1579609944/*!*/; -insert into t1 values(null, "c") -/*!*/; -SET TIMESTAMP=1579609944/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=4/*!*/; -SET TIMESTAMP=1579609946/*!*/; -insert into t1 values(null, "d") -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=5/*!*/; -SET TIMESTAMP=1579609946/*!*/; -insert into t1 values(null, "e") -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -COMMIT -/*!*/; -DELIMITER ; -# End of log file -ROLLBACK /* added by mysqlbinlog */; -/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; - ---- stop-datetime -- -/*!40019 SET @@session.max_insert_delayed_threads=0*/; -/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; -DELIMITER /*!*/; -ROLLBACK/*!*/; -use `test`/*!*/; -SET TIMESTAMP=1579609942/*!*/; -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/*!*/; -SET @@session.sql_mode=0/*!*/; -SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; -/*!\C latin1 *//*!*/; -SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; -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)) -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=1/*!*/; -SET TIMESTAMP=1579609942/*!*/; -insert into t1 values(null, "a") -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=2/*!*/; -SET TIMESTAMP=1579609942/*!*/; -insert into t1 values(null, "b") -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -COMMIT -/*!*/; -DELIMITER ; -# End of log file -ROLLBACK /* added by mysqlbinlog */; -/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; - ---- Remote with 2 binlogs on command line -- -/*!40019 SET @@session.max_insert_delayed_threads=0*/; -/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; -DELIMITER /*!*/; -ROLLBACK/*!*/; -use `test`/*!*/; -SET TIMESTAMP=1579609942/*!*/; -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/*!*/; -SET @@session.sql_mode=0/*!*/; -SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; -/*!\C latin1 *//*!*/; -SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; -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)) -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=1/*!*/; -SET TIMESTAMP=1579609942/*!*/; -insert into t1 values(null, "a") -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=2/*!*/; -SET TIMESTAMP=1579609942/*!*/; -insert into t1 values(null, "b") -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609944/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=3/*!*/; -SET TIMESTAMP=1579609944/*!*/; -insert into t1 values(null, "c") -/*!*/; -SET TIMESTAMP=1579609944/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=4/*!*/; -SET TIMESTAMP=1579609946/*!*/; -insert into t1 values(null, "d") -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=5/*!*/; -SET TIMESTAMP=1579609946/*!*/; -insert into t1 values(null, "e") -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -COMMIT -/*!*/; -DELIMITER ; -DELIMITER /*!*/; -SET TIMESTAMP=1579609943/*!*/; -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/*!*/; -SET @@session.sql_mode=0/*!*/; -SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; -/*!\C latin1 *//*!*/; -SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; -SET @@session.lc_time_names=0/*!*/; -SET @@session.collation_database=DEFAULT/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=6/*!*/; -use `test`/*!*/; -SET TIMESTAMP=1579609943/*!*/; -insert into t1 values(null, "f") -/*!*/; -SET TIMESTAMP=1579609943/*!*/; -COMMIT -/*!*/; -DELIMITER ; -# End of log file -ROLLBACK /* added by mysqlbinlog */; -/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; - ---- offset -- -/*!40019 SET @@session.max_insert_delayed_threads=0*/; -/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; -DELIMITER /*!*/; -ROLLBACK/*!*/; -SET TIMESTAMP=1579609942/*!*/; -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/*!*/; -SET @@session.sql_mode=0/*!*/; -SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; -/*!\C latin1 *//*!*/; -SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; -SET @@session.lc_time_names=0/*!*/; -SET @@session.collation_database=DEFAULT/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=1/*!*/; -use `test`/*!*/; -SET TIMESTAMP=1579609942/*!*/; -insert into t1 values(null, "a") -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=2/*!*/; -SET TIMESTAMP=1579609942/*!*/; -insert into t1 values(null, "b") -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609944/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=3/*!*/; -SET TIMESTAMP=1579609944/*!*/; -insert into t1 values(null, "c") -/*!*/; -SET TIMESTAMP=1579609944/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=4/*!*/; -SET TIMESTAMP=1579609946/*!*/; -insert into t1 values(null, "d") -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=5/*!*/; -SET TIMESTAMP=1579609946/*!*/; -insert into t1 values(null, "e") -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -COMMIT -/*!*/; -DELIMITER ; -DELIMITER /*!*/; -SET TIMESTAMP=1579609943/*!*/; -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/*!*/; -SET @@session.sql_mode=0/*!*/; -SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; -/*!\C latin1 *//*!*/; -SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; -SET @@session.lc_time_names=0/*!*/; -SET @@session.collation_database=DEFAULT/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=6/*!*/; -use `test`/*!*/; -SET TIMESTAMP=1579609943/*!*/; -insert into t1 values(null, "f") -/*!*/; -SET TIMESTAMP=1579609943/*!*/; -COMMIT -/*!*/; -DELIMITER ; -# End of log file -ROLLBACK /* added by mysqlbinlog */; -/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; - ---- start-position -- -/*!40019 SET @@session.max_insert_delayed_threads=0*/; -/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; -DELIMITER /*!*/; -SET TIMESTAMP=1579609944/*!*/; -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/*!*/; -SET @@session.sql_mode=0/*!*/; -SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; -/*!\C latin1 *//*!*/; -SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; -SET @@session.lc_time_names=0/*!*/; -SET @@session.collation_database=DEFAULT/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=3/*!*/; -use `test`/*!*/; -SET TIMESTAMP=1579609944/*!*/; -insert into t1 values(null, "c") -/*!*/; -SET TIMESTAMP=1579609944/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=4/*!*/; -SET TIMESTAMP=1579609946/*!*/; -insert into t1 values(null, "d") -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=5/*!*/; -SET TIMESTAMP=1579609946/*!*/; -insert into t1 values(null, "e") -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -COMMIT -/*!*/; -DELIMITER ; -DELIMITER /*!*/; -SET TIMESTAMP=1579609943/*!*/; -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/*!*/; -SET @@session.sql_mode=0/*!*/; -SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; -/*!\C latin1 *//*!*/; -SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; -SET @@session.lc_time_names=0/*!*/; -SET @@session.collation_database=DEFAULT/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=6/*!*/; -use `test`/*!*/; -SET TIMESTAMP=1579609943/*!*/; -insert into t1 values(null, "f") -/*!*/; -SET TIMESTAMP=1579609943/*!*/; -COMMIT -/*!*/; -DELIMITER ; -# End of log file -ROLLBACK /* added by mysqlbinlog */; -/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; - ---- stop-position -- -/*!40019 SET @@session.max_insert_delayed_threads=0*/; -/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; -DELIMITER /*!*/; -ROLLBACK/*!*/; -use `test`/*!*/; -SET TIMESTAMP=1579609942/*!*/; -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/*!*/; -SET @@session.sql_mode=0/*!*/; -SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; -/*!\C latin1 *//*!*/; -SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; -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)) -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=1/*!*/; -SET TIMESTAMP=1579609942/*!*/; -insert into t1 values(null, "a") -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=2/*!*/; -SET TIMESTAMP=1579609942/*!*/; -insert into t1 values(null, "b") -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609944/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=3/*!*/; -SET TIMESTAMP=1579609944/*!*/; -insert into t1 values(null, "c") -/*!*/; -SET TIMESTAMP=1579609944/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=4/*!*/; -SET TIMESTAMP=1579609946/*!*/; -insert into t1 values(null, "d") -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=5/*!*/; -SET TIMESTAMP=1579609946/*!*/; -insert into t1 values(null, "e") -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -COMMIT -/*!*/; -DELIMITER ; -DELIMITER /*!*/; -DELIMITER ; -# End of log file -ROLLBACK /* added by mysqlbinlog */; -/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; - ---- start-datetime -- -/*!40019 SET @@session.max_insert_delayed_threads=0*/; -/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; -DELIMITER /*!*/; -ROLLBACK/*!*/; -SET TIMESTAMP=1579609944/*!*/; -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/*!*/; -SET @@session.sql_mode=0/*!*/; -SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; -/*!\C latin1 *//*!*/; -SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; -SET @@session.lc_time_names=0/*!*/; -SET @@session.collation_database=DEFAULT/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=3/*!*/; -use `test`/*!*/; -SET TIMESTAMP=1579609944/*!*/; -insert into t1 values(null, "c") -/*!*/; -SET TIMESTAMP=1579609944/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=4/*!*/; -SET TIMESTAMP=1579609946/*!*/; -insert into t1 values(null, "d") -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=5/*!*/; -SET TIMESTAMP=1579609946/*!*/; -insert into t1 values(null, "e") -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -COMMIT -/*!*/; -DELIMITER ; -DELIMITER /*!*/; -SET TIMESTAMP=1579609943/*!*/; -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/*!*/; -SET @@session.sql_mode=0/*!*/; -SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; -/*!\C latin1 *//*!*/; -SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; -SET @@session.lc_time_names=0/*!*/; -SET @@session.collation_database=DEFAULT/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=6/*!*/; -use `test`/*!*/; -SET TIMESTAMP=1579609943/*!*/; -insert into t1 values(null, "f") -/*!*/; -SET TIMESTAMP=1579609943/*!*/; -COMMIT -/*!*/; -DELIMITER ; -# End of log file -ROLLBACK /* added by mysqlbinlog */; -/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; - ---- stop-datetime -- -/*!40019 SET @@session.max_insert_delayed_threads=0*/; -/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; -DELIMITER /*!*/; -ROLLBACK/*!*/; -use `test`/*!*/; -SET TIMESTAMP=1579609942/*!*/; -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/*!*/; -SET @@session.sql_mode=0/*!*/; -SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; -/*!\C latin1 *//*!*/; -SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; -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)) -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=1/*!*/; -SET TIMESTAMP=1579609942/*!*/; -insert into t1 values(null, "a") -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=2/*!*/; -SET TIMESTAMP=1579609942/*!*/; -insert into t1 values(null, "b") -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -COMMIT -/*!*/; -DELIMITER ; -# End of log file -ROLLBACK /* added by mysqlbinlog */; -/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; - ---- to-last-log -- -/*!40019 SET @@session.max_insert_delayed_threads=0*/; -/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; -DELIMITER /*!*/; -ROLLBACK/*!*/; -use `test`/*!*/; -SET TIMESTAMP=1579609942/*!*/; -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/*!*/; -SET @@session.sql_mode=0/*!*/; -SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; -/*!\C latin1 *//*!*/; -SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; -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)) -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=1/*!*/; -SET TIMESTAMP=1579609942/*!*/; -insert into t1 values(null, "a") -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=2/*!*/; -SET TIMESTAMP=1579609942/*!*/; -insert into t1 values(null, "b") -/*!*/; -SET TIMESTAMP=1579609942/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609944/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=3/*!*/; -SET TIMESTAMP=1579609944/*!*/; -insert into t1 values(null, "c") -/*!*/; -SET TIMESTAMP=1579609944/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=4/*!*/; -SET TIMESTAMP=1579609946/*!*/; -insert into t1 values(null, "d") -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=5/*!*/; -SET TIMESTAMP=1579609946/*!*/; -insert into t1 values(null, "e") -/*!*/; -SET TIMESTAMP=1579609946/*!*/; -COMMIT -/*!*/; -SET TIMESTAMP=1579609943/*!*/; -BEGIN -/*!*/; -SET INSERT_ID=6/*!*/; -SET TIMESTAMP=1579609943/*!*/; -insert into t1 values(null, "f") -/*!*/; -SET TIMESTAMP=1579609943/*!*/; -COMMIT -/*!*/; -DELIMITER ; -# End of log file -ROLLBACK /* added by mysqlbinlog */; -/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; - ---- end of test -- -drop table t1; |