mariadb/mysql-test/suite/rpl/t/rpl_timestamp.test
Sergei Golubchik b174ec169d MDEV-29225 make explicit_defaults_for_timestamps SESSION variable
save it in binlog, so that CREATE TABLE could be replayed correctly
on the slave
2022-08-02 18:08:38 +02:00

18 lines
432 B
Text

source include/master-slave.inc;
set timestamp=1656940000;
set explicit_defaults_for_timestamp=!@@explicit_defaults_for_timestamp;
connection master;
create table t1 (f1 timestamp, f2 timestamp);
show create table t1;
sync_slave_with_master;
show create table t1;
connection master;
drop table t1;
flush binary logs;
let $datadir=`select @@datadir`;
exec $MYSQL_BINLOG -s $datadir/master-bin.000001;
source include/rpl_end.inc;