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