1
###################### mysql-test\t\lc_time_names_basic.test ##################
3
# Variable Name: lc_time_names #
4
# Scope: GLOBAL | SESSION #
5
# Access Type: Dynamic #
7
# Default Value: en_ZA #
11
# Creation Date: 2008-02-07 #
14
# Description: Test Cases of Dynamic System Variable lc_time_names #
15
# that checks the behavior of this variable in the following ways#
17
# * Valid & Invalid values #
18
# * Scope & Access method #
21
# Reference: http://dev.mysql.com/doc/refman/5.1/en/ #
22
# server-system-variables.html #
24
###############################################################################
26
--source include/load_sysvars.inc
27
###################################################
28
## START OF lc_time_names TESTS ##
29
###################################################
31
#############################################################
32
# Save initial value #
33
#############################################################
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;
48
--echo '#--------------------FN_DYNVARS_060_01------------------#'
49
###############################################################################
50
# Test Variable access and assignment with and withoud @@ #
51
###############################################################################
54
--error ER_BAD_FIELD_ERROR
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;
73
--echo '#--------------------FN_DYNVARS_060_02-------------------------#'
74
###############################################################################
75
# Check the DEFAULT value of lc_time_names for session and global #
76
###############################################################################
78
SET @@lc_time_names = en_ZA;
79
SET @@lc_time_names = DEFAULT;
80
SELECT @@lc_time_names AS DEFAULT_VALUE;
82
SET @@global.lc_time_names = en_ZA;
83
SET @@global.lc_time_names = DEFAULT;
84
SELECT @@global.lc_time_names;
86
--echo '#--------------------FN_DYNVARS_060_03-------------------------#'
87
##########################################################################
88
# see if setting global value changes session value and vice versa #
89
##########################################################################
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;
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;
101
SELECT @@global.lc_time_names=@@session.lc_time_names AS res_is_false;
104
--echo '#--------------------FN_DYNVARS_060_04-------------------------#'
105
###########################################################################
106
# Check if accessing variable with and without session point to session
108
###########################################################################
110
SELECT @@lc_time_names = @@session.lc_time_names AS res;
111
SELECT @@lc_time_names = @@local.lc_time_names AS res;
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 ;
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;
181
--Error ER_UNKNOWN_ERROR
182
SET @@session.lc_time_names=EE;
183
--echo 'Bug: The locale for Estonian - Estonia is not supported. It is present';
185
--echo 'See http://dev.mysql.com/doc/refman/5.1/en/locale-support.html'
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=sv_SE;
326
SELECT @@session.lc_time_names;
327
SET @@session.lc_time_names=ta_IN;
328
SELECT @@session.lc_time_names;
329
SET @@session.lc_time_names=te_IN;
330
SELECT @@session.lc_time_names;
331
SET @@session.lc_time_names=th_TH;
332
SELECT @@session.lc_time_names;
333
SET @@session.lc_time_names=tr_TR;
334
SELECT @@session.lc_time_names;
335
SET @@session.lc_time_names=uk_UA;
336
SELECT @@session.lc_time_names;
337
SET @@session.lc_time_names=ur_PK;
338
SELECT @@session.lc_time_names;
339
SET @@session.lc_time_names=vi_VN;
340
SELECT @@session.lc_time_names;
341
SET @@session.lc_time_names=zh_CN;
342
SELECT @@session.lc_time_names;
343
SET @@session.lc_time_names=zh_HK;
344
SELECT @@session.lc_time_names;
345
SET @@session.lc_time_names=zh_TW;
346
SELECT @@session.lc_time_names;
349
--echo '#--------------------FN_DYNVARS_060_07-------------------------#'
350
##########################################################################
351
# Change the value of lc_time_names to a valid value for global #
352
##########################################################################
353
SET @@global.lc_time_names=ar_AE;
354
SELECT @@global.lc_time_names;
355
SET @@global.lc_time_names=ar_BH;
356
SELECT @@global.lc_time_names;
357
SET @@global.lc_time_names=ar_DZ;
358
SELECT @@global.lc_time_names;
359
SET @@global.lc_time_names=ar_EG;
360
SELECT @@global.lc_time_names;
361
SET @@global.lc_time_names=ar_IN;
362
SELECT @@global.lc_time_names;
363
SET @@global.lc_time_names=ar_IQ;
364
SELECT @@global.lc_time_names;
365
SET @@global.lc_time_names=ar_JO;
366
SELECT @@global.lc_time_names;
367
SET @@global.lc_time_names=ar_KW;
368
SELECT @@global.lc_time_names;
369
SET @@global.lc_time_names=ar_LB;
370
SELECT @@global.lc_time_names;
371
SET @@global.lc_time_names=ar_LY;
372
SELECT @@global.lc_time_names;
373
SET @@global.lc_time_names=ar_MA;
374
SELECT @@global.lc_time_names;
375
SET @@global.lc_time_names=ar_OM;
376
SELECT @@global.lc_time_names;
377
SET @@global.lc_time_names=ar_QA;
378
SELECT @@global.lc_time_names;
379
SET @@global.lc_time_names=ar_SA;
380
SELECT @@global.lc_time_names;
381
SET @@global.lc_time_names=ar_SD;
382
SELECT @@global.lc_time_names;
383
SET @@global.lc_time_names=ar_SY;
384
SELECT @@global.lc_time_names;
385
SET @@global.lc_time_names=ar_TN;
386
SELECT @@global.lc_time_names;
387
SET @@global.lc_time_names=ar_YE;
388
SELECT @@global.lc_time_names;
389
SET @@global.lc_time_names=be_BY;
390
SELECT @@global.lc_time_names;
391
SET @@global.lc_time_names=bg_BG;
392
SELECT @@global.lc_time_names;
393
SET @@global.lc_time_names=ca_ES;
394
SELECT @@global.lc_time_names;
395
SET @@global.lc_time_names=cs_CZ;
396
SELECT @@global.lc_time_names;
397
SET @@global.lc_time_names=da_DK;
398
SELECT @@global.lc_time_names;
399
SET @@global.lc_time_names=de_AT;
400
SELECT @@global.lc_time_names;
401
SET @@global.lc_time_names=de_BE;
402
SELECT @@global.lc_time_names;
403
SET @@global.lc_time_names=de_CH;
404
SELECT @@global.lc_time_names;
405
SET @@global.lc_time_names=de_DE;
406
SELECT @@global.lc_time_names;
407
SET @@global.lc_time_names=de_LU;
408
SELECT @@global.lc_time_names;
410
--Error ER_UNKNOWN_ERROR
411
SET @@global.lc_time_names=EE;
412
--echo 'Bug: The locale for Estonian - Estonia is not supported. It is';
413
--echo 'present in manual';
414
--echo 'See http://dev.mysql.com/doc/refman/5.1/en/locale-support.html';
417
SELECT @@global.lc_time_names;
418
SET @@global.lc_time_names=en_AU;
419
SELECT @@global.lc_time_names;
420
SET @@global.lc_time_names=en_CA;
421
SELECT @@global.lc_time_names;
422
SET @@global.lc_time_names=en_GB;
423
SELECT @@global.lc_time_names;
424
SET @@global.lc_time_names=en_IN;
425
SELECT @@global.lc_time_names;
426
SET @@global.lc_time_names=en_NZ;
427
SELECT @@global.lc_time_names;
428
SET @@global.lc_time_names=en_PH;
429
SELECT @@global.lc_time_names;
430
SET @@global.lc_time_names=en_US;
431
SELECT @@global.lc_time_names;
432
SET @@global.lc_time_names=en_ZA;
433
SELECT @@global.lc_time_names;
434
SET @@global.lc_time_names=en_ZW;
435
SELECT @@global.lc_time_names;
436
SET @@global.lc_time_names=es_AR;
437
SELECT @@global.lc_time_names;
438
SET @@global.lc_time_names=es_BO;
439
SELECT @@global.lc_time_names;
440
SET @@global.lc_time_names=es_CL;
441
SELECT @@global.lc_time_names;
442
SET @@global.lc_time_names=es_CO;
443
SELECT @@global.lc_time_names;
444
SET @@global.lc_time_names=es_CR;
445
SELECT @@global.lc_time_names;
446
SET @@global.lc_time_names=es_DO;
447
SELECT @@global.lc_time_names;
448
SET @@global.lc_time_names=es_EC;
449
SELECT @@global.lc_time_names;
450
SET @@global.lc_time_names=es_ES;
451
SELECT @@global.lc_time_names;
452
SET @@global.lc_time_names=es_GT;
453
SELECT @@global.lc_time_names;
454
SET @@global.lc_time_names=es_HN;
455
SELECT @@global.lc_time_names;
456
SET @@global.lc_time_names=es_MX;
457
SELECT @@global.lc_time_names;
458
SET @@global.lc_time_names=es_NI;
459
SELECT @@global.lc_time_names;
460
SET @@global.lc_time_names=es_PA;
461
SELECT @@global.lc_time_names;
462
SET @@global.lc_time_names=es_PE;
463
SELECT @@global.lc_time_names;
464
SET @@global.lc_time_names=es_PR;
465
SELECT @@global.lc_time_names;
466
SET @@global.lc_time_names=es_PY;
467
SELECT @@global.lc_time_names;
468
SET @@global.lc_time_names=es_SV;
469
SELECT @@global.lc_time_names;
470
SET @@global.lc_time_names=es_US;
471
SELECT @@global.lc_time_names;
472
SET @@global.lc_time_names=es_UY;
473
SELECT @@global.lc_time_names;
474
SET @@global.lc_time_names=es_VE;
475
SELECT @@global.lc_time_names;
476
SET @@global.lc_time_names=eu_ES;
477
SELECT @@global.lc_time_names;
478
SET @@global.lc_time_names=fi_FI;
479
SELECT @@global.lc_time_names;
480
SET @@global.lc_time_names=fo_FO;
481
SELECT @@global.lc_time_names;
482
SET @@global.lc_time_names=fr_BE;
483
SELECT @@global.lc_time_names;
484
SET @@global.lc_time_names=fr_CA;
485
SELECT @@global.lc_time_names;
486
SET @@global.lc_time_names=fr_CH;
487
SELECT @@global.lc_time_names;
488
SET @@global.lc_time_names=fr_FR;
489
SELECT @@global.lc_time_names;
490
SET @@global.lc_time_names=fr_LU;
491
SELECT @@global.lc_time_names;
492
SET @@global.lc_time_names=gl_ES;
493
SELECT @@global.lc_time_names;
494
SET @@global.lc_time_names=gu_IN;
495
SELECT @@global.lc_time_names;
496
SET @@global.lc_time_names=he_IL;
497
SELECT @@global.lc_time_names;
498
SET @@global.lc_time_names=hi_IN;
499
SELECT @@global.lc_time_names;
500
SET @@global.lc_time_names=hr_HR;
501
SELECT @@global.lc_time_names;
502
SET @@global.lc_time_names=hu_HU;
503
SELECT @@global.lc_time_names;
504
SET @@global.lc_time_names=id_ID;
505
SELECT @@global.lc_time_names;
506
SET @@global.lc_time_names=is_IS;
507
SELECT @@global.lc_time_names;
508
SET @@global.lc_time_names=it_CH;
509
SELECT @@global.lc_time_names;
510
SET @@global.lc_time_names=it_IT;
511
SELECT @@global.lc_time_names;
512
SET @@global.lc_time_names=ja_JP;
513
SELECT @@global.lc_time_names;
514
SET @@global.lc_time_names=ko_KR;
515
SELECT @@global.lc_time_names;
516
SET @@global.lc_time_names=lt_LT;
517
SELECT @@global.lc_time_names;
518
SET @@global.lc_time_names=lv_LV;
519
SELECT @@global.lc_time_names;
520
SET @@global.lc_time_names=mk_MK;
521
SELECT @@global.lc_time_names;
522
SET @@global.lc_time_names=mn_MN;
523
SELECT @@global.lc_time_names;
524
SET @@global.lc_time_names=ms_MY;
525
SELECT @@global.lc_time_names;
526
SET @@global.lc_time_names=nb_NO;
527
SELECT @@global.lc_time_names;
528
SET @@global.lc_time_names=nl_BE;
529
SELECT @@global.lc_time_names;
530
SET @@global.lc_time_names=nl_NL;
531
SELECT @@global.lc_time_names;
532
SET @@global.lc_time_names=no_NO;
533
SELECT @@global.lc_time_names;
534
SET @@global.lc_time_names=pl_PL;
535
SELECT @@global.lc_time_names;
536
SET @@global.lc_time_names=pt_BR;
537
SELECT @@global.lc_time_names;
538
SET @@global.lc_time_names=pt_PT;
539
SELECT @@global.lc_time_names;
540
SET @@global.lc_time_names=ro_RO;
541
SELECT @@global.lc_time_names;
542
SET @@global.lc_time_names=ru_RU;
543
SELECT @@global.lc_time_names;
544
SET @@global.lc_time_names=ru_UA;
545
SELECT @@global.lc_time_names;
546
SET @@global.lc_time_names=sk_SK;
547
SELECT @@global.lc_time_names;
548
SET @@global.lc_time_names=sl_SI;
549
SELECT @@global.lc_time_names;
550
SET @@global.lc_time_names=sq_AL;
551
SELECT @@global.lc_time_names;
552
SET @@global.lc_time_names=sr_YU;
553
SELECT @@global.lc_time_names;
554
SET @@global.lc_time_names=sv_FI;
555
SELECT @@global.lc_time_names;
556
SET @@global.lc_time_names=sv_SE;
557
SELECT @@global.lc_time_names;
558
SET @@global.lc_time_names=ta_IN;
559
SELECT @@global.lc_time_names;
560
SET @@global.lc_time_names=te_IN;
561
SELECT @@global.lc_time_names;
562
SET @@global.lc_time_names=th_TH;
563
SELECT @@global.lc_time_names;
564
SET @@global.lc_time_names=tr_TR;
565
SELECT @@global.lc_time_names;
566
SET @@global.lc_time_names=uk_UA;
567
SELECT @@global.lc_time_names;
568
SET @@global.lc_time_names=ur_PK;
569
SELECT @@global.lc_time_names;
570
SET @@global.lc_time_names=vi_VN;
571
SELECT @@global.lc_time_names;
572
SET @@global.lc_time_names=zh_CN;
573
SELECT @@global.lc_time_names;
574
SET @@global.lc_time_names=zh_HK;
575
SELECT @@global.lc_time_names;
576
SET @@global.lc_time_names=zh_TW;
577
SELECT @@global.lc_time_names;
580
--echo '#--------------------FN_DYNVARS_060_08-------------------------#'
581
##########################################################################
582
# Change the value of lc_time_names to a valid value with uppercase,
583
# lowercase and mixedcase
584
##########################################################################
586
SET @@lc_time_names = ur_pk;
587
SELECT @@lc_time_names;
588
SET @@lc_time_names = UR_PK;
589
SELECT @@lc_time_names;
590
SET @@lc_time_names = uR_pK;
591
SELECT @@lc_time_names;
594
--echo '#--------------------FN_DYNVARS_060_09-------------------------#'
595
##############################################################
596
# Check if 0,1,2,3, ... values can be used on variable #
597
##############################################################
599
SET @@lc_time_names = 0;
600
SELECT @@lc_time_names;
601
SET @@lc_time_names = 1;
602
SELECT @@lc_time_names;
603
SET @@lc_time_names = 2;
604
SELECT @@lc_time_names;
605
SET @@lc_time_names = 3;
606
SELECT @@lc_time_names;
607
SET @@lc_time_names = 10;
608
SELECT @@lc_time_names;
609
SET @@lc_time_names = 50;
610
SELECT @@lc_time_names;
611
SET @@lc_time_names = 100;
612
SELECT @@lc_time_names;
613
SET @@lc_time_names = 101;
614
SELECT @@lc_time_names;
615
SET @@lc_time_names = 107;
616
SELECT @@lc_time_names;
617
SET @@lc_time_names = 108;
618
SELECT @@lc_time_names;
620
--Error ER_UNKNOWN_ERROR
621
SET @@lc_time_names = 109;
624
--echo '#--------------------FN_DYNVARS_060_10-------------------------#'
625
#############################################################################
626
# Change the value of lc_time_names to an invalid value for session #
627
#############################################################################
629
--Error ER_UNKNOWN_ERROR
630
SET @@lc_time_names = en_EN;
631
--Error ER_UNKNOWN_ERROR
632
SET @@lc_time_names = US_en;
633
--Error ER_WRONG_TYPE_FOR_VAR
634
SET @@lc_time_names = 1.1;
635
--Error ER_UNKNOWN_ERROR
636
SET @@lc_time_names = -1;
637
--Error ER_UNKNOWN_ERROR
638
SET @@lc_time_names = 'en US';
639
--Error ER_UNKNOWN_ERROR
640
SET @@lc_time_names = 'enUS';
642
SET @@lc_time_names = true;
643
SELECT @@lc_time_names AS res_with_true;
644
SET @@lc_time_names = false;
645
SELECT @@lc_time_names AS res_with_false;
647
--Error ER_UNKNOWN_ERROR
648
SET @@lc_time_names = ON;
651
--echo '#--------------------FN_DYNVARS_060_11-------------------------#'
652
############################################################################
653
# Change the value of lc_time_names to an invalid value for global #
654
############################################################################
656
--Error ER_UNKNOWN_ERROR
657
SET @@global.lc_time_names = en_EN;
658
--Error ER_UNKNOWN_ERROR
659
SET @@global.lc_time_names = US_en;
660
--Error ER_WRONG_TYPE_FOR_VAR
661
SET @@global.lc_time_names = 1.1;
662
--Error ER_UNKNOWN_ERROR
663
SET @@global.lc_time_names = -1;
664
--Error ER_WRONG_VALUE_FOR_VAR
665
SET @@global.lc_time_names = NULL;
666
--Error ER_UNKNOWN_ERROR
667
SET @@global.lc_time_names = 'enUS';
669
SET @@global.lc_time_names = true;
670
SELECT @@global.lc_time_names;
671
SET @@global.lc_time_names = false;
672
SELECT @@global.lc_time_names;
674
--Error ER_UNKNOWN_ERROR
675
SET @@global.lc_time_names = ON;
677
--echo '#--------------------FN_DYNVARS_060_12-------------------------#'
678
##############################################################################
679
# Check if the value in GLOBAL Table matches value in variable #
680
##############################################################################
681
SELECT @@global.lc_time_names = (SELECT VARIABLE_VALUE
682
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
683
WHERE VARIABLE_NAME='lc_time_names') AS res;
684
SET @@global.lc_time_names = 1;
685
SELECT @@global.lc_time_names;
686
SELECT @@global.lc_time_names = (SELECT VARIABLE_VALUE
687
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
688
WHERE VARIABLE_NAME='lc_time_names') AS res;
690
--echo '#--------------------FN_DYNVARS_060_13-------------------------#'
691
##############################################################################
692
# Check if the value in SESSION Table matches value in variable #
693
##############################################################################
694
SELECT @@lc_time_names = (SELECT VARIABLE_VALUE
695
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
696
WHERE VARIABLE_NAME='lc_time_names') AS res;
697
SELECT @@local.lc_time_names = (SELECT VARIABLE_VALUE
698
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
699
WHERE VARIABLE_NAME='lc_time_names') AS res;
700
SELECT @@session.lc_time_names = (SELECT VARIABLE_VALUE
701
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
702
WHERE VARIABLE_NAME='lc_time_names') AS res;
704
####################################
705
# Restore initial value #
706
####################################
707
SET @@global.lc_time_names = @global_start_value;
708
SELECT @@global.lc_time_names;
709
SET @@session.lc_time_names = @session_start_value;
710
SELECT @@session.lc_time_names;
712
#############################################################
713
# END OF lc_time_names TESTS #
714
#############################################################