| 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 |