mirror of
https://github.com/MariaDB/server.git
synced 2025-02-09 23:24:11 +01:00
53 lines
1.2 KiB
Text
53 lines
1.2 KiB
Text
--echo #
|
|
--echo # MDEV-29078 For old binary logs explicit_defaults_for_timestamp presumed to be OFF, server value ignored
|
|
--echo #
|
|
|
|
--source include/have_binlog_format_mixed.inc
|
|
--source include/master-slave.inc
|
|
|
|
--connection slave
|
|
--source include/stop_slave.inc
|
|
|
|
--connection master
|
|
--let $datadir= `SELECT @@datadir`
|
|
|
|
flush binary logs;
|
|
create table t2 (a timestamp);
|
|
|
|
--save_master_pos
|
|
|
|
--remove_file $datadir/master-bin.000001
|
|
--copy_file $MYSQL_TEST_DIR/std_data/mdev29078-mysql-bin.000001 $datadir/master-bin.000001
|
|
|
|
--exec $MYSQL_BINLOG --short-form $datadir/master-bin.000001
|
|
|
|
--connection slave
|
|
|
|
set global explicit_defaults_for_timestamp=0;
|
|
--let $master_use_gtid_option= No
|
|
--source include/reset_slave.inc
|
|
|
|
--source include/start_slave.inc
|
|
--sync_with_master
|
|
show create table t1;
|
|
show create table t2;
|
|
set time_zone='+2:00';
|
|
select * from t1;
|
|
drop table t1;
|
|
--source include/stop_slave.inc
|
|
|
|
set global explicit_defaults_for_timestamp=1;
|
|
--let $master_use_gtid_option= No
|
|
--source include/reset_slave.inc
|
|
|
|
--source include/start_slave.inc
|
|
--sync_with_master
|
|
show create table t1;
|
|
show create table t2;
|
|
select * from t1;
|
|
drop table t1;
|
|
|
|
--connection master
|
|
drop table t2;
|
|
|
|
--source include/rpl_end.inc
|