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