Debian Codegraph @

mysql-test/suite/rpl/t/rpl_old_master_29078.test

raw
1 --echo #
2 --echo # MDEV-29078 For old binary logs explicit_defaults_for_timestamp presumed to be OFF, server value ignored
3 --echo #
4
5 --source include/have_binlog_format_mixed.inc
6 --source include/master-slave.inc
7
8 --connection slave
9 --source include/stop_slave.inc
10
11 --connection master
12 --let $datadir= `SELECT @@datadir`
13
14 flush binary logs;
15 create table t2 (a timestamp);
16
17 --save_master_pos
18
19 --remove_file $datadir/master-bin.000001
20 --copy_file $MYSQL_TEST_DIR/std_data/mdev29078-mysql-bin.000001 $datadir/master-bin.000001
21
22 --exec $MYSQL_BINLOG --short-form $datadir/master-bin.000001
23
24 --connection slave
25
26 set global explicit_defaults_for_timestamp=0;
27 --let $master_use_gtid_option= No
28 --source include/reset_slave.inc
29
30 --source include/start_slave.inc
31 --sync_with_master
32 show create table t1;
33 show create table t2;
34 set time_zone='+2:00';
35 select * from t1;
36 drop table t1;
37 --source include/stop_slave.inc
38
39 set global explicit_defaults_for_timestamp=1;
40 --let $master_use_gtid_option= No
41 --source include/reset_slave.inc
42
43 --source include/start_slave.inc
44 --sync_with_master
45 show create table t1;
46 show create table t2;
47 select * from t1;
48 drop table t1;
49
50 --connection master
51 drop table t2;
52
53 --source include/rpl_end.inc