Debian Codegraph @

mysql-test/suite/rpl/r/rpl_timestamp.result

raw
1 include/master-slave.inc
2 [connection master]
3 set timestamp=1656940000;
4 set explicit_defaults_for_timestamp=!@@explicit_defaults_for_timestamp;
5 Warnings:
6 Warning 1287 'explicit_defaults_for_timestamp=0' is deprecated and will be removed in a future release
7 connection master;
8 create table t1 (f1 timestamp, f2 timestamp);
9 show create table t1;
10 Table Create Table
11 t1 CREATE TABLE `t1` (
12 `f1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
13 `f2` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
14 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
15 connection slave;
16 show create table t1;
17 Table Create Table
18 t1 CREATE TABLE `t1` (
19 `f1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
20 `f2` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
21 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
22 connection master;
23 drop table t1;
24 flush binary logs;
25 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
26 /*!40019 SET @@session.max_delayed_threads=0*/;
27 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
28 DELIMITER /*!*/;
29 ROLLBACK/*!*/;
30 use `test`/*!*/;
31 SET TIMESTAMP=1656940000/*!*/;
32 SET @@session.pseudo_thread_id=999999999/*!*/;
33 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, @@session.explicit_defaults_for_timestamp=0, @@session.system_versioning_insert_history=0/*!*/;
34 SET @@session.sql_mode=1411383296/*!*/;
35 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
36 /*!\C latin1 *//*!*/;
37 SET @@session.character_set_client=latin1,@@session.collation_connection=8,@@session.collation_server=2304/*!*/;
38 SET @@session.lc_time_names=0/*!*/;
39 SET @@session.collation_database=DEFAULT/*!*/;
40 create table t1 (f1 timestamp, f2 timestamp)
41 /*!*/;
42 SET TIMESTAMP=1656940000/*!*/;
43 DROP TABLE `t1` /* generated by server */
44 /*!*/;
45 DELIMITER ;
46 # End of log file
47 ROLLBACK /* added by mysqlbinlog */;
48 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
49 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
50 include/rpl_end.inc