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