Debian Codegraph @

mysql-test/suite/rpl/r/rpl_temporal_mysql56_to_mariadb.result

raw
1 include/master-slave.inc
2 [connection master]
3 #
4 # Testing replication from MariaDB-10.0 master
5 # started over MySQL-5.6 data directory
6 # to MariaDB-10.0 slave running with natively created tables
7 #
8 connection master;
9 SET TIME_ZONE='+00:00';
10 SHOW CREATE TABLE mysql050614_temporal0;
11 Table Create Table
12 mysql050614_temporal0 CREATE TABLE `mysql050614_temporal0` (
13 `a` time DEFAULT NULL,
14 `b` datetime DEFAULT NULL,
15 `c` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
16 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
17 SHOW CREATE TABLE mysql050614_temporal1;
18 Table Create Table
19 mysql050614_temporal1 CREATE TABLE `mysql050614_temporal1` (
20 `a` time(1) DEFAULT NULL,
21 `b` datetime(1) DEFAULT NULL,
22 `c` timestamp(1) NOT NULL DEFAULT current_timestamp(1) ON UPDATE current_timestamp(1)
23 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
24 connection slave;
25 SELECT @@mysql56_temporal_format;
26 @@mysql56_temporal_format
27 1
28 SET TIME_ZONE='+00:00';
29 CREATE TABLE mysql050614_temporal0 (a time(0), b datetime(0), c timestamp(0)) engine=myisam;
30 CREATE TABLE mysql050614_temporal1 (a time(1), b datetime(1), c timestamp(1)) engine=myisam;
31 connection master;
32 INSERT INTO mysql050614_temporal0 VALUES ('00:00:02','2001-01-01 00:00:02','2001-01-01 00:00:02');
33 INSERT INTO mysql050614_temporal1 VALUES ('00:00:02.1','2001-01-01 00:00:02.2','2001-01-01 00:00:02.3');
34 SELECT TABLE_NAME, TABLE_ROWS, AVG_ROW_LENGTH, DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES
35 WHERE TABLE_NAME LIKE 'mysql050614_temporal%' ORDER BY TABLE_NAME;
36 TABLE_NAME TABLE_ROWS AVG_ROW_LENGTH DATA_LENGTH
37 mysql050614_temporal0 2 13 26
38 mysql050614_temporal1 1 16 16
39 connection slave;
40 connection slave;
41 SELECT * FROM mysql050614_temporal0;
42 a b c
43 00:00:02 2001-01-01 00:00:02 2001-01-01 00:00:02
44 SELECT * FROM mysql050614_temporal1;
45 a b c
46 00:00:02.1 2001-01-01 00:00:02.2 2001-01-01 00:00:02.3
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 TABLE_NAME TABLE_ROWS AVG_ROW_LENGTH DATA_LENGTH
50 mysql050614_temporal0 1 13 13
51 mysql050614_temporal1 1 16 16
52 SET @@global.mysql56_temporal_format=DEFAULT;
53 connection master;
54 DROP TABLE mysql050614_temporal0;
55 DROP TABLE mysql050614_temporal1;
56 include/rpl_end.inc