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