1SET @global_start_value = @@global.time_zone;
2SELECT @global_start_value;
3@global_start_value
4SYSTEM
5SET @session_start_value = @@session.time_zone;
6SELECT @session_start_value;
7@session_start_value
8SYSTEM
9'#--------------------FN_DYNVARS_001_01------------------------#'
10SET @@time_zone = "+02:00";
11SET @@time_zone = DEFAULT;
12SELECT @@time_zone;
13@@time_zone
14SYSTEM
15SET @@global.time_zone = "-00:30";
16SET @@global.time_zone = DEFAULT;
17SELECT @@global.time_zone;
18@@global.time_zone
19SYSTEM
20'#---------------------FN_DYNVARS_001_02-------------------------#'
21SET @@session.time_zone = "+02:00";
22SELECT @@session.time_zone;
23@@session.time_zone
24+02:00
25SET @@global.time_zone = "+05:00";
26SELECT @@global.time_zone;
27@@global.time_zone
28+05:00
29SELECT @@session.time_zone AS res_is_02_00;
30res_is_02_00
31+02:00
32SET @@session.time_zone = "-02:00";
33SELECT @@session.time_zone;
34@@session.time_zone
35-02:00
36SELECT @@global.time_zone AS res_is_05_00;
37res_is_05_00
38+05:00
39SELECT @@global.time_zone=@@session.time_zone AS res_is_false;
40res_is_false
410
42'#--------------------FN_DYNVARS_001_03------------------------#'
43SET @@time_zone = "+13:00";
44SELECT @@time_zone;
45@@time_zone
46+13:00
47SET @@time_zone = "-12:00";
48SELECT @@time_zone;
49@@time_zone
50-12:00
51SET @@time_zone = "+12:59";
52SELECT @@time_zone;
53@@time_zone
54+12:59
55SET @@time_zone = "-11:30";
56SELECT @@time_zone;
57@@time_zone
58-11:30
59SET @@time_zone = "+00:00";
60SELECT @@time_zone;
61@@time_zone
62+00:00
63SET @@time_zone = "-12:59";
64SELECT @@time_zone;
65@@time_zone
66-12:59
67SET @@time_zone = "-00:00";
68SELECT @@time_zone;
69@@time_zone
70+00:00
71SET @@time_zone = "+10:00";
72SELECT @@time_zone;
73@@time_zone
74+10:00
75SET @@time_zone = "+0:0";
76SELECT @@time_zone;
77@@time_zone
78+00:00
79SET @@time_zone = "-10:00";
80SELECT @@time_zone;
81@@time_zone
82-10:00
83SET @@time_zone = "+2:00";
84SELECT @@time_zone;
85@@time_zone
86+02:00
87SET @@global.time_zone = "+13:00";
88SELECT @@global.time_zone;
89@@global.time_zone
90+13:00
91SET @@global.time_zone = "-12:00";
92SELECT @@global.time_zone;
93@@global.time_zone
94-12:00
95SET @@global.time_zone = "+12:59";
96SELECT @@global.time_zone;
97@@global.time_zone
98+12:59
99SET @@global.time_zone = "-11:30";
100SELECT @@global.time_zone;
101@@global.time_zone
102-11:30
103SET @@global.time_zone = "+00:00";
104SELECT @@global.time_zone;
105@@global.time_zone
106+00:00
107SET @@global.time_zone = "-12:59";
108SELECT @@global.time_zone;
109@@global.time_zone
110-12:59
111SET @@global.time_zone = "-00:00";
112SELECT @@global.time_zone;
113@@global.time_zone
114+00:00
115SET @@global.time_zone = "+10:00";
116SELECT @@global.time_zone;
117@@global.time_zone
118+10:00
119SET @@global.time_zone = "+0:0";
120SELECT @@global.time_zone;
121@@global.time_zone
122+00:00
123SET @@global.time_zone = "-10:00";
124SELECT @@global.time_zone;
125@@global.time_zone
126-10:00
127SET @@global.time_zone = "+2:00";
128SELECT @@global.time_zone;
129@@global.time_zone
130+02:00
131'#--------------------FN_DYNVARS_001_04-------------------------#'
132SET @@time_zone = "+24:00";
133ERROR HY000: Unknown or incorrect time zone: '+24:00'
134SET @@time_zone = "+23:59";
135ERROR HY000: Unknown or incorrect time zone: '+23:59'
136SET @@time_zone = "+13:01";
137ERROR HY000: Unknown or incorrect time zone: '+13:01'
138SET @@time_zone = "-13:01";
139ERROR HY000: Unknown or incorrect time zone: '-13:01'
140SET @@global.time_zone = "+24:00";
141ERROR HY000: Unknown or incorrect time zone: '+24:00'
142SET @@global.time_zone = "+23:59";
143ERROR HY000: Unknown or incorrect time zone: '+23:59'
144SET @@global.time_zone = "+13:01";
145ERROR HY000: Unknown or incorrect time zone: '+13:01'
146SET @@global.time_zone = "-13:01";
147ERROR HY000: Unknown or incorrect time zone: '-13:01'
148'#-------------------FN_DYNVARS_001_05----------------------------#'
149SET @@global.time_zone = 'SYSTEM';
150SELECT @@global.time_zone;
151@@global.time_zone
152SYSTEM
153SET @@time_zone = 'SYSTEM';
154SELECT @@time_zone;
155@@time_zone
156SYSTEM
157'#----------------------FN_DYNVARS_001_06------------------------#'
158SELECT @@time_zone = VARIABLE_VALUE
159FROM INFORMATION_SCHEMA.SESSION_VARIABLES
160WHERE VARIABLE_NAME='time_zone';
161@@time_zone = VARIABLE_VALUE
1621
163'#----------------------FN_DYNVARS_001_07------------------------#'
164SELECT @@global.time_zone = VARIABLE_VALUE
165FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
166WHERE VARIABLE_NAME='time_zone';
167@@global.time_zone = VARIABLE_VALUE
1681
169'#---------------------FN_DYNVARS_001_08-------------------------#'
170SET @@time_zone = OFF;
171ERROR HY000: Unknown or incorrect time zone: 'OFF'
172SET @@time_zone = ON;
173ERROR HY000: Unknown or incorrect time zone: 'ON'
174SET @@time_zone = TRUE;
175ERROR 42000: Incorrect argument type to variable 'time_zone'
176SET @@time_zone = FALSE;
177ERROR 42000: Incorrect argument type to variable 'time_zone'
178SET @@global.time_zone = OFF;
179ERROR HY000: Unknown or incorrect time zone: 'OFF'
180SET @@global.time_zone = ON;
181ERROR HY000: Unknown or incorrect time zone: 'ON'
182SET @@global.time_zone = TRUE;
183ERROR 42000: Incorrect argument type to variable 'time_zone'
184SET @@global.time_zone = FALSE;
185ERROR 42000: Incorrect argument type to variable 'time_zone'
186'#---------------------FN_DYNVARS_001_09----------------------#'
187SET @@time_zone = 1;
188ERROR 42000: Incorrect argument type to variable 'time_zone'
189SET @@time_zone = +0200;
190ERROR 42000: Incorrect argument type to variable 'time_zone'
191SET @@time_zone = GMT+;
192ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
193SET @@time_zone = "";
194ERROR HY000: Unknown or incorrect time zone: ''
195SET @@global.time_zone = 1;
196ERROR 42000: Incorrect argument type to variable 'time_zone'
197SET @@global.time_zone = +0200;
198ERROR 42000: Incorrect argument type to variable 'time_zone'
199SET @@global.time_zone = GMT+;
200ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
201SET @@global.time_zone = "";
202ERROR HY000: Unknown or incorrect time zone: ''
203'#---------------------FN_DYNVARS_001_10----------------------#'
204SET @@time_zone = '+02:30';
205SELECT @@time_zone = @@local.time_zone and @@time_zone = @@session.time_zone;
206@@time_zone = @@local.time_zone and @@time_zone = @@session.time_zone
2071
208SET @@time_zone = '-01:30';
209SELECT @@time_zone = @@local.time_zone and @@time_zone = @@session.time_zone;
210@@time_zone = @@local.time_zone and @@time_zone = @@session.time_zone
2111
212'#---------------------FN_DYNVARS_001_11----------------------#'
213SET time_zone = "+01:00";
214SELECT @@time_zone;
215@@time_zone
216+01:00
217SELECT local.time_zone;
218ERROR 42S02: Unknown table 'local' in field list
219SELECT session.time_zone;
220ERROR 42S02: Unknown table 'session' in field list
221SELECT time_zone = @@session.time_zone;
222ERROR 42S22: Unknown column 'time_zone' in 'field list'
223SET @@time_zone = @session_start_value;
224SELECT @@time_zone;
225@@time_zone
226SYSTEM
227SET @@global.time_zone = @global_start_value;
228SELECT @@global.time_zone;
229@@global.time_zone
230SYSTEM
231