Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 SET TIME_ZONE='+00:00';
5 connection slave;
6 SET TIME_ZONE='+00:00';
7 connection master;
8 INSERT INTO mysql56time 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');
9 INSERT INTO mysql56datetime 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');
10 INSERT INTO mysql56timestamp 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');
11 connection slave;
12 connection slave;
13 SELECT * FROM mysql56time;
14 t0 838:59:59
15 t1 838:59:59.0
16 t2 838:59:59.00
17 t3 838:59:59.000
18 t4 838:59:59.0000
19 t5 838:59:59.00000
20 t6 838:59:59.000000
21 t0 00:00:00
22 t1 00:00:00.0
23 t2 00:00:00.00
24 t3 00:00:00.000
25 t4 00:00:00.0000
26 t5 00:00:00.00000
27 t6 00:00:00.000000
28 t0 -838:59:59
29 t1 -838:59:59.0
30 t2 -838:59:59.00
31 t3 -838:59:59.000
32 t4 -838:59:59.0000
33 t5 -838:59:59.00000
34 t6 -838:59:59.000000
35 t0 01:01:01
36 t1 01:01:01.1
37 t2 01:01:01.11
38 t3 01:01:01.111
39 t4 01:01:01.1111
40 t5 01:01:01.11111
41 t6 01:01:01.111111
42 SELECT * FROM mysql56datetime;
43 dt0 0000-00-00 00:00:00
44 dt1 0000-00-00 00:00:00.0
45 dt2 0000-00-00 00:00:00.00
46 dt3 0000-00-00 00:00:00.000
47 dt4 0000-00-00 00:00:00.0000
48 dt5 0000-00-00 00:00:00.00000
49 dt6 0000-00-00 00:00:00.000000
50 dt0 9999-12-31 23:59:59
51 dt1 9999-12-31 23:59:59.9
52 dt2 9999-12-31 23:59:59.99
53 dt3 9999-12-31 23:59:59.999
54 dt4 9999-12-31 23:59:59.9999
55 dt5 9999-12-31 23:59:59.99999
56 dt6 9999-12-31 23:59:59.999999
57 dt0 2001-01-01 01:01:01
58 dt1 2001-01-01 01:01:01.1
59 dt2 2001-01-01 01:01:01.11
60 dt3 2001-01-01 01:01:01.111
61 dt4 2001-01-01 01:01:01.1111
62 dt5 2001-01-01 01:01:01.11111
63 dt6 2001-01-01 01:01:01.111111
64 SELECT * FROM mysql56timestamp;
65 ts0 1970-01-01 00:00:01
66 ts1 1970-01-01 00:00:01.0
67 ts2 1970-01-01 00:00:01.00
68 ts3 1970-01-01 00:00:01.000
69 ts4 1970-01-01 00:00:01.0000
70 ts5 1970-01-01 00:00:01.00000
71 ts6 1970-01-01 00:00:01.000000
72 ts0 2038-01-19 03:14:07
73 ts1 2038-01-19 03:14:07.9
74 ts2 2038-01-19 03:14:07.99
75 ts3 2038-01-19 03:14:07.999
76 ts4 2038-01-19 03:14:07.9999
77 ts5 2038-01-19 03:14:07.99999
78 ts6 2038-01-19 03:14:07.999999
79 ts0 2001-01-01 01:01:01
80 ts1 2001-01-01 01:01:01.1
81 ts2 2001-01-01 01:01:01.11
82 ts3 2001-01-01 01:01:01.111
83 ts4 2001-01-01 01:01:01.1111
84 ts5 2001-01-01 01:01:01.11111
85 ts6 2001-01-01 01:01:01.111111
86 connection master;
87 DROP TABLE mysql56time;
88 DROP TABLE mysql56datetime;
89 DROP TABLE mysql56timestamp;
90 include/rpl_end.inc