Debian Codegraph @

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

raw
1 --source include/master-slave.inc
2
3 if ($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
17 connection master;
18 SET TIME_ZONE='+00:00';
19 let $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
28 SHOW CREATE TABLE mysql050614_temporal0;
29 SHOW CREATE TABLE mysql050614_temporal1;
30
31 connection slave;
32 SELECT @@mysql56_temporal_format;
33 SET TIME_ZONE='+00:00';
34 CREATE TABLE mysql050614_temporal0 (a time(0), b datetime(0), c timestamp(0)) engine=myisam;
35 CREATE TABLE mysql050614_temporal1 (a time(1), b datetime(1), c timestamp(1)) engine=myisam;
36
37 connection master;
38 INSERT INTO mysql050614_temporal0 VALUES ('00:00:02','2001-01-01 00:00:02','2001-01-01 00:00:02');
39 INSERT INTO mysql050614_temporal1 VALUES ('00:00:02.1','2001-01-01 00:00:02.2','2001-01-01 00:00:02.3');
40 SELECT TABLE_NAME, TABLE_ROWS, AVG_ROW_LENGTH, DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES
41 WHERE TABLE_NAME LIKE 'mysql050614_temporal%' ORDER BY TABLE_NAME;
42 sync_slave_with_master;
43
44 connection slave;
45 SELECT * FROM mysql050614_temporal0;
46 SELECT * FROM mysql050614_temporal1;
47 SELECT TABLE_NAME, TABLE_ROWS, AVG_ROW_LENGTH,DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES
48 WHERE TABLE_NAME LIKE 'mysql050614_temporal%' ORDER BY TABLE_NAME;
49 SET @@global.mysql56_temporal_format=DEFAULT;
50
51 connection master;
52 DROP TABLE mysql050614_temporal0;
53 DROP TABLE mysql050614_temporal1;
54
55 --source include/rpl_end.inc