Debian Codegraph @

mysql-test/suite/sys_vars/r/time_zone_func.result

raw
1 ** Setup **
2
3 SET @session_time_zone = @@SESSION.time_zone;
4 SET @global_time_zone = @@GLOBAL.time_zone;
5 CREATE TABLE t1 (a datetime);
6 CREATE TABLE t2 (a timestamp);
7 '#-----------------------------FN_DYNVARS_177_01--------------------#'
8 SET @@time_zone = DEFAULT;
9 SELECT @@time_zone;
10 @@time_zone
11 SYSTEM
12 SYSTEM Expected
13 '#-----------------------------FN_DYNVARS_177_02-------------------#'
14 SET @@time_zone = '+05:00';
15 SELECT @@time_zone;
16 @@time_zone
17 +05:00
18 +05:00 Expected
19 SET @@time_zone = '-01:00';
20 SELECT @@time_zone;
21 @@time_zone
22 -01:00
23 -01:00 Expected
24 SET @@time_zone = '+00:00';
25 SELECT @@time_zone;
26 @@time_zone
27 +00:00
28 +00:00 Expected
29 SET @@time_zone = '-00:00';
30 SELECT @@time_zone;
31 @@time_zone
32 +00:00
33 -00:00 Expected
34 '#-----------------------------FN_DYNVARS_177_03----------------#'
35 SET @@time_zone = '+00:00';
36 INSERT INTO t1 VALUES('2008-03-05 16:28:00');
37 INSERT INTO t1 VALUES('1970-01-01 00:05:00'),('1970-01-01 01:05:00');
38 INSERT INTO t2 VALUES(20080305162800);
39 INSERT INTO t2 VALUES(19730101235900);
40 INSERT INTO t2 VALUES('1970-01-01 00:05:00'),('1970-01-01 01:05:00');
41 INSERT INTO t2 VALUES(19700101000500);
42 SELECT a,UNIX_TIMESTAMP(a) FROM t1;
43 a UNIX_TIMESTAMP(a)
44 2008-03-05 16:28:00 1204734480
45 1970-01-01 00:05:00 300
46 1970-01-01 01:05:00 3900
47 SELECT a,UNIX_TIMESTAMP(a) FROM t2;
48 a UNIX_TIMESTAMP(a)
49 2008-03-05 16:28:00 1204734480
50 1973-01-01 23:59:00 94780740
51 1970-01-01 00:05:00 300
52 1970-01-01 01:05:00 3900
53 1970-01-01 00:05:00 300
54 SET @@time_zone = 'MET';
55 SELECT a,UNIX_TIMESTAMP(a) FROM t1;
56 a UNIX_TIMESTAMP(a)
57 2008-03-05 16:28:00 1204730880
58 1970-01-01 00:05:00 0
59 1970-01-01 01:05:00 300
60 SELECT a,UNIX_TIMESTAMP(a) FROM t2;
61 a UNIX_TIMESTAMP(a)
62 2008-03-05 17:28:00 1204734480
63 1973-01-02 00:59:00 94780740
64 1970-01-01 01:05:00 300
65 1970-01-01 02:05:00 3900
66 1970-01-01 01:05:00 300
67 SET @@time_zone = '+05:00';
68 SELECT a,UNIX_TIMESTAMP(a) FROM t1;
69 a UNIX_TIMESTAMP(a)
70 2008-03-05 16:28:00 1204716480
71 1970-01-01 00:05:00 0
72 1970-01-01 01:05:00 0
73 SELECT a,UNIX_TIMESTAMP(a) FROM t2;
74 a UNIX_TIMESTAMP(a)
75 2008-03-05 21:28:00 1204734480
76 1973-01-02 04:59:00 94780740
77 1970-01-01 05:05:00 300
78 1970-01-01 06:05:00 3900
79 1970-01-01 05:05:00 300
80 SET @@time_zone = '+06:00';
81 SELECT a,UNIX_TIMESTAMP(a) FROM t1;
82 a UNIX_TIMESTAMP(a)
83 2008-03-05 16:28:00 1204712880
84 1970-01-01 00:05:00 0
85 1970-01-01 01:05:00 0
86 SELECT a,UNIX_TIMESTAMP(a) FROM t2;
87 a UNIX_TIMESTAMP(a)
88 2008-03-05 22:28:00 1204734480
89 1973-01-02 05:59:00 94780740
90 1970-01-01 06:05:00 300
91 1970-01-01 07:05:00 3900
92 1970-01-01 06:05:00 300
93 SET @@time_zone = '+01:00';
94 SELECT a,UNIX_TIMESTAMP(a) FROM t1;
95 a UNIX_TIMESTAMP(a)
96 2008-03-05 16:28:00 1204730880
97 1970-01-01 00:05:00 0
98 1970-01-01 01:05:00 300
99 SELECT a,UNIX_TIMESTAMP(a) FROM t2;
100 a UNIX_TIMESTAMP(a)
101 2008-03-05 17:28:00 1204734480
102 1973-01-02 00:59:00 94780740
103 1970-01-01 01:05:00 300
104 1970-01-01 02:05:00 3900
105 1970-01-01 01:05:00 300
106 SET @@time_zone = '+02:00';
107 SELECT a,UNIX_TIMESTAMP(a) FROM t1;
108 a UNIX_TIMESTAMP(a)
109 2008-03-05 16:28:00 1204727280
110 1970-01-01 00:05:00 0
111 1970-01-01 01:05:00 0
112 SELECT a,UNIX_TIMESTAMP(a) FROM t2;
113 a UNIX_TIMESTAMP(a)
114 2008-03-05 18:28:00 1204734480
115 1973-01-02 01:59:00 94780740
116 1970-01-01 02:05:00 300
117 1970-01-01 03:05:00 3900
118 1970-01-01 02:05:00 300
119 SET @@time_zone = '+00:00';
120 SELECT a,UNIX_TIMESTAMP(a) FROM t1;
121 a UNIX_TIMESTAMP(a)
122 2008-03-05 16:28:00 1204734480
123 1970-01-01 00:05:00 300
124 1970-01-01 01:05:00 3900
125 SELECT a,UNIX_TIMESTAMP(a) FROM t2;
126 a UNIX_TIMESTAMP(a)
127 2008-03-05 16:28:00 1204734480
128 1973-01-01 23:59:00 94780740
129 1970-01-01 00:05:00 300
130 1970-01-01 01:05:00 3900
131 1970-01-01 00:05:00 300
132 SET @@time_zone = '+06:00';
133 SELECT a,UNIX_TIMESTAMP(a) FROM t1;
134 a UNIX_TIMESTAMP(a)
135 2008-03-05 16:28:00 1204712880
136 1970-01-01 00:05:00 0
137 1970-01-01 01:05:00 0
138 SELECT a,UNIX_TIMESTAMP(a) FROM t2;
139 a UNIX_TIMESTAMP(a)
140 2008-03-05 22:28:00 1204734480
141 1973-01-02 05:59:00 94780740
142 1970-01-01 06:05:00 300
143 1970-01-01 07:05:00 3900
144 1970-01-01 06:05:00 300
145 Potential Feature: upon recovery of timezone,
146 the original value of the timestamp should be recovered.
147 '#-----------------------------FN_DYNVARS_177_04--------------------#'
148 SET @@time_zone = '6';
149 ERROR HY000: Unknown or incorrect time zone: '6'
150 '#-----------------------------FN_DYNVARS_177_05---------------#'
151 SET GLOBAL time_zone = 'SYSTEM';
152 ** Connecting con_int1 using root **
153 ** Connection con_int1 **
154 SELECT @@SESSION.time_zone;
155 @@SESSION.time_zone
156 SYSTEM
157 SYSTEM Expected
158 SET SESSION time_zone = '+05:00';
159 ** Connecting con_int2 using root **
160 ** Connection con_int2 **
161 SELECT @@SESSION.time_zone;
162 @@SESSION.time_zone
163 SYSTEM
164 SYSTEM Expected
165 SET SESSION time_zone = '-10:00';
166 ** Connection con_int2 **
167 SELECT @@SESSION.time_zone;
168 @@SESSION.time_zone
169 -10:00
170 -10:00 Expected
171 ** Connection con_int1 **
172 SELECT @@SESSION.time_zone;
173 @@SESSION.time_zone
174 +05:00
175 +05:00 Expected
176 SELECT @@GLOBAL.time_zone;
177 @@GLOBAL.time_zone
178 SYSTEM
179 SYSTEM Expected
180 ** Connection default **
181 Disconnecting Connections con_int1, con_int2
182 SET @@SESSION.time_zone = @session_time_zone;
183 SET @@GLOBAL.time_zone = @global_time_zone;
184 DROP TABLE t1;
185 DROP TABLE t2;