Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 SET @@global.mysql56_temporal_format=true;;
5 connection slave;
6 SET @@global.mysql56_temporal_format=false;;
7 connection master;
8 SELECT @@global.mysql56_temporal_format AS on_master;
9 on_master
10 1
11 connection slave;
12 SELECT @@global.mysql56_temporal_format AS on_slave;
13 on_slave
14 0
15 connection master;
16 CREATE TABLE t1
17 (
18 c0 TIME(0),
19 c1 TIME(1),
20 c2 TIME(2),
21 c3 TIME(3),
22 c4 TIME(4),
23 c5 TIME(5),
24 c6 TIME(6)
25 );
26 CREATE TABLE t2
27 (
28 c0 TIMESTAMP(0),
29 c1 TIMESTAMP(1),
30 c2 TIMESTAMP(2),
31 c3 TIMESTAMP(3),
32 c4 TIMESTAMP(4),
33 c5 TIMESTAMP(5),
34 c6 TIMESTAMP(6)
35 );
36 CREATE TABLE t3
37 (
38 c0 DATETIME(0),
39 c1 DATETIME(1),
40 c2 DATETIME(2),
41 c3 DATETIME(3),
42 c4 DATETIME(4),
43 c5 DATETIME(5),
44 c6 DATETIME(6)
45 );
46 INSERT INTO t1 VALUES ('01:01:01','01:01:01.1','01:01:01.11','01:01:01.111','01:01:01.1111','01:01:01.11111','01:01:01.111111');
47 INSERT INTO t2 VALUES ('2001-01-01 01:01:01','2001-01-01 01:01:01.1','2001-01-01 01:01:01.11','2001-01-01 01:01:01.111','2001-01-01 01:01:01.1111','2001-01-01 01:01:01.11111','2001-01-01 01:01:01.111111');
48 INSERT INTO t3 VALUES ('2001-01-01 01:01:01','2001-01-01 01:01:01.1','2001-01-01 01:01:01.11','2001-01-01 01:01:01.111','2001-01-01 01:01:01.1111','2001-01-01 01:01:01.11111','2001-01-01 01:01:01.111111');
49 SELECT TABLE_NAME, TABLE_ROWS, AVG_ROW_LENGTH,DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES
50 WHERE TABLE_NAME RLIKE 't[1-3]' ORDER BY TABLE_NAME;
51 TABLE_NAME TABLE_ROWS AVG_ROW_LENGTH DATA_LENGTH
52 t1 1 34 34
53 t2 1 41 41
54 t3 1 48 48
55 connection slave;
56 connection slave;
57 SELECT * FROM t1;;
58 c0 01:01:01
59 c1 01:01:01.1
60 c2 01:01:01.11
61 c3 01:01:01.111
62 c4 01:01:01.1111
63 c5 01:01:01.11111
64 c6 01:01:01.111111
65 SELECT * FROM t2;;
66 c0 2001-01-01 01:01:01
67 c1 2001-01-01 01:01:01.1
68 c2 2001-01-01 01:01:01.11
69 c3 2001-01-01 01:01:01.111
70 c4 2001-01-01 01:01:01.1111
71 c5 2001-01-01 01:01:01.11111
72 c6 2001-01-01 01:01:01.111111
73 SELECT * FROM t3;;
74 c0 2001-01-01 01:01:01
75 c1 2001-01-01 01:01:01.1
76 c2 2001-01-01 01:01:01.11
77 c3 2001-01-01 01:01:01.111
78 c4 2001-01-01 01:01:01.1111
79 c5 2001-01-01 01:01:01.11111
80 c6 2001-01-01 01:01:01.111111
81 SELECT TABLE_NAME, TABLE_ROWS, AVG_ROW_LENGTH,DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES
82 WHERE TABLE_NAME RLIKE 't[1-3]' ORDER BY TABLE_NAME;
83 TABLE_NAME TABLE_ROWS AVG_ROW_LENGTH DATA_LENGTH
84 t1 1 33 33
85 t2 1 41 41
86 t3 1 50 50
87 connection master;
88 DROP TABLE t1;
89 DROP TABLE t2;
90 DROP TABLE t3;
91 connection slave;
92 SET @@global.mysql56_temporal_format=DEFAULT;
93 connection master;
94 SET @@global.mysql56_temporal_format=DEFAULT;
95 include/rpl_end.inc