Debian Codegraph @

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

raw
1 SET @global_start_value = @@global.lc_time_names;
2 SELECT @global_start_value;
3 @global_start_value
4 en_US
5 SET @session_start_value = @@lc_time_names;
6 SELECT @session_start_value;
7 @session_start_value
8 en_US
9 SET @session_start_value = @@local.lc_time_names;
10 SELECT @session_start_value;
11 @session_start_value
12 en_US
13 SET @session_start_value = @@session.lc_time_names;
14 SELECT @session_start_value;
15 @session_start_value
16 en_US
17 '#--------------------FN_DYNVARS_060_01------------------#'
18 SELECT lc_time_names;
19 ERROR 42S22: Unknown column 'lc_time_names' in 'SELECT'
20 SET lc_time_names=ar_AE;
21 SELECT @@session.lc_time_names;
22 @@session.lc_time_names
23 ar_AE
24 SET session lc_time_names=ar_AE;
25 SELECT session lc_time_names;
26 ERROR 42S22: Unknown column 'session' in 'SELECT'
27 SET global lc_time_names=ar_AE;
28 SELECT global lc_time_names;
29 ERROR 42S22: Unknown column 'global' in 'SELECT'
30 '#--------------------FN_DYNVARS_060_02-------------------------#'
31 SET @@lc_time_names = en_ZA;
32 SET @@lc_time_names = DEFAULT;
33 SELECT @@lc_time_names AS DEFAULT_VALUE;
34 DEFAULT_VALUE
35 ar_AE
36 SET @@global.lc_time_names = en_ZA;
37 SET @@global.lc_time_names = DEFAULT;
38 SELECT @@global.lc_time_names;
39 @@global.lc_time_names
40 en_US
41 '#--------------------FN_DYNVARS_060_03-------------------------#'
42 SET @@session.lc_time_names = en_IN;
43 SELECT @@session.lc_time_names;
44 @@session.lc_time_names
45 en_IN
46 SET @@global.lc_time_names = en_NZ;
47 SELECT @@global.lc_time_names;
48 @@global.lc_time_names
49 en_NZ
50 SELECT @@session.lc_time_names AS res_is_en_IN;
51 res_is_en_IN
52 en_IN
53 SET @@session.lc_time_names = en_AU;
54 SELECT @@session.lc_time_names;
55 @@session.lc_time_names
56 en_AU
57 SELECT @@global.lc_time_names AS res_is_en_NZ;
58 res_is_en_NZ
59 en_NZ
60 SELECT @@global.lc_time_names=@@session.lc_time_names AS res_is_false;
61 res_is_false
62 0
63 '#--------------------FN_DYNVARS_060_04-------------------------#'
64 SELECT @@lc_time_names = @@session.lc_time_names AS res;
65 res
66 1
67 SELECT @@lc_time_names = @@local.lc_time_names AS res;
68 res
69 1
70 '#--------------------FN_DYNVARS_060_05-------------------------#'
71 SET @@lc_time_names = en_US | en_GB ;
72 ERROR 42S22: Unknown column 'en_US' in 'SET'
73 '#--------------------FN_DYNVARS_060_06-------------------------#'
74 SET @@session.lc_time_names=ar_AE;
75 SELECT @@session.lc_time_names;
76 @@session.lc_time_names
77 ar_AE
78 SET @@session.lc_time_names=ar_BH;
79 SELECT @@session.lc_time_names;
80 @@session.lc_time_names
81 ar_BH
82 SET @@session.lc_time_names=ar_DZ;
83 SELECT @@session.lc_time_names;
84 @@session.lc_time_names
85 ar_DZ
86 SET @@session.lc_time_names=ar_EG;
87 SELECT @@session.lc_time_names;
88 @@session.lc_time_names
89 ar_EG
90 SET @@session.lc_time_names=ar_IN;
91 SELECT @@session.lc_time_names;
92 @@session.lc_time_names
93 ar_IN
94 SET @@session.lc_time_names=ar_IQ;
95 SELECT @@session.lc_time_names;
96 @@session.lc_time_names
97 ar_IQ
98 SET @@session.lc_time_names=ar_JO;
99 SELECT @@session.lc_time_names;
100 @@session.lc_time_names
101 ar_JO
102 SET @@session.lc_time_names=ar_KW;
103 SELECT @@session.lc_time_names;
104 @@session.lc_time_names
105 ar_KW
106 SET @@session.lc_time_names=ar_LB;
107 SELECT @@session.lc_time_names;
108 @@session.lc_time_names
109 ar_LB
110 SET @@session.lc_time_names=ar_LY;
111 SELECT @@session.lc_time_names;
112 @@session.lc_time_names
113 ar_LY
114 SET @@session.lc_time_names=ar_MA;
115 SELECT @@session.lc_time_names;
116 @@session.lc_time_names
117 ar_MA
118 SET @@session.lc_time_names=ar_OM;
119 SELECT @@session.lc_time_names;
120 @@session.lc_time_names
121 ar_OM
122 SET @@session.lc_time_names=ar_QA;
123 SELECT @@session.lc_time_names;
124 @@session.lc_time_names
125 ar_QA
126 SET @@session.lc_time_names=ar_SA;
127 SELECT @@session.lc_time_names;
128 @@session.lc_time_names
129 ar_SA
130 SET @@session.lc_time_names=ar_SD;
131 SELECT @@session.lc_time_names;
132 @@session.lc_time_names
133 ar_SD
134 SET @@session.lc_time_names=ar_SY;
135 SELECT @@session.lc_time_names;
136 @@session.lc_time_names
137 ar_SY
138 SET @@session.lc_time_names=ar_TN;
139 SELECT @@session.lc_time_names;
140 @@session.lc_time_names
141 ar_TN
142 SET @@session.lc_time_names=ar_YE;
143 SELECT @@session.lc_time_names;
144 @@session.lc_time_names
145 ar_YE
146 SET @@session.lc_time_names=be_BY;
147 SELECT @@session.lc_time_names;
148 @@session.lc_time_names
149 be_BY
150 SET @@session.lc_time_names=bg_BG;
151 SELECT @@session.lc_time_names;
152 @@session.lc_time_names
153 bg_BG
154 SET @@session.lc_time_names=ca_ES;
155 SELECT @@session.lc_time_names;
156 @@session.lc_time_names
157 ca_ES
158 SET @@session.lc_time_names=cs_CZ;
159 SELECT @@session.lc_time_names;
160 @@session.lc_time_names
161 cs_CZ
162 SET @@session.lc_time_names=da_DK;
163 SELECT @@session.lc_time_names;
164 @@session.lc_time_names
165 da_DK
166 SET @@session.lc_time_names=de_AT;
167 SELECT @@session.lc_time_names;
168 @@session.lc_time_names
169 de_AT
170 SET @@session.lc_time_names=de_BE;
171 SELECT @@session.lc_time_names;
172 @@session.lc_time_names
173 de_BE
174 SET @@session.lc_time_names=de_CH;
175 SELECT @@session.lc_time_names;
176 @@session.lc_time_names
177 de_CH
178 SET @@session.lc_time_names=de_DE;
179 SELECT @@session.lc_time_names;
180 @@session.lc_time_names
181 de_DE
182 SET @@session.lc_time_names=de_LU;
183 SELECT @@session.lc_time_names;
184 @@session.lc_time_names
185 de_LU
186 SET @@session.lc_time_names=EE;
187 ERROR HY000: Unknown locale: 'EE'
188 'Bug: The locale for Estonian - Estonia is not supported. It is present';
189 'in manual';
190 'See http://dev.mysql.com/doc/refman/5.1/en/locale-support.html'
191 SET @@session.lc_time_names=en_AU;
192 SELECT @@session.lc_time_names;
193 @@session.lc_time_names
194 en_AU
195 SET @@session.lc_time_names=en_CA;
196 SELECT @@session.lc_time_names;
197 @@session.lc_time_names
198 en_CA
199 SET @@session.lc_time_names=en_GB;
200 SELECT @@session.lc_time_names;
201 @@session.lc_time_names
202 en_GB
203 SET @@session.lc_time_names=en_IN;
204 SELECT @@session.lc_time_names;
205 @@session.lc_time_names
206 en_IN
207 SET @@session.lc_time_names=en_NZ;
208 SELECT @@session.lc_time_names;
209 @@session.lc_time_names
210 en_NZ
211 SET @@session.lc_time_names=en_PH;
212 SELECT @@session.lc_time_names;
213 @@session.lc_time_names
214 en_PH
215 SET @@session.lc_time_names=en_US;
216 SELECT @@session.lc_time_names;
217 @@session.lc_time_names
218 en_US
219 SET @@session.lc_time_names=en_ZA;
220 SELECT @@session.lc_time_names;
221 @@session.lc_time_names
222 en_ZA
223 SET @@session.lc_time_names=en_ZW;
224 SELECT @@session.lc_time_names;
225 @@session.lc_time_names
226 en_ZW
227 SET @@session.lc_time_names=es_AR;
228 SELECT @@session.lc_time_names;
229 @@session.lc_time_names
230 es_AR
231 SET @@session.lc_time_names=es_BO;
232 SELECT @@session.lc_time_names;
233 @@session.lc_time_names
234 es_BO
235 SET @@session.lc_time_names=es_CL;
236 SELECT @@session.lc_time_names;
237 @@session.lc_time_names
238 es_CL
239 SET @@session.lc_time_names=es_CO;
240 SELECT @@session.lc_time_names;
241 @@session.lc_time_names
242 es_CO
243 SET @@session.lc_time_names=es_CR;
244 SELECT @@session.lc_time_names;
245 @@session.lc_time_names
246 es_CR
247 SET @@session.lc_time_names=es_DO;
248 SELECT @@session.lc_time_names;
249 @@session.lc_time_names
250 es_DO
251 SET @@session.lc_time_names=es_EC;
252 SELECT @@session.lc_time_names;
253 @@session.lc_time_names
254 es_EC
255 SET @@session.lc_time_names=es_ES;
256 SELECT @@session.lc_time_names;
257 @@session.lc_time_names
258 es_ES
259 SET @@session.lc_time_names=es_GT;
260 SELECT @@session.lc_time_names;
261 @@session.lc_time_names
262 es_GT
263 SET @@session.lc_time_names=es_HN;
264 SELECT @@session.lc_time_names;
265 @@session.lc_time_names
266 es_HN
267 SET @@session.lc_time_names=es_MX;
268 SELECT @@session.lc_time_names;
269 @@session.lc_time_names
270 es_MX
271 SET @@session.lc_time_names=es_NI;
272 SELECT @@session.lc_time_names;
273 @@session.lc_time_names
274 es_NI
275 SET @@session.lc_time_names=es_PA;
276 SELECT @@session.lc_time_names;
277 @@session.lc_time_names
278 es_PA
279 SET @@session.lc_time_names=es_PE;
280 SELECT @@session.lc_time_names;
281 @@session.lc_time_names
282 es_PE
283 SET @@session.lc_time_names=es_PR;
284 SELECT @@session.lc_time_names;
285 @@session.lc_time_names
286 es_PR
287 SET @@session.lc_time_names=es_PY;
288 SELECT @@session.lc_time_names;
289 @@session.lc_time_names
290 es_PY
291 SET @@session.lc_time_names=es_SV;
292 SELECT @@session.lc_time_names;
293 @@session.lc_time_names
294 es_SV
295 SET @@session.lc_time_names=es_US;
296 SELECT @@session.lc_time_names;
297 @@session.lc_time_names
298 es_US
299 SET @@session.lc_time_names=es_UY;
300 SELECT @@session.lc_time_names;
301 @@session.lc_time_names
302 es_UY
303 SET @@session.lc_time_names=es_VE;
304 SELECT @@session.lc_time_names;
305 @@session.lc_time_names
306 es_VE
307 SET @@session.lc_time_names=eu_ES;
308 SELECT @@session.lc_time_names;
309 @@session.lc_time_names
310 eu_ES
311 SET @@session.lc_time_names=fi_FI;
312 SELECT @@session.lc_time_names;
313 @@session.lc_time_names
314 fi_FI
315 SET @@session.lc_time_names=fo_FO;
316 SELECT @@session.lc_time_names;
317 @@session.lc_time_names
318 fo_FO
319 SET @@session.lc_time_names=fr_BE;
320 SELECT @@session.lc_time_names;
321 @@session.lc_time_names
322 fr_BE
323 SET @@session.lc_time_names=fr_CA;
324 SELECT @@session.lc_time_names;
325 @@session.lc_time_names
326 fr_CA
327 SET @@session.lc_time_names=fr_CH;
328 SELECT @@session.lc_time_names;
329 @@session.lc_time_names
330 fr_CH
331 SET @@session.lc_time_names=fr_FR;
332 SELECT @@session.lc_time_names;
333 @@session.lc_time_names
334 fr_FR
335 SET @@session.lc_time_names=fr_LU;
336 SELECT @@session.lc_time_names;
337 @@session.lc_time_names
338 fr_LU
339 SET @@session.lc_time_names=gl_ES;
340 SELECT @@session.lc_time_names;
341 @@session.lc_time_names
342 gl_ES
343 SET @@session.lc_time_names=gu_IN;
344 SELECT @@session.lc_time_names;
345 @@session.lc_time_names
346 gu_IN
347 SET @@session.lc_time_names=he_IL;
348 SELECT @@session.lc_time_names;
349 @@session.lc_time_names
350 he_IL
351 SET @@session.lc_time_names=hi_IN;
352 SELECT @@session.lc_time_names;
353 @@session.lc_time_names
354 hi_IN
355 SET @@session.lc_time_names=hr_HR;
356 SELECT @@session.lc_time_names;
357 @@session.lc_time_names
358 hr_HR
359 SET @@session.lc_time_names=hu_HU;
360 SELECT @@session.lc_time_names;
361 @@session.lc_time_names
362 hu_HU
363 SET @@session.lc_time_names=id_ID;
364 SELECT @@session.lc_time_names;
365 @@session.lc_time_names
366 id_ID
367 SET @@session.lc_time_names=is_IS;
368 SELECT @@session.lc_time_names;
369 @@session.lc_time_names
370 is_IS
371 SET @@session.lc_time_names=it_CH;
372 SELECT @@session.lc_time_names;
373 @@session.lc_time_names
374 it_CH
375 SET @@session.lc_time_names=it_IT;
376 SELECT @@session.lc_time_names;
377 @@session.lc_time_names
378 it_IT
379 SET @@session.lc_time_names=ja_JP;
380 SELECT @@session.lc_time_names;
381 @@session.lc_time_names
382 ja_JP
383 SET @@session.lc_time_names=ko_KR;
384 SELECT @@session.lc_time_names;
385 @@session.lc_time_names
386 ko_KR
387 SET @@session.lc_time_names=lt_LT;
388 SELECT @@session.lc_time_names;
389 @@session.lc_time_names
390 lt_LT
391 SET @@session.lc_time_names=lv_LV;
392 SELECT @@session.lc_time_names;
393 @@session.lc_time_names
394 lv_LV
395 SET @@session.lc_time_names=mk_MK;
396 SELECT @@session.lc_time_names;
397 @@session.lc_time_names
398 mk_MK
399 SET @@session.lc_time_names=mn_MN;
400 SELECT @@session.lc_time_names;
401 @@session.lc_time_names
402 mn_MN
403 SET @@session.lc_time_names=ms_MY;
404 SELECT @@session.lc_time_names;
405 @@session.lc_time_names
406 ms_MY
407 SET @@session.lc_time_names=nb_NO;
408 SELECT @@session.lc_time_names;
409 @@session.lc_time_names
410 nb_NO
411 SET @@session.lc_time_names=nl_BE;
412 SELECT @@session.lc_time_names;
413 @@session.lc_time_names
414 nl_BE
415 SET @@session.lc_time_names=nl_NL;
416 SELECT @@session.lc_time_names;
417 @@session.lc_time_names
418 nl_NL
419 SET @@session.lc_time_names=no_NO;
420 SELECT @@session.lc_time_names;
421 @@session.lc_time_names
422 no_NO
423 SET @@session.lc_time_names=pl_PL;
424 SELECT @@session.lc_time_names;
425 @@session.lc_time_names
426 pl_PL
427 SET @@session.lc_time_names=pt_BR;
428 SELECT @@session.lc_time_names;
429 @@session.lc_time_names
430 pt_BR
431 SET @@session.lc_time_names=pt_PT;
432 SELECT @@session.lc_time_names;
433 @@session.lc_time_names
434 pt_PT
435 SET @@session.lc_time_names=ro_RO;
436 SELECT @@session.lc_time_names;
437 @@session.lc_time_names
438 ro_RO
439 SET @@session.lc_time_names=ru_RU;
440 SELECT @@session.lc_time_names;
441 @@session.lc_time_names
442 ru_RU
443 SET @@session.lc_time_names=ru_UA;
444 SELECT @@session.lc_time_names;
445 @@session.lc_time_names
446 ru_UA
447 SET @@session.lc_time_names=sk_SK;
448 SELECT @@session.lc_time_names;
449 @@session.lc_time_names
450 sk_SK
451 SET @@session.lc_time_names=sl_SI;
452 SELECT @@session.lc_time_names;
453 @@session.lc_time_names
454 sl_SI
455 SET @@session.lc_time_names=sq_AL;
456 SELECT @@session.lc_time_names;
457 @@session.lc_time_names
458 sq_AL
459 SET @@session.lc_time_names=sv_FI;
460 SELECT @@session.lc_time_names;
461 @@session.lc_time_names
462 sv_FI
463 SET @@session.lc_time_names=sr_RS;
464 SELECT @@session.lc_time_names;
465 @@session.lc_time_names
466 sr_RS
467 SET @@session.lc_time_names=sv_SE;
468 SELECT @@session.lc_time_names;
469 @@session.lc_time_names
470 sv_SE
471 SET @@session.lc_time_names=ta_IN;
472 SELECT @@session.lc_time_names;
473 @@session.lc_time_names
474 ta_IN
475 SET @@session.lc_time_names=te_IN;
476 SELECT @@session.lc_time_names;
477 @@session.lc_time_names
478 te_IN
479 SET @@session.lc_time_names=th_TH;
480 SELECT @@session.lc_time_names;
481 @@session.lc_time_names
482 th_TH
483 SET @@session.lc_time_names=tr_TR;
484 SELECT @@session.lc_time_names;
485 @@session.lc_time_names
486 tr_TR
487 SET @@session.lc_time_names=uk_UA;
488 SELECT @@session.lc_time_names;
489 @@session.lc_time_names
490 uk_UA
491 SET @@session.lc_time_names=ur_PK;
492 SELECT @@session.lc_time_names;
493 @@session.lc_time_names
494 ur_PK
495 SET @@session.lc_time_names=vi_VN;
496 SELECT @@session.lc_time_names;
497 @@session.lc_time_names
498 vi_VN
499 SET @@session.lc_time_names=zh_CN;
500 SELECT @@session.lc_time_names;
501 @@session.lc_time_names
502 zh_CN
503 SET @@session.lc_time_names=zh_HK;
504 SELECT @@session.lc_time_names;
505 @@session.lc_time_names
506 zh_HK
507 SET @@session.lc_time_names=zh_TW;
508 SELECT @@session.lc_time_names;
509 @@session.lc_time_names
510 zh_TW
511 '#--------------------FN_DYNVARS_060_07-------------------------#'
512 SET @@global.lc_time_names=ar_AE;
513 SELECT @@global.lc_time_names;
514 @@global.lc_time_names
515 ar_AE
516 SET @@global.lc_time_names=ar_BH;
517 SELECT @@global.lc_time_names;
518 @@global.lc_time_names
519 ar_BH
520 SET @@global.lc_time_names=ar_DZ;
521 SELECT @@global.lc_time_names;
522 @@global.lc_time_names
523 ar_DZ
524 SET @@global.lc_time_names=ar_EG;
525 SELECT @@global.lc_time_names;
526 @@global.lc_time_names
527 ar_EG
528 SET @@global.lc_time_names=ar_IN;
529 SELECT @@global.lc_time_names;
530 @@global.lc_time_names
531 ar_IN
532 SET @@global.lc_time_names=ar_IQ;
533 SELECT @@global.lc_time_names;
534 @@global.lc_time_names
535 ar_IQ
536 SET @@global.lc_time_names=ar_JO;
537 SELECT @@global.lc_time_names;
538 @@global.lc_time_names
539 ar_JO
540 SET @@global.lc_time_names=ar_KW;
541 SELECT @@global.lc_time_names;
542 @@global.lc_time_names
543 ar_KW
544 SET @@global.lc_time_names=ar_LB;
545 SELECT @@global.lc_time_names;
546 @@global.lc_time_names
547 ar_LB
548 SET @@global.lc_time_names=ar_LY;
549 SELECT @@global.lc_time_names;
550 @@global.lc_time_names
551 ar_LY
552 SET @@global.lc_time_names=ar_MA;
553 SELECT @@global.lc_time_names;
554 @@global.lc_time_names
555 ar_MA
556 SET @@global.lc_time_names=ar_OM;
557 SELECT @@global.lc_time_names;
558 @@global.lc_time_names
559 ar_OM
560 SET @@global.lc_time_names=ar_QA;
561 SELECT @@global.lc_time_names;
562 @@global.lc_time_names
563 ar_QA
564 SET @@global.lc_time_names=ar_SA;
565 SELECT @@global.lc_time_names;
566 @@global.lc_time_names
567 ar_SA
568 SET @@global.lc_time_names=ar_SD;
569 SELECT @@global.lc_time_names;
570 @@global.lc_time_names
571 ar_SD
572 SET @@global.lc_time_names=ar_SY;
573 SELECT @@global.lc_time_names;
574 @@global.lc_time_names
575 ar_SY
576 SET @@global.lc_time_names=ar_TN;
577 SELECT @@global.lc_time_names;
578 @@global.lc_time_names
579 ar_TN
580 SET @@global.lc_time_names=ar_YE;
581 SELECT @@global.lc_time_names;
582 @@global.lc_time_names
583 ar_YE
584 SET @@global.lc_time_names=be_BY;
585 SELECT @@global.lc_time_names;
586 @@global.lc_time_names
587 be_BY
588 SET @@global.lc_time_names=bg_BG;
589 SELECT @@global.lc_time_names;
590 @@global.lc_time_names
591 bg_BG
592 SET @@global.lc_time_names=ca_ES;
593 SELECT @@global.lc_time_names;
594 @@global.lc_time_names
595 ca_ES
596 SET @@global.lc_time_names=cs_CZ;
597 SELECT @@global.lc_time_names;
598 @@global.lc_time_names
599 cs_CZ
600 SET @@global.lc_time_names=da_DK;
601 SELECT @@global.lc_time_names;
602 @@global.lc_time_names
603 da_DK
604 SET @@global.lc_time_names=de_AT;
605 SELECT @@global.lc_time_names;
606 @@global.lc_time_names
607 de_AT
608 SET @@global.lc_time_names=de_BE;
609 SELECT @@global.lc_time_names;
610 @@global.lc_time_names
611 de_BE
612 SET @@global.lc_time_names=de_CH;
613 SELECT @@global.lc_time_names;
614 @@global.lc_time_names
615 de_CH
616 SET @@global.lc_time_names=de_DE;
617 SELECT @@global.lc_time_names;
618 @@global.lc_time_names
619 de_DE
620 SET @@global.lc_time_names=de_LU;
621 SELECT @@global.lc_time_names;
622 @@global.lc_time_names
623 de_LU
624 SET @@global.lc_time_names=EE;
625 ERROR HY000: Unknown locale: 'EE'
626 'Bug: The locale for Estonian - Estonia is not supported. It is';
627 'present in manual';
628 'See http://dev.mysql.com/doc/refman/5.1/en/locale-support.html';
629 SELECT @@global.lc_time_names;
630 @@global.lc_time_names
631 de_LU
632 SET @@global.lc_time_names=en_AU;
633 SELECT @@global.lc_time_names;
634 @@global.lc_time_names
635 en_AU
636 SET @@global.lc_time_names=en_CA;
637 SELECT @@global.lc_time_names;
638 @@global.lc_time_names
639 en_CA
640 SET @@global.lc_time_names=en_GB;
641 SELECT @@global.lc_time_names;
642 @@global.lc_time_names
643 en_GB
644 SET @@global.lc_time_names=en_IN;
645 SELECT @@global.lc_time_names;
646 @@global.lc_time_names
647 en_IN
648 SET @@global.lc_time_names=en_NZ;
649 SELECT @@global.lc_time_names;
650 @@global.lc_time_names
651 en_NZ
652 SET @@global.lc_time_names=en_PH;
653 SELECT @@global.lc_time_names;
654 @@global.lc_time_names
655 en_PH
656 SET @@global.lc_time_names=en_US;
657 SELECT @@global.lc_time_names;
658 @@global.lc_time_names
659 en_US
660 SET @@global.lc_time_names=en_ZA;
661 SELECT @@global.lc_time_names;
662 @@global.lc_time_names
663 en_ZA
664 SET @@global.lc_time_names=en_ZW;
665 SELECT @@global.lc_time_names;
666 @@global.lc_time_names
667 en_ZW
668 SET @@global.lc_time_names=es_AR;
669 SELECT @@global.lc_time_names;
670 @@global.lc_time_names
671 es_AR
672 SET @@global.lc_time_names=es_BO;
673 SELECT @@global.lc_time_names;
674 @@global.lc_time_names
675 es_BO
676 SET @@global.lc_time_names=es_CL;
677 SELECT @@global.lc_time_names;
678 @@global.lc_time_names
679 es_CL
680 SET @@global.lc_time_names=es_CO;
681 SELECT @@global.lc_time_names;
682 @@global.lc_time_names
683 es_CO
684 SET @@global.lc_time_names=es_CR;
685 SELECT @@global.lc_time_names;
686 @@global.lc_time_names
687 es_CR
688 SET @@global.lc_time_names=es_DO;
689 SELECT @@global.lc_time_names;
690 @@global.lc_time_names
691 es_DO
692 SET @@global.lc_time_names=es_EC;
693 SELECT @@global.lc_time_names;
694 @@global.lc_time_names
695 es_EC
696 SET @@global.lc_time_names=es_ES;
697 SELECT @@global.lc_time_names;
698 @@global.lc_time_names
699 es_ES
700 SET @@global.lc_time_names=es_GT;
701 SELECT @@global.lc_time_names;
702 @@global.lc_time_names
703 es_GT
704 SET @@global.lc_time_names=es_HN;
705 SELECT @@global.lc_time_names;
706 @@global.lc_time_names
707 es_HN
708 SET @@global.lc_time_names=es_MX;
709 SELECT @@global.lc_time_names;
710 @@global.lc_time_names
711 es_MX
712 SET @@global.lc_time_names=es_NI;
713 SELECT @@global.lc_time_names;
714 @@global.lc_time_names
715 es_NI
716 SET @@global.lc_time_names=es_PA;
717 SELECT @@global.lc_time_names;
718 @@global.lc_time_names
719 es_PA
720 SET @@global.lc_time_names=es_PE;
721 SELECT @@global.lc_time_names;
722 @@global.lc_time_names
723 es_PE
724 SET @@global.lc_time_names=es_PR;
725 SELECT @@global.lc_time_names;
726 @@global.lc_time_names
727 es_PR
728 SET @@global.lc_time_names=es_PY;
729 SELECT @@global.lc_time_names;
730 @@global.lc_time_names
731 es_PY
732 SET @@global.lc_time_names=es_SV;
733 SELECT @@global.lc_time_names;
734 @@global.lc_time_names
735 es_SV
736 SET @@global.lc_time_names=es_US;
737 SELECT @@global.lc_time_names;
738 @@global.lc_time_names
739 es_US
740 SET @@global.lc_time_names=es_UY;
741 SELECT @@global.lc_time_names;
742 @@global.lc_time_names
743 es_UY
744 SET @@global.lc_time_names=es_VE;
745 SELECT @@global.lc_time_names;
746 @@global.lc_time_names
747 es_VE
748 SET @@global.lc_time_names=eu_ES;
749 SELECT @@global.lc_time_names;
750 @@global.lc_time_names
751 eu_ES
752 SET @@global.lc_time_names=fi_FI;
753 SELECT @@global.lc_time_names;
754 @@global.lc_time_names
755 fi_FI
756 SET @@global.lc_time_names=fo_FO;
757 SELECT @@global.lc_time_names;
758 @@global.lc_time_names
759 fo_FO
760 SET @@global.lc_time_names=fr_BE;
761 SELECT @@global.lc_time_names;
762 @@global.lc_time_names
763 fr_BE
764 SET @@global.lc_time_names=fr_CA;
765 SELECT @@global.lc_time_names;
766 @@global.lc_time_names
767 fr_CA
768 SET @@global.lc_time_names=fr_CH;
769 SELECT @@global.lc_time_names;
770 @@global.lc_time_names
771 fr_CH
772 SET @@global.lc_time_names=fr_FR;
773 SELECT @@global.lc_time_names;
774 @@global.lc_time_names
775 fr_FR
776 SET @@global.lc_time_names=fr_LU;
777 SELECT @@global.lc_time_names;
778 @@global.lc_time_names
779 fr_LU
780 SET @@global.lc_time_names=gl_ES;
781 SELECT @@global.lc_time_names;
782 @@global.lc_time_names
783 gl_ES
784 SET @@global.lc_time_names=gu_IN;
785 SELECT @@global.lc_time_names;
786 @@global.lc_time_names
787 gu_IN
788 SET @@global.lc_time_names=he_IL;
789 SELECT @@global.lc_time_names;
790 @@global.lc_time_names
791 he_IL
792 SET @@global.lc_time_names=hi_IN;
793 SELECT @@global.lc_time_names;
794 @@global.lc_time_names
795 hi_IN
796 SET @@global.lc_time_names=hr_HR;
797 SELECT @@global.lc_time_names;
798 @@global.lc_time_names
799 hr_HR
800 SET @@global.lc_time_names=hu_HU;
801 SELECT @@global.lc_time_names;
802 @@global.lc_time_names
803 hu_HU
804 SET @@global.lc_time_names=id_ID;
805 SELECT @@global.lc_time_names;
806 @@global.lc_time_names
807 id_ID
808 SET @@global.lc_time_names=is_IS;
809 SELECT @@global.lc_time_names;
810 @@global.lc_time_names
811 is_IS
812 SET @@global.lc_time_names=it_CH;
813 SELECT @@global.lc_time_names;
814 @@global.lc_time_names
815 it_CH
816 SET @@global.lc_time_names=it_IT;
817 SELECT @@global.lc_time_names;
818 @@global.lc_time_names
819 it_IT
820 SET @@global.lc_time_names=ja_JP;
821 SELECT @@global.lc_time_names;
822 @@global.lc_time_names
823 ja_JP
824 SET @@global.lc_time_names=ko_KR;
825 SELECT @@global.lc_time_names;
826 @@global.lc_time_names
827 ko_KR
828 SET @@global.lc_time_names=lt_LT;
829 SELECT @@global.lc_time_names;
830 @@global.lc_time_names
831 lt_LT
832 SET @@global.lc_time_names=lv_LV;
833 SELECT @@global.lc_time_names;
834 @@global.lc_time_names
835 lv_LV
836 SET @@global.lc_time_names=mk_MK;
837 SELECT @@global.lc_time_names;
838 @@global.lc_time_names
839 mk_MK
840 SET @@global.lc_time_names=mn_MN;
841 SELECT @@global.lc_time_names;
842 @@global.lc_time_names
843 mn_MN
844 SET @@global.lc_time_names=ms_MY;
845 SELECT @@global.lc_time_names;
846 @@global.lc_time_names
847 ms_MY
848 SET @@global.lc_time_names=nb_NO;
849 SELECT @@global.lc_time_names;
850 @@global.lc_time_names
851 nb_NO
852 SET @@global.lc_time_names=nl_BE;
853 SELECT @@global.lc_time_names;
854 @@global.lc_time_names
855 nl_BE
856 SET @@global.lc_time_names=nl_NL;
857 SELECT @@global.lc_time_names;
858 @@global.lc_time_names
859 nl_NL
860 SET @@global.lc_time_names=no_NO;
861 SELECT @@global.lc_time_names;
862 @@global.lc_time_names
863 no_NO
864 SET @@global.lc_time_names=pl_PL;
865 SELECT @@global.lc_time_names;
866 @@global.lc_time_names
867 pl_PL
868 SET @@global.lc_time_names=pt_BR;
869 SELECT @@global.lc_time_names;
870 @@global.lc_time_names
871 pt_BR
872 SET @@global.lc_time_names=pt_PT;
873 SELECT @@global.lc_time_names;
874 @@global.lc_time_names
875 pt_PT
876 SET @@global.lc_time_names=ro_RO;
877 SELECT @@global.lc_time_names;
878 @@global.lc_time_names
879 ro_RO
880 SET @@global.lc_time_names=ru_RU;
881 SELECT @@global.lc_time_names;
882 @@global.lc_time_names
883 ru_RU
884 SET @@global.lc_time_names=ru_UA;
885 SELECT @@global.lc_time_names;
886 @@global.lc_time_names
887 ru_UA
888 SET @@global.lc_time_names=sk_SK;
889 SELECT @@global.lc_time_names;
890 @@global.lc_time_names
891 sk_SK
892 SET @@global.lc_time_names=sl_SI;
893 SELECT @@global.lc_time_names;
894 @@global.lc_time_names
895 sl_SI
896 SET @@global.lc_time_names=sq_AL;
897 SELECT @@global.lc_time_names;
898 @@global.lc_time_names
899 sq_AL
900 SET @@global.lc_time_names=sv_FI;
901 SELECT @@global.lc_time_names;
902 @@global.lc_time_names
903 sv_FI
904 SET @@global.lc_time_names=sr_RS;
905 SELECT @@global.lc_time_names;
906 @@global.lc_time_names
907 sr_RS
908 SET @@global.lc_time_names=sv_SE;
909 SELECT @@global.lc_time_names;
910 @@global.lc_time_names
911 sv_SE
912 SET @@global.lc_time_names=ta_IN;
913 SELECT @@global.lc_time_names;
914 @@global.lc_time_names
915 ta_IN
916 SET @@global.lc_time_names=te_IN;
917 SELECT @@global.lc_time_names;
918 @@global.lc_time_names
919 te_IN
920 SET @@global.lc_time_names=th_TH;
921 SELECT @@global.lc_time_names;
922 @@global.lc_time_names
923 th_TH
924 SET @@global.lc_time_names=tr_TR;
925 SELECT @@global.lc_time_names;
926 @@global.lc_time_names
927 tr_TR
928 SET @@global.lc_time_names=uk_UA;
929 SELECT @@global.lc_time_names;
930 @@global.lc_time_names
931 uk_UA
932 SET @@global.lc_time_names=ur_PK;
933 SELECT @@global.lc_time_names;
934 @@global.lc_time_names
935 ur_PK
936 SET @@global.lc_time_names=vi_VN;
937 SELECT @@global.lc_time_names;
938 @@global.lc_time_names
939 vi_VN
940 SET @@global.lc_time_names=zh_CN;
941 SELECT @@global.lc_time_names;
942 @@global.lc_time_names
943 zh_CN
944 SET @@global.lc_time_names=zh_HK;
945 SELECT @@global.lc_time_names;
946 @@global.lc_time_names
947 zh_HK
948 SET @@global.lc_time_names=zh_TW;
949 SELECT @@global.lc_time_names;
950 @@global.lc_time_names
951 zh_TW
952 '#--------------------FN_DYNVARS_060_08-------------------------#'
953 SET @@lc_time_names = ur_pk;
954 SELECT @@lc_time_names;
955 @@lc_time_names
956 ur_PK
957 SET @@lc_time_names = UR_PK;
958 SELECT @@lc_time_names;
959 @@lc_time_names
960 ur_PK
961 SET @@lc_time_names = uR_pK;
962 SELECT @@lc_time_names;
963 @@lc_time_names
964 ur_PK
965 '#--------------------FN_DYNVARS_060_09-------------------------#'
966 SET @@lc_time_names = 0;
967 SELECT @@lc_time_names;
968 @@lc_time_names
969 en_US
970 SET @@lc_time_names = 1;
971 SELECT @@lc_time_names;
972 @@lc_time_names
973 en_GB
974 SET @@lc_time_names = 2;
975 SELECT @@lc_time_names;
976 @@lc_time_names
977 ja_JP
978 SET @@lc_time_names = 3;
979 SELECT @@lc_time_names;
980 @@lc_time_names
981 sv_SE
982 SET @@lc_time_names = 10;
983 SELECT @@lc_time_names;
984 @@lc_time_names
985 ar_SY
986 SET @@lc_time_names = 50;
987 SELECT @@lc_time_names;
988 @@lc_time_names
989 te_IN
990 SET @@lc_time_names = 100;
991 SELECT @@lc_time_names;
992 @@lc_time_names
993 fr_BE
994 SET @@lc_time_names = 101;
995 SELECT @@lc_time_names;
996 @@lc_time_names
997 fr_CA
998 SET @@lc_time_names = 107;
999 SELECT @@lc_time_names;
1000 @@lc_time_names
1001 sv_FI
1002 SET @@lc_time_names = 108;
1003 SELECT @@lc_time_names;
1004 @@lc_time_names
1005 zh_HK
1006 SET @@lc_time_names = 109;
1007 SELECT @@lc_time_names;
1008 @@lc_time_names
1009 el_GR
1010 SET @@lc_time_names = 110;
1011 SELECT @@lc_time_names;
1012 @@lc_time_names
1013 rm_CH
1014 SET @@lc_time_names = 111;
1015 SELECT @@lc_time_names;
1016 @@lc_time_names
1017 ka_GE
1018 SET @@lc_time_names = 112;
1019 SELECT @@lc_time_names;
1020 @@lc_time_names
1021 sw_KE
1022 SET @@lc_time_names = 113;
1023 ERROR HY000: Unknown locale: '113'
1024 '#--------------------FN_DYNVARS_060_10-------------------------#'
1025 SET @@lc_time_names = en_EN;
1026 ERROR HY000: Unknown locale: 'en_EN'
1027 SET @@lc_time_names = US_en;
1028 ERROR HY000: Unknown locale: 'US_en'
1029 SET @@lc_time_names = 1.1;
1030 ERROR 42000: Incorrect argument type to variable 'lc_time_names'
1031 SET @@lc_time_names = -1;
1032 ERROR HY000: Unknown locale: '-1'
1033 SET @@lc_time_names = 'en US';
1034 ERROR HY000: Unknown locale: 'en US'
1035 SET @@lc_time_names = 'enUS';
1036 ERROR HY000: Unknown locale: 'enUS'
1037 SET @@session.lc_time_names=sr_YU;
1038 ERROR HY000: Unknown locale: 'sr_YU'
1039 SET @@lc_time_names = true;
1040 SELECT @@lc_time_names AS res_with_true;
1041 res_with_true
1042 en_GB
1043 SET @@lc_time_names = false;
1044 SELECT @@lc_time_names AS res_with_false;
1045 res_with_false
1046 en_US
1047 SET @@lc_time_names = ON;
1048 ERROR HY000: Unknown locale: 'ON'
1049 '#--------------------FN_DYNVARS_060_11-------------------------#'
1050 SET @@global.lc_time_names = en_EN;
1051 ERROR HY000: Unknown locale: 'en_EN'
1052 SET @@global.lc_time_names = US_en;
1053 ERROR HY000: Unknown locale: 'US_en'
1054 SET @@global.lc_time_names = 1.1;
1055 ERROR 42000: Incorrect argument type to variable 'lc_time_names'
1056 SET @@global.lc_time_names = -1;
1057 ERROR HY000: Unknown locale: '-1'
1058 SET @@global.lc_time_names = NULL;
1059 ERROR 42000: Variable 'lc_time_names' can't be set to the value of 'NULL'
1060 SET @@global.lc_time_names = 'enUS';
1061 ERROR HY000: Unknown locale: 'enUS'
1062 SET @@global.lc_time_names = true;
1063 SELECT @@global.lc_time_names;
1064 @@global.lc_time_names
1065 en_GB
1066 SET @@global.lc_time_names = false;
1067 SELECT @@global.lc_time_names;
1068 @@global.lc_time_names
1069 en_US
1070 SET @@global.lc_time_names = ON;
1071 ERROR HY000: Unknown locale: 'ON'
1072 '#--------------------FN_DYNVARS_060_12-------------------------#'
1073 SELECT @@global.lc_time_names = (SELECT VARIABLE_VALUE
1074 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
1075 WHERE VARIABLE_NAME='lc_time_names') AS res;
1076 res
1077 1
1078 SET @@global.lc_time_names = 1;
1079 SELECT @@global.lc_time_names;
1080 @@global.lc_time_names
1081 en_GB
1082 SELECT @@global.lc_time_names = (SELECT VARIABLE_VALUE
1083 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
1084 WHERE VARIABLE_NAME='lc_time_names') AS res;
1085 res
1086 1
1087 '#--------------------FN_DYNVARS_060_13-------------------------#'
1088 SELECT @@lc_time_names = (SELECT VARIABLE_VALUE
1089 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
1090 WHERE VARIABLE_NAME='lc_time_names') AS res;
1091 res
1092 1
1093 SELECT @@local.lc_time_names = (SELECT VARIABLE_VALUE
1094 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
1095 WHERE VARIABLE_NAME='lc_time_names') AS res;
1096 res
1097 1
1098 SELECT @@session.lc_time_names = (SELECT VARIABLE_VALUE
1099 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
1100 WHERE VARIABLE_NAME='lc_time_names') AS res;
1101 res
1102 1
1103 SET @@global.lc_time_names = @global_start_value;
1104 SELECT @@global.lc_time_names;
1105 @@global.lc_time_names
1106 en_US
1107 SET @@session.lc_time_names = @session_start_value;
1108 SELECT @@session.lc_time_names;
1109 @@session.lc_time_names
1110 en_US