diff options
Diffstat (limited to 'mysql-test/main/mysqlbinlog.result')
| -rw-r--r-- | mysql-test/main/mysqlbinlog.result | 35 |
1 files changed, 25 insertions, 10 deletions
diff --git a/mysql-test/main/mysqlbinlog.result b/mysql-test/main/mysqlbinlog.result index 1d1f0a12c14..f940a271260 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=8,@@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=8,@@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 |