Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 SET sql_mode=TIME_ROUND_FRACTIONAL;
4 SET time_zone='+00:00';
5 SET timestamp=UNIX_TIMESTAMP('2010-12-31 23:59:59.999999');
6 CREATE TABLE t1 (id SERIAL, a TIMESTAMP(4));
7 INSERT INTO t1 (a) VALUES (now(6));
8 INSERT INTO t1 (a) VALUES ('2011-01-01 23:59:59.999999');
9 CREATE TABLE t2 (id SERIAL, a DATETIME(4));
10 INSERT INTO t2 (a) VALUES (now(6));
11 INSERT INTO t2 (a) VALUES ('2011-01-01 23:59:59.999999');
12 CREATE TABLE t3 (id SERIAL, a TIME(4));
13 INSERT INTO t3 (a) VALUES (now(6));
14 Warnings:
15 Note 1265 Data truncated for column 'a' at row 1
16 INSERT INTO t3 (a) VALUES ('2011-01-01 23:59:59.999999');
17 Warnings:
18 Note 1265 Data truncated for column 'a' at row 1
19 SELECT * FROM t1;
20 id a
21 1 2011-01-01 00:00:00.0000
22 2 2011-01-02 00:00:00.0000
23 SELECT * FROM t2;
24 id a
25 1 2011-01-01 00:00:00.0000
26 2 2011-01-02 00:00:00.0000
27 SELECT * FROM t3;
28 id a
29 1 24:00:00.0000
30 2 24:00:00.0000
31 connection slave;
32 connection slave;
33 SET time_zone='+00:00';
34 SELECT * FROM t1;
35 id a
36 1 2011-01-01 00:00:00.0000
37 2 2011-01-02 00:00:00.0000
38 SELECT * FROM t2;
39 id a
40 1 2011-01-01 00:00:00.0000
41 2 2011-01-02 00:00:00.0000
42 SELECT * FROM t3;
43 id a
44 1 24:00:00.0000
45 2 24:00:00.0000
46 connection master;
47 DROP TABLE t1;
48 DROP TABLE t2;
49 DROP TABLE t3;
50 include/rpl_end.inc