diff options
Diffstat (limited to 'mysql-test/suite/rpl/r/rpl_temporal_mysql56_to_mariadb53.result')
-rw-r--r-- | mysql-test/suite/rpl/r/rpl_temporal_mysql56_to_mariadb53.result | 12 |
1 files changed, 10 insertions, 2 deletions
diff --git a/mysql-test/suite/rpl/r/rpl_temporal_mysql56_to_mariadb53.result b/mysql-test/suite/rpl/r/rpl_temporal_mysql56_to_mariadb53.result index 37373367f8a..ace11d5bd6e 100644 --- a/mysql-test/suite/rpl/r/rpl_temporal_mysql56_to_mariadb53.result +++ b/mysql-test/suite/rpl/r/rpl_temporal_mysql56_to_mariadb53.result @@ -1,32 +1,37 @@ include/master-slave.inc [connection master] +connection slave; SET @@global.mysql56_temporal_format=false;; +connection master; # # Testing replication from MariaDB-10.0 master # started over MySQL-5.6 data directory # to MariaDB-10.0 slave running with natively created tables # +connection master; SET TIME_ZONE='+00:00'; SHOW CREATE TABLE mysql050614_temporal0; Table Create Table mysql050614_temporal0 CREATE TABLE `mysql050614_temporal0` ( `a` time DEFAULT NULL, `b` datetime DEFAULT NULL, - `c` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP + `c` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=MyISAM DEFAULT CHARSET=latin1 SHOW CREATE TABLE mysql050614_temporal1; Table Create Table mysql050614_temporal1 CREATE TABLE `mysql050614_temporal1` ( `a` time(1) DEFAULT NULL, `b` datetime(1) DEFAULT NULL, - `c` timestamp(1) NOT NULL DEFAULT CURRENT_TIMESTAMP(1) ON UPDATE CURRENT_TIMESTAMP(1) + `c` timestamp(1) NOT NULL DEFAULT current_timestamp(1) ON UPDATE current_timestamp(1) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 +connection slave; SELECT @@mysql56_temporal_format; @@mysql56_temporal_format 0 SET TIME_ZONE='+00:00'; CREATE TABLE mysql050614_temporal0 (a time(0), b datetime(0), c timestamp(0)) engine=myisam; CREATE TABLE mysql050614_temporal1 (a time(1), b datetime(1), c timestamp(1)) engine=myisam; +connection master; INSERT INTO mysql050614_temporal0 VALUES ('00:00:02','2001-01-01 00:00:02','2001-01-01 00:00:02'); INSERT INTO mysql050614_temporal1 VALUES ('00:00:02.1','2001-01-01 00:00:02.2','2001-01-01 00:00:02.3'); SELECT TABLE_NAME, TABLE_ROWS, AVG_ROW_LENGTH, DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES @@ -34,6 +39,8 @@ WHERE TABLE_NAME LIKE 'mysql050614_temporal%' ORDER BY TABLE_NAME; TABLE_NAME TABLE_ROWS AVG_ROW_LENGTH DATA_LENGTH mysql050614_temporal0 2 13 26 mysql050614_temporal1 1 16 16 +connection slave; +connection slave; SELECT * FROM mysql050614_temporal0; a b c 00:00:02 2001-01-01 00:00:02 2001-01-01 00:00:02 @@ -46,6 +53,7 @@ TABLE_NAME TABLE_ROWS AVG_ROW_LENGTH DATA_LENGTH mysql050614_temporal0 1 16 16 mysql050614_temporal1 1 16 16 SET @@global.mysql56_temporal_format=DEFAULT; +connection master; DROP TABLE mysql050614_temporal0; DROP TABLE mysql050614_temporal1; include/rpl_end.inc |