Debian Codegraph @

mysql-test/suite/sys_vars/t/lc_time_names_basic.test

raw
1 ###################### mysql-test\t\lc_time_names_basic.test ##################
2 # #
3 # Variable Name: lc_time_names #
4 # Scope: GLOBAL | SESSION #
5 # Access Type: Dynamic #
6 # Data Type: string #
7 # Default Value: en_ZA #
8 # Range: NA #
9 # #
10 # #
11 # Creation Date: 2008-02-07 #
12 # Author: Rizwan #
13 # #
14 # Description: Test Cases of Dynamic System Variable lc_time_names #
15 # that checks the behavior of this variable in the following ways#
16 # * Default Value #
17 # * Valid & Invalid values #
18 # * Scope & Access method #
19 # * Data Integrity #
20 # #
21 # Reference: http://dev.mysql.com/doc/refman/5.1/en/ #
22 # server-system-variables.html #
23 # #
24 ###############################################################################
25
26 --source include/load_sysvars.inc
27 ###################################################
28 ## START OF lc_time_names TESTS ##
29 ###################################################
30
31 #############################################################
32 # Save initial value #
33 #############################################################
34
35 SET @global_start_value = @@global.lc_time_names;
36 SELECT @global_start_value;
37 # Save initial session value
38 SET @session_start_value = @@lc_time_names;
39 SELECT @session_start_value;
40 # now save using local access
41 SET @session_start_value = @@local.lc_time_names;
42 SELECT @session_start_value;
43 # save using default access (session)
44 SET @session_start_value = @@session.lc_time_names;
45 SELECT @session_start_value;
46
47
48 --echo '#--------------------FN_DYNVARS_060_01------------------#'
49 ###############################################################################
50 # Test Variable access and assignment with and withoud @@ #
51 ###############################################################################
52
53 # select without @@
54 --error ER_BAD_FIELD_ERROR
55 SELECT lc_time_names;
56 # assign value without @@
57 SET lc_time_names=ar_AE;
58 SELECT @@session.lc_time_names;
59 # assign global variable without @@
60 --Error ER_PARSE_ERROR
61 SET global.lc_time_names=ar_AE;
62 # using another syntax for accessing session variable
63 SET session lc_time_names=ar_AE;
64 # accessing variable with scope the wrong way
65 --Error ER_BAD_FIELD_ERROR
66 SELECT session lc_time_names;
67 # using another syntax for accessing dynamic variable
68 SET global lc_time_names=ar_AE;
69 --Error ER_BAD_FIELD_ERROR
70 SELECT global lc_time_names;
71
72
73 --echo '#--------------------FN_DYNVARS_060_02-------------------------#'
74 ###############################################################################
75 # Check the DEFAULT value of lc_time_names for session and global #
76 ###############################################################################
77
78 SET @@lc_time_names = en_ZA;
79 SET @@lc_time_names = DEFAULT;
80 SELECT @@lc_time_names AS DEFAULT_VALUE;
81
82 SET @@global.lc_time_names = en_ZA;
83 SET @@global.lc_time_names = DEFAULT;
84 SELECT @@global.lc_time_names;
85
86 --echo '#--------------------FN_DYNVARS_060_03-------------------------#'
87 ##########################################################################
88 # see if setting global value changes session value and vice versa #
89 ##########################################################################
90
91 SET @@session.lc_time_names = en_IN;
92 SELECT @@session.lc_time_names;
93 SET @@global.lc_time_names = en_NZ;
94 SELECT @@global.lc_time_names;
95 SELECT @@session.lc_time_names AS res_is_en_IN;
96
97 SET @@session.lc_time_names = en_AU;
98 SELECT @@session.lc_time_names;
99 SELECT @@global.lc_time_names AS res_is_en_NZ;
100 # composite check
101 SELECT @@global.lc_time_names=@@session.lc_time_names AS res_is_false;
102
103
104 --echo '#--------------------FN_DYNVARS_060_04-------------------------#'
105 ###########################################################################
106 # Check if accessing variable with and without session point to session
107 # variable
108 ###########################################################################
109
110 SELECT @@lc_time_names = @@session.lc_time_names AS res;
111 SELECT @@lc_time_names = @@local.lc_time_names AS res;
112
113 --echo '#--------------------FN_DYNVARS_060_05-------------------------#'
114 ###########################################################################
115 # Check if combining character set works #
116 ###########################################################################
117 --Error ER_BAD_FIELD_ERROR
118 SET @@lc_time_names = en_US | en_GB ;
119
120 --echo '#--------------------FN_DYNVARS_060_06-------------------------#'
121 ###########################################################################
122 # Change the value of lc_time_names to a valid value for session #
123 ###########################################################################
124 SET @@session.lc_time_names=ar_AE;
125 SELECT @@session.lc_time_names;
126 SET @@session.lc_time_names=ar_BH;
127 SELECT @@session.lc_time_names;
128 SET @@session.lc_time_names=ar_DZ;
129 SELECT @@session.lc_time_names;
130 SET @@session.lc_time_names=ar_EG;
131 SELECT @@session.lc_time_names;
132 SET @@session.lc_time_names=ar_IN;
133 SELECT @@session.lc_time_names;
134 SET @@session.lc_time_names=ar_IQ;
135 SELECT @@session.lc_time_names;
136 SET @@session.lc_time_names=ar_JO;
137 SELECT @@session.lc_time_names;
138 SET @@session.lc_time_names=ar_KW;
139 SELECT @@session.lc_time_names;
140 SET @@session.lc_time_names=ar_LB;
141 SELECT @@session.lc_time_names;
142 SET @@session.lc_time_names=ar_LY;
143 SELECT @@session.lc_time_names;
144 SET @@session.lc_time_names=ar_MA;
145 SELECT @@session.lc_time_names;
146 SET @@session.lc_time_names=ar_OM;
147 SELECT @@session.lc_time_names;
148 SET @@session.lc_time_names=ar_QA;
149 SELECT @@session.lc_time_names;
150 SET @@session.lc_time_names=ar_SA;
151 SELECT @@session.lc_time_names;
152 SET @@session.lc_time_names=ar_SD;
153 SELECT @@session.lc_time_names;
154 SET @@session.lc_time_names=ar_SY;
155 SELECT @@session.lc_time_names;
156 SET @@session.lc_time_names=ar_TN;
157 SELECT @@session.lc_time_names;
158 SET @@session.lc_time_names=ar_YE;
159 SELECT @@session.lc_time_names;
160 SET @@session.lc_time_names=be_BY;
161 SELECT @@session.lc_time_names;
162 SET @@session.lc_time_names=bg_BG;
163 SELECT @@session.lc_time_names;
164 SET @@session.lc_time_names=ca_ES;
165 SELECT @@session.lc_time_names;
166 SET @@session.lc_time_names=cs_CZ;
167 SELECT @@session.lc_time_names;
168 SET @@session.lc_time_names=da_DK;
169 SELECT @@session.lc_time_names;
170 SET @@session.lc_time_names=de_AT;
171 SELECT @@session.lc_time_names;
172 SET @@session.lc_time_names=de_BE;
173 SELECT @@session.lc_time_names;
174 SET @@session.lc_time_names=de_CH;
175 SELECT @@session.lc_time_names;
176 SET @@session.lc_time_names=de_DE;
177 SELECT @@session.lc_time_names;
178 SET @@session.lc_time_names=de_LU;
179 SELECT @@session.lc_time_names;
180
181 --error ER_UNKNOWN_LOCALE
182 SET @@session.lc_time_names=EE;
183 --echo 'Bug: The locale for Estonian - Estonia is not supported. It is present';
184 --echo 'in manual';
185 --echo 'See http://dev.mysql.com/doc/refman/5.1/en/locale-support.html'
186
187 SET @@session.lc_time_names=en_AU;
188 SELECT @@session.lc_time_names;
189 SET @@session.lc_time_names=en_CA;
190 SELECT @@session.lc_time_names;
191 SET @@session.lc_time_names=en_GB;
192 SELECT @@session.lc_time_names;
193 SET @@session.lc_time_names=en_IN;
194 SELECT @@session.lc_time_names;
195 SET @@session.lc_time_names=en_NZ;
196 SELECT @@session.lc_time_names;
197 SET @@session.lc_time_names=en_PH;
198 SELECT @@session.lc_time_names;
199 SET @@session.lc_time_names=en_US;
200 SELECT @@session.lc_time_names;
201 SET @@session.lc_time_names=en_ZA;
202 SELECT @@session.lc_time_names;
203 SET @@session.lc_time_names=en_ZW;
204 SELECT @@session.lc_time_names;
205 SET @@session.lc_time_names=es_AR;
206 SELECT @@session.lc_time_names;
207 SET @@session.lc_time_names=es_BO;
208 SELECT @@session.lc_time_names;
209 SET @@session.lc_time_names=es_CL;
210 SELECT @@session.lc_time_names;
211 SET @@session.lc_time_names=es_CO;
212 SELECT @@session.lc_time_names;
213 SET @@session.lc_time_names=es_CR;
214 SELECT @@session.lc_time_names;
215 SET @@session.lc_time_names=es_DO;
216 SELECT @@session.lc_time_names;
217 SET @@session.lc_time_names=es_EC;
218 SELECT @@session.lc_time_names;
219 SET @@session.lc_time_names=es_ES;
220 SELECT @@session.lc_time_names;
221 SET @@session.lc_time_names=es_GT;
222 SELECT @@session.lc_time_names;
223 SET @@session.lc_time_names=es_HN;
224 SELECT @@session.lc_time_names;
225 SET @@session.lc_time_names=es_MX;
226 SELECT @@session.lc_time_names;
227 SET @@session.lc_time_names=es_NI;
228 SELECT @@session.lc_time_names;
229 SET @@session.lc_time_names=es_PA;
230 SELECT @@session.lc_time_names;
231 SET @@session.lc_time_names=es_PE;
232 SELECT @@session.lc_time_names;
233 SET @@session.lc_time_names=es_PR;
234 SELECT @@session.lc_time_names;
235 SET @@session.lc_time_names=es_PY;
236 SELECT @@session.lc_time_names;
237 SET @@session.lc_time_names=es_SV;
238 SELECT @@session.lc_time_names;
239 SET @@session.lc_time_names=es_US;
240 SELECT @@session.lc_time_names;
241 SET @@session.lc_time_names=es_UY;
242 SELECT @@session.lc_time_names;
243 SET @@session.lc_time_names=es_VE;
244 SELECT @@session.lc_time_names;
245 SET @@session.lc_time_names=eu_ES;
246 SELECT @@session.lc_time_names;
247 SET @@session.lc_time_names=fi_FI;
248 SELECT @@session.lc_time_names;
249 SET @@session.lc_time_names=fo_FO;
250 SELECT @@session.lc_time_names;
251 SET @@session.lc_time_names=fr_BE;
252 SELECT @@session.lc_time_names;
253 SET @@session.lc_time_names=fr_CA;
254 SELECT @@session.lc_time_names;
255 SET @@session.lc_time_names=fr_CH;
256 SELECT @@session.lc_time_names;
257 SET @@session.lc_time_names=fr_FR;
258 SELECT @@session.lc_time_names;
259 SET @@session.lc_time_names=fr_LU;
260 SELECT @@session.lc_time_names;
261 SET @@session.lc_time_names=gl_ES;
262 SELECT @@session.lc_time_names;
263 SET @@session.lc_time_names=gu_IN;
264 SELECT @@session.lc_time_names;
265 SET @@session.lc_time_names=he_IL;
266 SELECT @@session.lc_time_names;
267 SET @@session.lc_time_names=hi_IN;
268 SELECT @@session.lc_time_names;
269 SET @@session.lc_time_names=hr_HR;
270 SELECT @@session.lc_time_names;
271 SET @@session.lc_time_names=hu_HU;
272 SELECT @@session.lc_time_names;
273 SET @@session.lc_time_names=id_ID;
274 SELECT @@session.lc_time_names;
275 SET @@session.lc_time_names=is_IS;
276 SELECT @@session.lc_time_names;
277 SET @@session.lc_time_names=it_CH;
278 SELECT @@session.lc_time_names;
279 SET @@session.lc_time_names=it_IT;
280 SELECT @@session.lc_time_names;
281 SET @@session.lc_time_names=ja_JP;
282 SELECT @@session.lc_time_names;
283 SET @@session.lc_time_names=ko_KR;
284 SELECT @@session.lc_time_names;
285 SET @@session.lc_time_names=lt_LT;
286 SELECT @@session.lc_time_names;
287 SET @@session.lc_time_names=lv_LV;
288 SELECT @@session.lc_time_names;
289 SET @@session.lc_time_names=mk_MK;
290 SELECT @@session.lc_time_names;
291 SET @@session.lc_time_names=mn_MN;
292 SELECT @@session.lc_time_names;
293 SET @@session.lc_time_names=ms_MY;
294 SELECT @@session.lc_time_names;
295 SET @@session.lc_time_names=nb_NO;
296 SELECT @@session.lc_time_names;
297 SET @@session.lc_time_names=nl_BE;
298 SELECT @@session.lc_time_names;
299 SET @@session.lc_time_names=nl_NL;
300 SELECT @@session.lc_time_names;
301 SET @@session.lc_time_names=no_NO;
302 SELECT @@session.lc_time_names;
303 SET @@session.lc_time_names=pl_PL;
304 SELECT @@session.lc_time_names;
305 SET @@session.lc_time_names=pt_BR;
306 SELECT @@session.lc_time_names;
307 SET @@session.lc_time_names=pt_PT;
308 SELECT @@session.lc_time_names;
309 SET @@session.lc_time_names=ro_RO;
310 SELECT @@session.lc_time_names;
311 SET @@session.lc_time_names=ru_RU;
312 SELECT @@session.lc_time_names;
313 SET @@session.lc_time_names=ru_UA;
314 SELECT @@session.lc_time_names;
315 SET @@session.lc_time_names=sk_SK;
316 SELECT @@session.lc_time_names;
317 SET @@session.lc_time_names=sl_SI;
318 SELECT @@session.lc_time_names;
319 SET @@session.lc_time_names=sq_AL;
320 SELECT @@session.lc_time_names;
321 SET @@session.lc_time_names=sr_YU;
322 SELECT @@session.lc_time_names;
323 SET @@session.lc_time_names=sv_FI;
324 SELECT @@session.lc_time_names;
325 SET @@session.lc_time_names=sr_RS;
326 SELECT @@session.lc_time_names;
327 SET @@session.lc_time_names=sv_SE;
328 SELECT @@session.lc_time_names;
329 SET @@session.lc_time_names=ta_IN;
330 SELECT @@session.lc_time_names;
331 SET @@session.lc_time_names=te_IN;
332 SELECT @@session.lc_time_names;
333 SET @@session.lc_time_names=th_TH;
334 SELECT @@session.lc_time_names;
335 SET @@session.lc_time_names=tr_TR;
336 SELECT @@session.lc_time_names;
337 SET @@session.lc_time_names=uk_UA;
338 SELECT @@session.lc_time_names;
339 SET @@session.lc_time_names=ur_PK;
340 SELECT @@session.lc_time_names;
341 SET @@session.lc_time_names=vi_VN;
342 SELECT @@session.lc_time_names;
343 SET @@session.lc_time_names=zh_CN;
344 SELECT @@session.lc_time_names;
345 SET @@session.lc_time_names=zh_HK;
346 SELECT @@session.lc_time_names;
347 SET @@session.lc_time_names=zh_TW;
348 SELECT @@session.lc_time_names;
349
350
351 --echo '#--------------------FN_DYNVARS_060_07-------------------------#'
352 ##########################################################################
353 # Change the value of lc_time_names to a valid value for global #
354 ##########################################################################
355 SET @@global.lc_time_names=ar_AE;
356 SELECT @@global.lc_time_names;
357 SET @@global.lc_time_names=ar_BH;
358 SELECT @@global.lc_time_names;
359 SET @@global.lc_time_names=ar_DZ;
360 SELECT @@global.lc_time_names;
361 SET @@global.lc_time_names=ar_EG;
362 SELECT @@global.lc_time_names;
363 SET @@global.lc_time_names=ar_IN;
364 SELECT @@global.lc_time_names;
365 SET @@global.lc_time_names=ar_IQ;
366 SELECT @@global.lc_time_names;
367 SET @@global.lc_time_names=ar_JO;
368 SELECT @@global.lc_time_names;
369 SET @@global.lc_time_names=ar_KW;
370 SELECT @@global.lc_time_names;
371 SET @@global.lc_time_names=ar_LB;
372 SELECT @@global.lc_time_names;
373 SET @@global.lc_time_names=ar_LY;
374 SELECT @@global.lc_time_names;
375 SET @@global.lc_time_names=ar_MA;
376 SELECT @@global.lc_time_names;
377 SET @@global.lc_time_names=ar_OM;
378 SELECT @@global.lc_time_names;
379 SET @@global.lc_time_names=ar_QA;
380 SELECT @@global.lc_time_names;
381 SET @@global.lc_time_names=ar_SA;
382 SELECT @@global.lc_time_names;
383 SET @@global.lc_time_names=ar_SD;
384 SELECT @@global.lc_time_names;
385 SET @@global.lc_time_names=ar_SY;
386 SELECT @@global.lc_time_names;
387 SET @@global.lc_time_names=ar_TN;
388 SELECT @@global.lc_time_names;
389 SET @@global.lc_time_names=ar_YE;
390 SELECT @@global.lc_time_names;
391 SET @@global.lc_time_names=be_BY;
392 SELECT @@global.lc_time_names;
393 SET @@global.lc_time_names=bg_BG;
394 SELECT @@global.lc_time_names;
395 SET @@global.lc_time_names=ca_ES;
396 SELECT @@global.lc_time_names;
397 SET @@global.lc_time_names=cs_CZ;
398 SELECT @@global.lc_time_names;
399 SET @@global.lc_time_names=da_DK;
400 SELECT @@global.lc_time_names;
401 SET @@global.lc_time_names=de_AT;
402 SELECT @@global.lc_time_names;
403 SET @@global.lc_time_names=de_BE;
404 SELECT @@global.lc_time_names;
405 SET @@global.lc_time_names=de_CH;
406 SELECT @@global.lc_time_names;
407 SET @@global.lc_time_names=de_DE;
408 SELECT @@global.lc_time_names;
409 SET @@global.lc_time_names=de_LU;
410 SELECT @@global.lc_time_names;
411
412 --error ER_UNKNOWN_LOCALE
413 SET @@global.lc_time_names=EE;
414 --echo 'Bug: The locale for Estonian - Estonia is not supported. It is';
415 --echo 'present in manual';
416 --echo 'See http://dev.mysql.com/doc/refman/5.1/en/locale-support.html';
417
418
419 SELECT @@global.lc_time_names;
420 SET @@global.lc_time_names=en_AU;
421 SELECT @@global.lc_time_names;
422 SET @@global.lc_time_names=en_CA;
423 SELECT @@global.lc_time_names;
424 SET @@global.lc_time_names=en_GB;
425 SELECT @@global.lc_time_names;
426 SET @@global.lc_time_names=en_IN;
427 SELECT @@global.lc_time_names;
428 SET @@global.lc_time_names=en_NZ;
429 SELECT @@global.lc_time_names;
430 SET @@global.lc_time_names=en_PH;
431 SELECT @@global.lc_time_names;
432 SET @@global.lc_time_names=en_US;
433 SELECT @@global.lc_time_names;
434 SET @@global.lc_time_names=en_ZA;
435 SELECT @@global.lc_time_names;
436 SET @@global.lc_time_names=en_ZW;
437 SELECT @@global.lc_time_names;
438 SET @@global.lc_time_names=es_AR;
439 SELECT @@global.lc_time_names;
440 SET @@global.lc_time_names=es_BO;
441 SELECT @@global.lc_time_names;
442 SET @@global.lc_time_names=es_CL;
443 SELECT @@global.lc_time_names;
444 SET @@global.lc_time_names=es_CO;
445 SELECT @@global.lc_time_names;
446 SET @@global.lc_time_names=es_CR;
447 SELECT @@global.lc_time_names;
448 SET @@global.lc_time_names=es_DO;
449 SELECT @@global.lc_time_names;
450 SET @@global.lc_time_names=es_EC;
451 SELECT @@global.lc_time_names;
452 SET @@global.lc_time_names=es_ES;
453 SELECT @@global.lc_time_names;
454 SET @@global.lc_time_names=es_GT;
455 SELECT @@global.lc_time_names;
456 SET @@global.lc_time_names=es_HN;
457 SELECT @@global.lc_time_names;
458 SET @@global.lc_time_names=es_MX;
459 SELECT @@global.lc_time_names;
460 SET @@global.lc_time_names=es_NI;
461 SELECT @@global.lc_time_names;
462 SET @@global.lc_time_names=es_PA;
463 SELECT @@global.lc_time_names;
464 SET @@global.lc_time_names=es_PE;
465 SELECT @@global.lc_time_names;
466 SET @@global.lc_time_names=es_PR;
467 SELECT @@global.lc_time_names;
468 SET @@global.lc_time_names=es_PY;
469 SELECT @@global.lc_time_names;
470 SET @@global.lc_time_names=es_SV;
471 SELECT @@global.lc_time_names;
472 SET @@global.lc_time_names=es_US;
473 SELECT @@global.lc_time_names;
474 SET @@global.lc_time_names=es_UY;
475 SELECT @@global.lc_time_names;
476 SET @@global.lc_time_names=es_VE;
477 SELECT @@global.lc_time_names;
478 SET @@global.lc_time_names=eu_ES;
479 SELECT @@global.lc_time_names;
480 SET @@global.lc_time_names=fi_FI;
481 SELECT @@global.lc_time_names;
482 SET @@global.lc_time_names=fo_FO;
483 SELECT @@global.lc_time_names;
484 SET @@global.lc_time_names=fr_BE;
485 SELECT @@global.lc_time_names;
486 SET @@global.lc_time_names=fr_CA;
487 SELECT @@global.lc_time_names;
488 SET @@global.lc_time_names=fr_CH;
489 SELECT @@global.lc_time_names;
490 SET @@global.lc_time_names=fr_FR;
491 SELECT @@global.lc_time_names;
492 SET @@global.lc_time_names=fr_LU;
493 SELECT @@global.lc_time_names;
494 SET @@global.lc_time_names=gl_ES;
495 SELECT @@global.lc_time_names;
496 SET @@global.lc_time_names=gu_IN;
497 SELECT @@global.lc_time_names;
498 SET @@global.lc_time_names=he_IL;
499 SELECT @@global.lc_time_names;
500 SET @@global.lc_time_names=hi_IN;
501 SELECT @@global.lc_time_names;
502 SET @@global.lc_time_names=hr_HR;
503 SELECT @@global.lc_time_names;
504 SET @@global.lc_time_names=hu_HU;
505 SELECT @@global.lc_time_names;
506 SET @@global.lc_time_names=id_ID;
507 SELECT @@global.lc_time_names;
508 SET @@global.lc_time_names=is_IS;
509 SELECT @@global.lc_time_names;
510 SET @@global.lc_time_names=it_CH;
511 SELECT @@global.lc_time_names;
512 SET @@global.lc_time_names=it_IT;
513 SELECT @@global.lc_time_names;
514 SET @@global.lc_time_names=ja_JP;
515 SELECT @@global.lc_time_names;
516 SET @@global.lc_time_names=ko_KR;
517 SELECT @@global.lc_time_names;
518 SET @@global.lc_time_names=lt_LT;
519 SELECT @@global.lc_time_names;
520 SET @@global.lc_time_names=lv_LV;
521 SELECT @@global.lc_time_names;
522 SET @@global.lc_time_names=mk_MK;
523 SELECT @@global.lc_time_names;
524 SET @@global.lc_time_names=mn_MN;
525 SELECT @@global.lc_time_names;
526 SET @@global.lc_time_names=ms_MY;
527 SELECT @@global.lc_time_names;
528 SET @@global.lc_time_names=nb_NO;
529 SELECT @@global.lc_time_names;
530 SET @@global.lc_time_names=nl_BE;
531 SELECT @@global.lc_time_names;
532 SET @@global.lc_time_names=nl_NL;
533 SELECT @@global.lc_time_names;
534 SET @@global.lc_time_names=no_NO;
535 SELECT @@global.lc_time_names;
536 SET @@global.lc_time_names=pl_PL;
537 SELECT @@global.lc_time_names;
538 SET @@global.lc_time_names=pt_BR;
539 SELECT @@global.lc_time_names;
540 SET @@global.lc_time_names=pt_PT;
541 SELECT @@global.lc_time_names;
542 SET @@global.lc_time_names=ro_RO;
543 SELECT @@global.lc_time_names;
544 SET @@global.lc_time_names=ru_RU;
545 SELECT @@global.lc_time_names;
546 SET @@global.lc_time_names=ru_UA;
547 SELECT @@global.lc_time_names;
548 SET @@global.lc_time_names=sk_SK;
549 SELECT @@global.lc_time_names;
550 SET @@global.lc_time_names=sl_SI;
551 SELECT @@global.lc_time_names;
552 SET @@global.lc_time_names=sq_AL;
553 SELECT @@global.lc_time_names;
554 SET @@global.lc_time_names=sr_YU;
555 SELECT @@global.lc_time_names;
556 SET @@global.lc_time_names=sv_FI;
557 SELECT @@global.lc_time_names;
558 SET @@global.lc_time_names=sr_RS;
559 SELECT @@global.lc_time_names;
560 SET @@global.lc_time_names=sv_SE;
561 SELECT @@global.lc_time_names;
562 SET @@global.lc_time_names=ta_IN;
563 SELECT @@global.lc_time_names;
564 SET @@global.lc_time_names=te_IN;
565 SELECT @@global.lc_time_names;
566 SET @@global.lc_time_names=th_TH;
567 SELECT @@global.lc_time_names;
568 SET @@global.lc_time_names=tr_TR;
569 SELECT @@global.lc_time_names;
570 SET @@global.lc_time_names=uk_UA;
571 SELECT @@global.lc_time_names;
572 SET @@global.lc_time_names=ur_PK;
573 SELECT @@global.lc_time_names;
574 SET @@global.lc_time_names=vi_VN;
575 SELECT @@global.lc_time_names;
576 SET @@global.lc_time_names=zh_CN;
577 SELECT @@global.lc_time_names;
578 SET @@global.lc_time_names=zh_HK;
579 SELECT @@global.lc_time_names;
580 SET @@global.lc_time_names=zh_TW;
581 SELECT @@global.lc_time_names;
582
583
584 --echo '#--------------------FN_DYNVARS_060_08-------------------------#'
585 ##########################################################################
586 # Change the value of lc_time_names to a valid value with uppercase,
587 # lowercase and mixedcase
588 ##########################################################################
589
590 SET @@lc_time_names = ur_pk;
591 SELECT @@lc_time_names;
592 SET @@lc_time_names = UR_PK;
593 SELECT @@lc_time_names;
594 SET @@lc_time_names = uR_pK;
595 SELECT @@lc_time_names;
596
597
598 --echo '#--------------------FN_DYNVARS_060_09-------------------------#'
599 ##############################################################
600 # Check if 0,1,2,3, ... values can be used on variable #
601 ##############################################################
602
603 SET @@lc_time_names = 0;
604 SELECT @@lc_time_names;
605 SET @@lc_time_names = 1;
606 SELECT @@lc_time_names;
607 SET @@lc_time_names = 2;
608 SELECT @@lc_time_names;
609 SET @@lc_time_names = 3;
610 SELECT @@lc_time_names;
611 SET @@lc_time_names = 10;
612 SELECT @@lc_time_names;
613 SET @@lc_time_names = 50;
614 SELECT @@lc_time_names;
615 SET @@lc_time_names = 100;
616 SELECT @@lc_time_names;
617 SET @@lc_time_names = 101;
618 SELECT @@lc_time_names;
619 SET @@lc_time_names = 107;
620 SELECT @@lc_time_names;
621 SET @@lc_time_names = 108;
622 SELECT @@lc_time_names;
623 SET @@lc_time_names = 109;
624 SELECT @@lc_time_names;
625 SET @@lc_time_names = 110;
626 SELECT @@lc_time_names;
627 --Error ER_UNKNOWN_LOCALE
628 SET @@lc_time_names = 111;
629
630 --echo '#--------------------FN_DYNVARS_060_10-------------------------#'
631 #############################################################################
632 # Change the value of lc_time_names to an invalid value for session #
633 #############################################################################
634
635 --Error ER_UNKNOWN_LOCALE
636 SET @@lc_time_names = en_EN;
637 --Error ER_UNKNOWN_LOCALE
638 SET @@lc_time_names = US_en;
639 --Error ER_WRONG_TYPE_FOR_VAR
640 SET @@lc_time_names = 1.1;
641 --Error ER_UNKNOWN_LOCALE
642 SET @@lc_time_names = -1;
643 --Error ER_UNKNOWN_LOCALE
644 SET @@lc_time_names = 'en US';
645 --Error ER_UNKNOWN_LOCALE
646 SET @@lc_time_names = 'enUS';
647
648 SET @@lc_time_names = true;
649 SELECT @@lc_time_names AS res_with_true;
650 SET @@lc_time_names = false;
651 SELECT @@lc_time_names AS res_with_false;
652
653 --Error ER_UNKNOWN_LOCALE
654 SET @@lc_time_names = ON;
655
656
657 --echo '#--------------------FN_DYNVARS_060_11-------------------------#'
658 ############################################################################
659 # Change the value of lc_time_names to an invalid value for global #
660 ############################################################################
661
662 --Error ER_UNKNOWN_LOCALE
663 SET @@global.lc_time_names = en_EN;
664 --Error ER_UNKNOWN_LOCALE
665 SET @@global.lc_time_names = US_en;
666 --Error ER_WRONG_TYPE_FOR_VAR
667 SET @@global.lc_time_names = 1.1;
668 --Error ER_UNKNOWN_LOCALE
669 SET @@global.lc_time_names = -1;
670 --Error ER_WRONG_VALUE_FOR_VAR
671 SET @@global.lc_time_names = NULL;
672 --Error ER_UNKNOWN_LOCALE
673 SET @@global.lc_time_names = 'enUS';
674
675 SET @@global.lc_time_names = true;
676 SELECT @@global.lc_time_names;
677 SET @@global.lc_time_names = false;
678 SELECT @@global.lc_time_names;
679
680 --Error ER_UNKNOWN_LOCALE
681 SET @@global.lc_time_names = ON;
682
683 --echo '#--------------------FN_DYNVARS_060_12-------------------------#'
684 ##############################################################################
685 # Check if the value in GLOBAL Table matches value in variable #
686 ##############################################################################
687 --disable_warnings
688 SELECT @@global.lc_time_names = (SELECT VARIABLE_VALUE
689 FROM performance_schema.global_variables
690 WHERE VARIABLE_NAME='lc_time_names') AS res;
691 --enable_warnings
692 SET @@global.lc_time_names = 1;
693 SELECT @@global.lc_time_names;
694 --disable_warnings
695 SELECT @@global.lc_time_names = (SELECT VARIABLE_VALUE
696 FROM performance_schema.global_variables
697 WHERE VARIABLE_NAME='lc_time_names') AS res;
698 --enable_warnings
699
700 --echo '#--------------------FN_DYNVARS_060_13-------------------------#'
701 ##############################################################################
702 # Check if the value in SESSION Table matches value in variable #
703 ##############################################################################
704 --disable_warnings
705 SELECT @@lc_time_names = (SELECT VARIABLE_VALUE
706 FROM performance_schema.session_variables
707 WHERE VARIABLE_NAME='lc_time_names') AS res;
708 SELECT @@local.lc_time_names = (SELECT VARIABLE_VALUE
709 FROM performance_schema.session_variables
710 WHERE VARIABLE_NAME='lc_time_names') AS res;
711 SELECT @@session.lc_time_names = (SELECT VARIABLE_VALUE
712 FROM performance_schema.session_variables
713 WHERE VARIABLE_NAME='lc_time_names') AS res;
714 --enable_warnings
715
716 ####################################
717 # Restore initial value #
718 ####################################
719 SET @@global.lc_time_names = @global_start_value;
720 SELECT @@global.lc_time_names;
721 SET @@session.lc_time_names = @session_start_value;
722 SELECT @@session.lc_time_names;
723
724 #############################################################
725 # END OF lc_time_names TESTS #
726 #############################################################