1--source include/master-slave.inc
2
3if ($force_slave_mysql56_temporal_format)
4{
5  connection slave;
6  eval SET @@global.mysql56_temporal_format=$force_slave_mysql56_temporal_format;
7  connection master;
8}
9
10
11--echo #
12--echo # Testing replication from MariaDB-10.0 master
13--echo # started over MySQL-5.6 data directory
14--echo # to MariaDB-10.0 slave running with natively created tables
15--echo #
16
17connection master;
18SET TIME_ZONE='+00:00';
19let $MYSQLD_MASTER_DATADIR= `select @@datadir`;
20
21--copy_file std_data/temporal_upgrade/mysql050614_temporal0.frm $MYSQLD_MASTER_DATADIR/test/mysql050614_temporal0.frm
22--copy_file std_data/temporal_upgrade/mysql050614_temporal0.MYD $MYSQLD_MASTER_DATADIR/test/mysql050614_temporal0.MYD
23--copy_file std_data/temporal_upgrade/mysql050614_temporal0.MYI $MYSQLD_MASTER_DATADIR/test/mysql050614_temporal0.MYI
24
25--copy_file std_data/temporal_upgrade/mysql050614_temporal1.frm $MYSQLD_MASTER_DATADIR/test/mysql050614_temporal1.frm
26--copy_file std_data/temporal_upgrade/mysql050614_temporal1.MYD $MYSQLD_MASTER_DATADIR/test/mysql050614_temporal1.MYD
27--copy_file std_data/temporal_upgrade/mysql050614_temporal1.MYI $MYSQLD_MASTER_DATADIR/test/mysql050614_temporal1.MYI
28SHOW CREATE TABLE mysql050614_temporal0;
29SHOW CREATE TABLE mysql050614_temporal1;
30
31connection slave;
32SELECT @@mysql56_temporal_format;
33SET TIME_ZONE='+00:00';
34CREATE TABLE mysql050614_temporal0 (a time(0), b datetime(0), c timestamp(0)) engine=myisam;
35CREATE TABLE mysql050614_temporal1 (a time(1), b datetime(1), c timestamp(1)) engine=myisam;
36
37connection master;
38INSERT INTO mysql050614_temporal0 VALUES ('00:00:02','2001-01-01 00:00:02','2001-01-01 00:00:02');
39INSERT INTO mysql050614_temporal1 VALUES ('00:00:02.1','2001-01-01 00:00:02.2','2001-01-01 00:00:02.3');
40SELECT TABLE_NAME, TABLE_ROWS, AVG_ROW_LENGTH, DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES
41WHERE TABLE_NAME LIKE 'mysql050614_temporal%' ORDER BY TABLE_NAME;
42sync_slave_with_master;
43
44connection slave;
45SELECT * FROM mysql050614_temporal0;
46SELECT * FROM mysql050614_temporal1;
47SELECT TABLE_NAME, TABLE_ROWS, AVG_ROW_LENGTH,DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES
48WHERE TABLE_NAME LIKE 'mysql050614_temporal%' ORDER BY TABLE_NAME;
49SET @@global.mysql56_temporal_format=DEFAULT;
50
51connection master;
52DROP TABLE mysql050614_temporal0;
53DROP TABLE mysql050614_temporal1;
54
55--source include/rpl_end.inc
56