diff options
Diffstat (limited to 'mysql-test/main/mysqlbinlog.result')
-rw-r--r-- | mysql-test/main/mysqlbinlog.result | 38 |
1 files changed, 27 insertions, 11 deletions
diff --git a/mysql-test/main/mysqlbinlog.result b/mysql-test/main/mysqlbinlog.result index 32afc150..47672462 100644 --- a/mysql-test/main/mysqlbinlog.result +++ b/mysql-test/main/mysqlbinlog.result @@ -407,16 +407,26 @@ ROLLBACK /* added by mysqlbinlog */; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; ROLLBACK/*!*/; -SET TIMESTAMP=1108844556/*!*/; +use `test`/*!*/; +SET TIMESTAMP=1140641973/*!*/; SET @@session.pseudo_thread_id=999999999/*!*/; +SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1, @@session.autocommit=1, @@session.check_constraint_checks=1, @@session.system_versioning_insert_history=0/*!*/; +SET @@session.sql_mode=#/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; +/*!\C latin1 *//*!*/; +SET @@session.character_set_client=latin1,@@session.collation_connection=8,@@session.collation_server=#/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; -BEGIN +CREATE TABLE t1(c INT) /*!*/; -use `test`/*!*/; -SET TIMESTAMP=1108844555/*!*/; -insert t1 values (1) +SET TIMESTAMP=1140641985/*!*/; +CREATE TABLE t2(s CHAR(200)) +/*!*/; +SET TIMESTAMP=1140642018/*!*/; +CREATE TRIGGER trg1 AFTER INSERT ON t1 FOR EACH ROW INSERT INTO t2 VALUES(CURRENT_USER()) +/*!*/; +SET TIMESTAMP=1140642025/*!*/; +INSERT INTO t1 VALUES(1) /*!*/; DELIMITER ; # End of log file @@ -427,16 +437,21 @@ ROLLBACK /* added by mysqlbinlog */; /*!40019 SET @@session.max_delayed_threads=0*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; -SET TIMESTAMP=1108844556/*!*/; +ROLLBACK/*!*/; +use `test`/*!*/; +SET TIMESTAMP=1140642018/*!*/; SET @@session.pseudo_thread_id=999999999/*!*/; +SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1, @@session.autocommit=1, @@session.check_constraint_checks=1, @@session.system_versioning_insert_history=0/*!*/; +SET @@session.sql_mode=#/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; +/*!\C latin1 *//*!*/; +SET @@session.character_set_client=latin1,@@session.collation_connection=8,@@session.collation_server=#/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; -BEGIN +CREATE TRIGGER trg1 AFTER INSERT ON t1 FOR EACH ROW INSERT INTO t2 VALUES(CURRENT_USER()) /*!*/; -use `test`/*!*/; -SET TIMESTAMP=1108844555/*!*/; -insert t1 values (1) +SET TIMESTAMP=1140642025/*!*/; +INSERT INTO t1 VALUES(1) /*!*/; DELIMITER ; # End of log file @@ -549,6 +564,7 @@ SET @@session.sql_mode=#/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C latin1 *//*!*/; SET @@session.character_set_client=latin1,@@session.collation_connection=8,@@session.collation_server=#/*!*/; +SET @@session.character_set_collations=''/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; create table t1 (a varchar(64) character set utf8) @@ -1269,7 +1285,7 @@ DELIMITER ; ROLLBACK /* added by mysqlbinlog */; /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; -mariadb-binlog Ver VER for OS at ARCH +mariadb-binlog from #.#.#-MariaDB, client #.# for OS (ARCH) # # Test --rewrite-db # |