Debian Codegraph @

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

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 SET @@time_zone='+00:00';
7 SET @@timestamp=25810.123456;
8 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
9 CREATE TABLE t1
10 (
11 ts0 TIMESTAMP(0),
12 ts1 TIMESTAMP(1),
13 ts2 TIMESTAMP(2),
14 ts3 TIMESTAMP(3),
15 ts4 TIMESTAMP(4),
16 ts5 TIMESTAMP(5),
17 ts6 TIMESTAMP(6)
18 );
19 SET sql_mode = default;
20 SET @ts='2001-01-01 10:10:10.123456';
21 INSERT INTO t1 VALUES (@ts, @ts, @ts, @ts, @ts, @ts, @ts);
22 INSERT INTO t1 VALUES (NOW(), NOW(), NOW(), NOW(), NOW(), NOW(), NOW());
23 INSERT INTO t1 VALUES (NOW(6), NOW(6), NOW(6), NOW(6), NOW(6), NOW(6), NOW(6));
24 SELECT * FROM t1;
25 ts0 2001-01-01 10:10:10
26 ts1 2001-01-01 10:10:10.1
27 ts2 2001-01-01 10:10:10.12
28 ts3 2001-01-01 10:10:10.123
29 ts4 2001-01-01 10:10:10.1235
30 ts5 2001-01-01 10:10:10.12346
31 ts6 2001-01-01 10:10:10.123456
32 ts0 1970-01-01 07:10:10
33 ts1 1970-01-01 07:10:10.0
34 ts2 1970-01-01 07:10:10.00
35 ts3 1970-01-01 07:10:10.000
36 ts4 1970-01-01 07:10:10.0000
37 ts5 1970-01-01 07:10:10.00000
38 ts6 1970-01-01 07:10:10.000000
39 ts0 1970-01-01 07:10:10
40 ts1 1970-01-01 07:10:10.1
41 ts2 1970-01-01 07:10:10.12
42 ts3 1970-01-01 07:10:10.123
43 ts4 1970-01-01 07:10:10.1235
44 ts5 1970-01-01 07:10:10.12346
45 ts6 1970-01-01 07:10:10.123456
46 include/sync_slave_sql_with_master.inc
47 SELECT * FROM t1;
48 ts0 2001-01-01 13:10:10
49 ts1 2001-01-01 13:10:10.1
50 ts2 2001-01-01 13:10:10.12
51 ts3 2001-01-01 13:10:10.123
52 ts4 2001-01-01 13:10:10.1235
53 ts5 2001-01-01 13:10:10.12346
54 ts6 2001-01-01 13:10:10.123456
55 ts0 1970-01-01 10:10:10
56 ts1 1970-01-01 10:10:10.0
57 ts2 1970-01-01 10:10:10.00
58 ts3 1970-01-01 10:10:10.000
59 ts4 1970-01-01 10:10:10.0000
60 ts5 1970-01-01 10:10:10.00000
61 ts6 1970-01-01 10:10:10.000000
62 ts0 1970-01-01 10:10:10
63 ts1 1970-01-01 10:10:10.1
64 ts2 1970-01-01 10:10:10.12
65 ts3 1970-01-01 10:10:10.123
66 ts4 1970-01-01 10:10:10.1235
67 ts5 1970-01-01 10:10:10.12346
68 ts6 1970-01-01 10:10:10.123456
69 DROP TABLE t1;
70 include/sync_slave_sql_with_master.inc
71 CREATE TABLE t1
72 (
73 dt0 DATETIME(0),
74 dt1 DATETIME(1),
75 dt2 DATETIME(2),
76 dt3 DATETIME(3),
77 dt4 DATETIME(4),
78 dt5 DATETIME(5),
79 dt6 DATETIME(6)
80 );
81 SET @ts='2001-01-01 10:10:10.123456';
82 INSERT INTO t1 VALUES (@ts, @ts, @ts, @ts, @ts, @ts, @ts);
83 INSERT INTO t1 VALUES (NOW(), NOW(), NOW(), NOW(), NOW(), NOW(), NOW());
84 INSERT INTO t1 VALUES (NOW(6), NOW(6), NOW(6), NOW(6), NOW(6), NOW(6), NOW(6));
85 SELECT * FROM t1;
86 dt0 2001-01-01 10:10:10
87 dt1 2001-01-01 10:10:10.1
88 dt2 2001-01-01 10:10:10.12
89 dt3 2001-01-01 10:10:10.123
90 dt4 2001-01-01 10:10:10.1235
91 dt5 2001-01-01 10:10:10.12346
92 dt6 2001-01-01 10:10:10.123456
93 dt0 1970-01-01 07:10:10
94 dt1 1970-01-01 07:10:10.0
95 dt2 1970-01-01 07:10:10.00
96 dt3 1970-01-01 07:10:10.000
97 dt4 1970-01-01 07:10:10.0000
98 dt5 1970-01-01 07:10:10.00000
99 dt6 1970-01-01 07:10:10.000000
100 dt0 1970-01-01 07:10:10
101 dt1 1970-01-01 07:10:10.1
102 dt2 1970-01-01 07:10:10.12
103 dt3 1970-01-01 07:10:10.123
104 dt4 1970-01-01 07:10:10.1235
105 dt5 1970-01-01 07:10:10.12346
106 dt6 1970-01-01 07:10:10.123456
107 include/sync_slave_sql_with_master.inc
108 SELECT * FROM t1;
109 dt0 2001-01-01 10:10:10
110 dt1 2001-01-01 10:10:10.1
111 dt2 2001-01-01 10:10:10.12
112 dt3 2001-01-01 10:10:10.123
113 dt4 2001-01-01 10:10:10.1235
114 dt5 2001-01-01 10:10:10.12346
115 dt6 2001-01-01 10:10:10.123456
116 dt0 1970-01-01 07:10:10
117 dt1 1970-01-01 07:10:10.0
118 dt2 1970-01-01 07:10:10.00
119 dt3 1970-01-01 07:10:10.000
120 dt4 1970-01-01 07:10:10.0000
121 dt5 1970-01-01 07:10:10.00000
122 dt6 1970-01-01 07:10:10.000000
123 dt0 1970-01-01 07:10:10
124 dt1 1970-01-01 07:10:10.1
125 dt2 1970-01-01 07:10:10.12
126 dt3 1970-01-01 07:10:10.123
127 dt4 1970-01-01 07:10:10.1235
128 dt5 1970-01-01 07:10:10.12346
129 dt6 1970-01-01 07:10:10.123456
130 DROP TABLE t1;
131 include/sync_slave_sql_with_master.inc
132 CREATE TABLE t1
133 (
134 t0 TIME(0),
135 t1 TIME(1),
136 t2 TIME(2),
137 t3 TIME(3),
138 t4 TIME(4),
139 t5 TIME(5),
140 t6 TIME(6)
141 );
142 SET @t='10:10:10.123456';
143 INSERT INTO t1 VALUES (@t, @t, @t, @t, @t, @t, @t);
144 INSERT INTO t1 VALUES (CURTIME(), CURTIME(), CURTIME(), CURTIME(), CURTIME(), CURTIME(), CURTIME());
145 INSERT INTO t1 VALUES (CURTIME(6), CURTIME(6), CURTIME(6), CURTIME(6), CURTIME(6), CURTIME(6), CURTIME(6));
146 SELECT * FROM t1;
147 t0 10:10:10
148 t1 10:10:10.1
149 t2 10:10:10.12
150 t3 10:10:10.123
151 t4 10:10:10.1235
152 t5 10:10:10.12346
153 t6 10:10:10.123456
154 t0 07:10:10
155 t1 07:10:10.0
156 t2 07:10:10.00
157 t3 07:10:10.000
158 t4 07:10:10.0000
159 t5 07:10:10.00000
160 t6 07:10:10.000000
161 t0 07:10:10
162 t1 07:10:10.1
163 t2 07:10:10.12
164 t3 07:10:10.123
165 t4 07:10:10.1235
166 t5 07:10:10.12346
167 t6 07:10:10.123456
168 include/sync_slave_sql_with_master.inc
169 SELECT * FROM t1;
170 t0 10:10:10
171 t1 10:10:10.1
172 t2 10:10:10.12
173 t3 10:10:10.123
174 t4 10:10:10.1235
175 t5 10:10:10.12346
176 t6 10:10:10.123456
177 t0 07:10:10
178 t1 07:10:10.0
179 t2 07:10:10.00
180 t3 07:10:10.000
181 t4 07:10:10.0000
182 t5 07:10:10.00000
183 t6 07:10:10.000000
184 t0 07:10:10
185 t1 07:10:10.1
186 t2 07:10:10.12
187 t3 07:10:10.123
188 t4 07:10:10.1235
189 t5 07:10:10.12346
190 t6 07:10:10.123456
191 DROP TABLE t1;
192 include/sync_slave_sql_with_master.inc
193 include/rpl_end.inc