Debian Codegraph @

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

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