[ Avaa Bypassed ]

Upload:

Command:

hmhc3928@18.223.238.150: ~ $ 
###################### mysql-test\t\lc_time_names_basic.test ##################
#                                                                             #
# Variable Name: lc_time_names                                                #
# Scope: GLOBAL | SESSION                                                     #
# Access Type: Dynamic                                                        #
# Data Type: string                                                           #
# Default Value: en_ZA                                                        #
# Range: NA                                                                   #
#                                                                             #
#                                                                             #
# Creation Date: 2008-02-07                                                   #
# Author:  Rizwan                                                             #
#                                                                             #
# Description: Test Cases of Dynamic System Variable lc_time_names            #
#              that checks the behavior of this variable in the following ways#
#              * Default Value                                                #
#              * Valid & Invalid values                                       #
#              * Scope & Access method                                        #
#              * Data Integrity                                               #
#                                                                             #
# Reference: http://dev.mysql.com/doc/refman/5.1/en/                          #
#  server-system-variables.html                                               #
#                                                                             #
###############################################################################

--source include/load_sysvars.inc
###################################################
##       START OF lc_time_names TESTS            ##
###################################################

#############################################################
#                 Save initial value                        #
#############################################################

SET @global_start_value = @@global.lc_time_names;
SELECT @global_start_value;
# Save initial session value
SET @session_start_value = @@lc_time_names;
SELECT @session_start_value;
# now save using local access 
SET @session_start_value = @@local.lc_time_names;
SELECT @session_start_value;
# save using default access (session)
SET @session_start_value = @@session.lc_time_names;
SELECT @session_start_value;


--echo '#--------------------FN_DYNVARS_060_01------------------#'
###############################################################################
#       Test Variable access and assignment with and withoud @@               #
###############################################################################

# select without @@
--error ER_BAD_FIELD_ERROR
SELECT lc_time_names;
# assign value without @@
SET lc_time_names=ar_AE;
SELECT @@session.lc_time_names;
# assign global variable without @@
--Error ER_PARSE_ERROR
SET global.lc_time_names=ar_AE;
# using another syntax for accessing session variable
SET session lc_time_names=ar_AE;
# accessing variable with scope the wrong way
--Error ER_BAD_FIELD_ERROR
SELECT session lc_time_names;
# using another syntax for accessing dynamic variable
SET global lc_time_names=ar_AE;
--Error ER_BAD_FIELD_ERROR
SELECT global lc_time_names;


--echo '#--------------------FN_DYNVARS_060_02-------------------------#'
###############################################################################
#     Check the DEFAULT value of lc_time_names for session and global         #
###############################################################################

SET @@lc_time_names = en_ZA;
SET @@lc_time_names = DEFAULT;
SELECT @@lc_time_names AS DEFAULT_VALUE;

SET @@global.lc_time_names = en_ZA;
SET @@global.lc_time_names = DEFAULT;
SELECT @@global.lc_time_names;

--echo '#--------------------FN_DYNVARS_060_03-------------------------#'
##########################################################################
#     see if setting global value changes session value and vice versa   #
##########################################################################

SET @@session.lc_time_names = en_IN;
SELECT @@session.lc_time_names;
SET @@global.lc_time_names = en_NZ;
SELECT @@global.lc_time_names;
SELECT @@session.lc_time_names AS res_is_en_IN;

SET @@session.lc_time_names = en_AU;
SELECT @@session.lc_time_names;
SELECT @@global.lc_time_names AS res_is_en_NZ;
# composite check
SELECT @@global.lc_time_names=@@session.lc_time_names AS res_is_false;


--echo '#--------------------FN_DYNVARS_060_04-------------------------#'
###########################################################################
#     Check if accessing variable with and without session point to session
#     variable     
###########################################################################

SELECT @@lc_time_names = @@session.lc_time_names AS res;
SELECT @@lc_time_names = @@local.lc_time_names AS res;

--echo '#--------------------FN_DYNVARS_060_05-------------------------#'
###########################################################################
#     Check if combining character set works                              #
###########################################################################
--Error ER_BAD_FIELD_ERROR
SET @@lc_time_names = en_US | en_GB ;

--echo '#--------------------FN_DYNVARS_060_06-------------------------#'
###########################################################################
#     Change the value of lc_time_names to a valid value for session      #
###########################################################################
SET @@session.lc_time_names=ar_AE;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=ar_BH;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=ar_DZ;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=ar_EG;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=ar_IN;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=ar_IQ;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=ar_JO;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=ar_KW;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=ar_LB;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=ar_LY;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=ar_MA;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=ar_OM;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=ar_QA;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=ar_SA;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=ar_SD;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=ar_SY;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=ar_TN;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=ar_YE;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=be_BY;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=bg_BG;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=ca_ES;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=cs_CZ;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=da_DK;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=de_AT;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=de_BE;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=de_CH;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=de_DE;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=de_LU;
SELECT @@session.lc_time_names;

--error ER_UNKNOWN_LOCALE
SET @@session.lc_time_names=EE;
--echo 'Bug: The locale for Estonian - Estonia is not supported. It is present';
--echo 'in manual';
--echo 'See http://dev.mysql.com/doc/refman/5.1/en/locale-support.html'

SET @@session.lc_time_names=en_AU;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=en_CA;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=en_GB;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=en_IN;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=en_NZ;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=en_PH;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=en_US;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=en_ZA;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=en_ZW;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=es_AR;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=es_BO;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=es_CL;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=es_CO;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=es_CR;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=es_DO;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=es_EC;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=es_ES;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=es_GT;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=es_HN;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=es_MX;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=es_NI;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=es_PA;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=es_PE;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=es_PR;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=es_PY;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=es_SV;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=es_US;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=es_UY;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=es_VE;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=eu_ES;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=fi_FI;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=fo_FO;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=fr_BE;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=fr_CA;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=fr_CH;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=fr_FR;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=fr_LU;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=gl_ES;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=gu_IN;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=he_IL;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=hi_IN;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=hr_HR;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=hu_HU;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=id_ID;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=is_IS;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=it_CH;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=it_IT;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=ja_JP;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=ko_KR;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=lt_LT;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=lv_LV;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=mk_MK;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=mn_MN;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=ms_MY;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=nb_NO;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=nl_BE;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=nl_NL;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=no_NO;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=pl_PL;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=pt_BR;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=pt_PT;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=ro_RO;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=ru_RU;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=ru_UA;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=sk_SK;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=sl_SI;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=sq_AL;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=sr_YU;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=sv_FI;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=sr_RS;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=sv_SE;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=ta_IN;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=te_IN;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=th_TH;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=tr_TR;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=uk_UA;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=ur_PK;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=vi_VN;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=zh_CN;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=zh_HK;
SELECT @@session.lc_time_names;
SET @@session.lc_time_names=zh_TW;
SELECT @@session.lc_time_names;


--echo '#--------------------FN_DYNVARS_060_07-------------------------#'
##########################################################################
#     Change the value of lc_time_names to a valid value for global      #
##########################################################################
SET @@global.lc_time_names=ar_AE;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=ar_BH;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=ar_DZ;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=ar_EG;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=ar_IN;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=ar_IQ;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=ar_JO;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=ar_KW;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=ar_LB;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=ar_LY;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=ar_MA;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=ar_OM;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=ar_QA;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=ar_SA;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=ar_SD;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=ar_SY;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=ar_TN;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=ar_YE;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=be_BY;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=bg_BG;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=ca_ES;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=cs_CZ;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=da_DK;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=de_AT;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=de_BE;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=de_CH;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=de_DE;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=de_LU;
SELECT @@global.lc_time_names;

--error ER_UNKNOWN_LOCALE
SET @@global.lc_time_names=EE;
--echo 'Bug: The locale for Estonian - Estonia is not supported. It is';
--echo 'present in manual';
--echo 'See http://dev.mysql.com/doc/refman/5.1/en/locale-support.html';


SELECT @@global.lc_time_names;
SET @@global.lc_time_names=en_AU;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=en_CA;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=en_GB;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=en_IN;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=en_NZ;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=en_PH;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=en_US;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=en_ZA;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=en_ZW;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=es_AR;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=es_BO;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=es_CL;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=es_CO;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=es_CR;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=es_DO;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=es_EC;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=es_ES;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=es_GT;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=es_HN;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=es_MX;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=es_NI;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=es_PA;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=es_PE;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=es_PR;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=es_PY;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=es_SV;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=es_US;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=es_UY;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=es_VE;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=eu_ES;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=fi_FI;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=fo_FO;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=fr_BE;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=fr_CA;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=fr_CH;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=fr_FR;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=fr_LU;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=gl_ES;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=gu_IN;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=he_IL;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=hi_IN;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=hr_HR;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=hu_HU;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=id_ID;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=is_IS;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=it_CH;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=it_IT;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=ja_JP;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=ko_KR;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=lt_LT;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=lv_LV;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=mk_MK;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=mn_MN;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=ms_MY;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=nb_NO;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=nl_BE;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=nl_NL;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=no_NO;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=pl_PL;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=pt_BR;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=pt_PT;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=ro_RO;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=ru_RU;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=ru_UA;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=sk_SK;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=sl_SI;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=sq_AL;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=sr_YU;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=sv_FI;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=sr_RS;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=sv_SE;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=ta_IN;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=te_IN;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=th_TH;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=tr_TR;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=uk_UA;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=ur_PK;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=vi_VN;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=zh_CN;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=zh_HK;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names=zh_TW;
SELECT @@global.lc_time_names;


--echo '#--------------------FN_DYNVARS_060_08-------------------------#'
##########################################################################
#     Change the value of lc_time_names to a valid value with uppercase,
#     lowercase and mixedcase     
##########################################################################

SET @@lc_time_names = ur_pk;
SELECT @@lc_time_names;
SET @@lc_time_names = UR_PK;
SELECT @@lc_time_names;
SET @@lc_time_names = uR_pK;
SELECT @@lc_time_names;


--echo '#--------------------FN_DYNVARS_060_09-------------------------#'
##############################################################
#     Check if 0,1,2,3, ... values can be used on variable   #
##############################################################

SET @@lc_time_names = 0;
SELECT @@lc_time_names;
SET @@lc_time_names = 1;
SELECT @@lc_time_names;
SET @@lc_time_names = 2;
SELECT @@lc_time_names;
SET @@lc_time_names = 3;
SELECT @@lc_time_names;
SET @@lc_time_names = 10;
SELECT @@lc_time_names;
SET @@lc_time_names = 50;
SELECT @@lc_time_names;
SET @@lc_time_names = 100;
SELECT @@lc_time_names;
SET @@lc_time_names = 101;
SELECT @@lc_time_names;
SET @@lc_time_names = 107;
SELECT @@lc_time_names;
SET @@lc_time_names = 108;
SELECT @@lc_time_names;
SET @@lc_time_names = 109;
SELECT @@lc_time_names;
SET @@lc_time_names = 110;
SELECT @@lc_time_names;
--Error ER_UNKNOWN_LOCALE
SET @@lc_time_names = 111;

--echo '#--------------------FN_DYNVARS_060_10-------------------------#'
#############################################################################
#     Change the value of lc_time_names to an invalid value for session     #
#############################################################################

--Error ER_UNKNOWN_LOCALE
SET @@lc_time_names = en_EN;
--Error ER_UNKNOWN_LOCALE
SET @@lc_time_names = US_en;
--Error ER_WRONG_TYPE_FOR_VAR
SET @@lc_time_names = 1.1;
--Error ER_UNKNOWN_LOCALE
SET @@lc_time_names = -1;
--Error ER_UNKNOWN_LOCALE
SET @@lc_time_names = 'en US';
--Error ER_UNKNOWN_LOCALE
SET @@lc_time_names = 'enUS';

SET @@lc_time_names = true;
SELECT @@lc_time_names AS res_with_true;
SET @@lc_time_names = false;
SELECT @@lc_time_names AS res_with_false;

--Error ER_UNKNOWN_LOCALE
SET @@lc_time_names = ON;


--echo '#--------------------FN_DYNVARS_060_11-------------------------#'
############################################################################
#     Change the value of lc_time_names to an invalid value for global     #
############################################################################

--Error ER_UNKNOWN_LOCALE
SET @@global.lc_time_names = en_EN;
--Error ER_UNKNOWN_LOCALE
SET @@global.lc_time_names = US_en;
--Error ER_WRONG_TYPE_FOR_VAR
SET @@global.lc_time_names = 1.1;
--Error ER_UNKNOWN_LOCALE
SET @@global.lc_time_names = -1;
--Error ER_WRONG_VALUE_FOR_VAR
SET @@global.lc_time_names = NULL;
--Error ER_UNKNOWN_LOCALE
SET @@global.lc_time_names = 'enUS';

SET @@global.lc_time_names = true;
SELECT @@global.lc_time_names;
SET @@global.lc_time_names = false;
SELECT @@global.lc_time_names;

--Error ER_UNKNOWN_LOCALE
SET @@global.lc_time_names = ON;

--echo '#--------------------FN_DYNVARS_060_12-------------------------#'
##############################################################################
#     Check if the value in GLOBAL Table matches value in variable           #
##############################################################################
SELECT @@global.lc_time_names = (SELECT VARIABLE_VALUE 
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 
WHERE VARIABLE_NAME='lc_time_names') AS res;
SET @@global.lc_time_names = 1;
SELECT @@global.lc_time_names;
SELECT @@global.lc_time_names = (SELECT VARIABLE_VALUE 
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 
WHERE VARIABLE_NAME='lc_time_names') AS res;

--echo '#--------------------FN_DYNVARS_060_13-------------------------#'
##############################################################################
#     Check if the value in SESSION Table matches value in variable          #
##############################################################################
SELECT @@lc_time_names = (SELECT VARIABLE_VALUE 
FROM INFORMATION_SCHEMA.SESSION_VARIABLES 
WHERE VARIABLE_NAME='lc_time_names') AS res;
SELECT @@local.lc_time_names = (SELECT VARIABLE_VALUE 
FROM INFORMATION_SCHEMA.SESSION_VARIABLES 
WHERE VARIABLE_NAME='lc_time_names') AS res;
SELECT @@session.lc_time_names = (SELECT VARIABLE_VALUE 
FROM INFORMATION_SCHEMA.SESSION_VARIABLES 
WHERE VARIABLE_NAME='lc_time_names') AS res;

####################################
#     Restore initial value        #
####################################
SET @@global.lc_time_names = @global_start_value;
SELECT @@global.lc_time_names;
SET @@session.lc_time_names = @session_start_value;
SELECT @@session.lc_time_names;

#############################################################
#                 END OF lc_time_names TESTS                #
#############################################################

Filemanager

DIR : / usr/ share/ mysql-test/ suite/ sys_vars/ t/
Name Type Size Permission Actions
all_vars-master.opt File 57 B 0644
all_vars.test File 3.14 KB 0644
auto_increment_increment_basic.test File 9.24 KB 0644
auto_increment_increment_func.test File 7.89 KB 0644
auto_increment_offset_basic.test File 9.35 KB 0644
auto_increment_offset_func.test File 7.84 KB 0644
autocommit_basic.test File 7.75 KB 0644
autocommit_func.test File 5.77 KB 0644
autocommit_func2-master.opt File 15 B 0644
autocommit_func2.test File 49 B 0644
autocommit_func3-master.opt File 15 B 0644
autocommit_func3.test File 49 B 0644
autocommit_func4-master.opt File 16 B 0644
autocommit_func4.test File 49 B 0644
autocommit_func5-master.opt File 17 B 0644
autocommit_func5.test File 49 B 0644
automatic_sp_privileges_basic.test File 8.23 KB 0644
automatic_sp_privileges_func.test File 4.31 KB 0644
avoid_temporal_upgrade_basic.test File 1.37 KB 0644
back_log_basic.test File 533 B 0644
basedir_basic.test File 4.07 KB 0644
big_tables_basic.test File 7 KB 0644
bind_address_basic.test File 3.15 KB 0644
binlog_cache_size_basic_32.test File 495 B 0644
binlog_cache_size_basic_64.test File 495 B 0644
binlog_checksum_basic.test File 767 B 0644
binlog_direct_non_transactional_updates_basic.test File 4.49 KB 0644
binlog_error_action_basic.test File 3.05 KB 0644
binlog_format_basic.test File 4.53 KB 0644
binlog_gtid_simple_recovery_basic.test File 758 B 0644
binlog_max_flush_queue_time_basic.test File 989 B 0644
binlog_order_commits_basic.test File 7.54 KB 0644
binlog_row_image_basic.test File 4.75 KB 0644
binlog_rows_query_log_events_basic.test File 4.23 KB 0644
binlog_stmt_cache_size_basic_32.test File 338 B 0644
binlog_stmt_cache_size_basic_64.test File 338 B 0644
binlogging_impossible_mode_basic.test File 3.16 KB 0644
block_encryption_mode_basic.test File 9.41 KB 0644
bulk_insert_buffer_size_basic_32.test File 501 B 0644
bulk_insert_buffer_size_basic_64.test File 501 B 0644
character_set_client_basic.test File 14.85 KB 0644
character_set_client_func.test File 3.61 KB 0644
character_set_connection_basic.test File 12.83 KB 0644
character_set_connection_func.test File 4.89 KB 0644
character_set_database_basic.test File 12.55 KB 0644
character_set_database_func.test File 5.37 KB 0644
character_set_filesystem_basic.test File 12.18 KB 0644
character_set_filesystem_func-master.opt File 44 B 0644
character_set_results_basic.test File 12.61 KB 0644
character_set_results_func.test File 4.4 KB 0644
character_set_server_basic.test File 12.19 KB 0644
character_set_server_func.test File 4.54 KB 0644
character_set_system_basic.test File 4.26 KB 0644
character_sets_dir_basic.test File 1.14 KB 0644
collation_connection_basic.test File 12.33 KB 0644
collation_connection_func.test File 4.66 KB 0644
collation_database_basic.test File 12.22 KB 0644
collation_database_func.test File 5.88 KB 0644
collation_server_basic.test File 11.92 KB 0644
collation_server_func.test File 5.1 KB 0644
completion_type_basic.test File 7.72 KB 0644
completion_type_func.test File 5.74 KB 0644
concurrent_insert_basic.test File 7.92 KB 0644
concurrent_insert_func.test File 6.23 KB 0644
connect_timeout_basic.test File 6.72 KB 0644
core_file_basic-master.opt File 13 B 0644
core_file_basic.test File 122 B 0644
datadir_basic.test File 4.07 KB 0644
date_format_basic.test File 564 B 0644
datetime_format_basic.test File 596 B 0644
debug_basic.test File 670 B 0644
debug_sync_basic.test File 595 B 0644
default_storage_engine_basic.test File 7.45 KB 0644
default_tmp_storage_engine_basic.test File 7.21 KB 0644
default_week_format_basic.test File 8.8 KB 0644
default_week_format_func.test File 3 KB 0644
delay_key_write_basic.test File 7.01 KB 0644
delay_key_write_func-master.opt File 31 B 0644
delay_key_write_func.test File 5.05 KB 0644
delayed_insert_limit_basic_32.test File 498 B 0644
delayed_insert_limit_basic_64.test File 498 B 0644
delayed_insert_limit_func.test File 8.39 KB 0644
delayed_insert_timeout_basic.test File 7.72 KB 0644
delayed_queue_size_basic_32.test File 496 B 0644
delayed_queue_size_basic_64.test File 496 B 0644
disabled.def File 651 B 0644
disconnect_on_expired_password_basic.test File 721 B 0644
div_precision_increment_basic.test File 9.52 KB 0644
div_precision_increment_func.test File 4.85 KB 0644
end_markers_in_json_basic.test File 1.33 KB 0644
enforce_gtid_consistency_basic.test File 943 B 0644
eq_range_index_dive_limit_basic.test File 2.16 KB 0644
error_count_basic.test File 4.07 KB 0644
event_scheduler_basic.test File 7.4 KB 0644
expire_logs_days_basic.test File 7.53 KB 0644
explicit_defaults_for_timestamp_basic.test File 684 B 0644
external_user_basic.test File 42 B 0644
flush_basic.test File 6.76 KB 0644
flush_time_basic.test File 955 B 0644
foreign_key_checks_basic.test File 7.46 KB 0644
foreign_key_checks_func.test File 4.86 KB 0644
ft_boolean_syntax_basic.test File 7.42 KB 0644
ft_boolean_syntax_func.test File 5.06 KB 0644
ft_max_word_len_basic.test File 565 B 0644
ft_min_word_len_basic.test File 565 B 0644
ft_query_expansion_limit_basic.test File 637 B 0644
ft_stopword_file_basic.test File 573 B 0644
general_log_basic.test File 7.05 KB 0644
general_log_file_basic-master.opt File 42 B 0644
general_log_file_basic.test File 3.93 KB 0644
general_log_file_func-master.opt File 49 B 0644
general_log_file_func.test File 2.52 KB 0644
general_log_func.test File 4.01 KB 0644
group_concat_max_len_basic.test File 8.99 KB 0644
group_concat_max_len_func.test File 6.14 KB 0644
gtid_executed_basic.test File 670 B 0644
gtid_mode_basic.test File 739 B 0644
gtid_next_basic.test File 799 B 0644
gtid_owned_basic.test File 676 B 0644
gtid_purged_basic.test File 786 B 0644
have_compress_basic.test File 4.16 KB 0644
have_crypt_basic.test File 4.11 KB 0644
have_dynamic_loading_basic.test File 4.26 KB 0644
have_geometry_basic.test File 4.16 KB 0644
have_openssl_basic.test File 4.14 KB 0644
have_profiling_basic.test File 645 B 0644
have_query_cache_basic.test File 4.2 KB 0644
have_rtree_keys_basic.test File 4.19 KB 0644
have_ssl_basic.test File 4.08 KB 0644
have_symlink_basic.test File 4.14 KB 0644
host_cache_size_basic-master.opt File 22 B 0644
host_cache_size_basic.test File 795 B 0644
hostname_basic.test File 4.08 KB 0644
identity_basic.test File 7.57 KB 0644
identity_func-master.opt File 10 B 0644
identity_func.test File 4.71 KB 0644
ignore_builtin_innodb_basic.test File 613 B 0644
ignore_db_dirs_basic-master.opt File 216 B 0644
ignore_db_dirs_basic.test File 649 B 0644
init_connect_basic.test File 6.74 KB 0644
init_file_basic.test File 517 B 0644
init_slave_basic.test File 6.48 KB 0644
innodb_adaptive_flushing_basic.test File 2.72 KB 0644
innodb_adaptive_flushing_lwm_basic.test File 6.78 KB 0644
innodb_adaptive_hash_index_basic.test File 2.79 KB 0644
innodb_adaptive_max_sleep_delay_basic.test File 3.17 KB 0644
innodb_additional_mem_pool_size_basic.test File 4.47 KB 0644
innodb_api_bk_commit_interval_basic.test File 1.74 KB 0644
innodb_api_disable_rowlock_basic.test File 4.41 KB 0644
innodb_api_enable_binlog_basic.test File 4.38 KB 0644
innodb_api_enable_mdl_basic.test File 4.33 KB 0644
innodb_api_trx_level_basic.test File 1.54 KB 0644
innodb_autoextend_increment_basic.test File 6.67 KB 0644
innodb_autoinc_lock_mode_basic.test File 4.16 KB 0644
innodb_autoinc_lock_mode_func-master.opt File 30 B 0644
innodb_autoinc_lock_mode_func.test File 2.81 KB 0644
innodb_buf_flush_list_now_basic.test File 725 B 0644
innodb_buffer_pool_dump_at_shutdown_basic.test File 1.13 KB 0644
innodb_buffer_pool_dump_now_basic.test File 725 B 0644
innodb_buffer_pool_evict_basic.test File 269 B 0644
innodb_buffer_pool_filename_basic-master.opt File 16 B 0644
innodb_buffer_pool_filename_basic.test File 1.55 KB 0644
innodb_buffer_pool_instances_basic.test File 4.5 KB 0644
innodb_buffer_pool_load_abort_basic.test File 335 B 0644
innodb_buffer_pool_load_at_startup_basic.test File 416 B 0644
innodb_buffer_pool_load_now_basic.test File 1.21 KB 0644
innodb_buffer_pool_size_basic.test File 4.34 KB 0644
innodb_change_buffer_max_size_basic.test File 2.17 KB 0644
innodb_change_buffering_basic.test File 1.97 KB 0644
innodb_change_buffering_debug_basic.test File 2.06 KB 0644
innodb_checksum_algorithm_basic.test File 1.12 KB 0644
innodb_checksums_basic.test File 4.25 KB 0644
innodb_cmp_per_index_enabled_basic.test File 1.73 KB 0644
innodb_commit_concurrency_basic.test File 6.1 KB 0644
innodb_compression_failure_threshold_pct_basic.test File 7.45 KB 0644
innodb_compression_level_basic.test File 1.91 KB 0644
innodb_compression_pad_pct_max_basic.test File 6.82 KB 0644
innodb_concurrency_tickets_basic.test File 6.71 KB 0644
innodb_data_file_path_basic.test File 4.31 KB 0644
innodb_data_home_dir_basic.test File 4.29 KB 0644
innodb_disable_background_merge_basic.test File 260 B 0644
innodb_disable_sort_file_cache_basic.test File 2.93 KB 0644
innodb_doublewrite_basic.test File 4.28 KB 0644
innodb_doublewrite_batch_size_basic.test File 824 B 0644
innodb_fast_shutdown_basic.test File 8.07 KB 0644
innodb_fil_make_page_dirty_debug_basic.test File 917 B 0644
innodb_file_format_basic.test File 1.67 KB 0644
innodb_file_format_check_basic.test File 2.6 KB 0644
innodb_file_format_max_basic-master.opt File 16 B 0644
innodb_file_format_max_basic.test File 1.8 KB 0644
innodb_file_io_threads_basic.test File 5.63 KB 0644
innodb_file_per_table_basic-master.opt File 27 B 0644
innodb_file_per_table_basic.test File 4.61 KB 0644
innodb_flush_log_at_timeout_basic.test File 6.83 KB 0644
innodb_flush_log_at_trx_commit_basic.test File 6.94 KB 0644
innodb_flush_method_basic.test File 4.28 KB 0644
innodb_flush_neighbors_basic.test File 2.7 KB 0644
innodb_flushing_avg_loops_basic.test File 6.67 KB 0644
innodb_force_load_corrupted_basic.test File 4.41 KB 0644
innodb_force_recovery_basic.test File 4.31 KB 0644
innodb_force_recovery_crash_basic.test File 1.07 KB 0644
innodb_ft_aux_table_basic.test File 1014 B 0644
innodb_ft_cache_size_basic.test File 692 B 0644
innodb_ft_enable_diag_print_basic.test File 2.83 KB 0644
innodb_ft_enable_stopword_basic.test File 3.35 KB 0644
innodb_ft_max_token_size_basic.test File 724 B 0644
innodb_ft_min_token_size_basic.test File 724 B 0644
innodb_ft_num_word_optimize_basic.test File 1.64 KB 0644
innodb_ft_result_cache_limit_basic.test File 1.1 KB 0644
innodb_ft_server_stopword_table_basic.test File 1.14 KB 0644
innodb_ft_sort_pll_degree_basic.test File 732 B 0644
innodb_ft_total_cache_size_basic.test File 712 B 0644
innodb_ft_user_stopword_table_basic.test File 993 B 0644
innodb_io_capacity_basic.test File 2.06 KB 0644
innodb_io_capacity_max_basic.test File 2.21 KB 0644
innodb_large_prefix_basic.test File 2.54 KB 0644
innodb_limit_optimistic_insert_debug_basic.test File 1.98 KB 0644
innodb_lock_wait_timeout_basic.test File 4.3 KB 0644
innodb_locks_unsafe_for_binlog_basic.test File 4.47 KB 0644
innodb_log_buffer_size_basic.test File 4.33 KB 0644
innodb_log_checkpoint_now_basic.test File 2.43 KB 0644
innodb_log_compressed_pages_basic.test File 3.11 KB 0644
innodb_log_file_size_basic.test File 4.3 KB 0644
innodb_log_files_in_group_basic.test File 4.37 KB 0644
innodb_log_group_home_dir_basic.test File 4.37 KB 0644
innodb_lru_scan_depth_basic.test File 1.76 KB 0644
innodb_max_dirty_pages_pct_basic.test File 7.74 KB 0644
innodb_max_dirty_pages_pct_func.test File 6.2 KB 0644
innodb_max_dirty_pages_pct_lwm_basic.test File 7.21 KB 0644
innodb_max_purge_lag_basic.test File 6.49 KB 0644
innodb_max_purge_lag_delay_basic.test File 1.43 KB 0644
innodb_mirrored_log_groups_basic.test File 4.39 KB 0644
innodb_monitor_disable_basic.test File 11.99 KB 0644
innodb_monitor_enable_basic.test File 11.99 KB 0644
innodb_monitor_reset_all_basic.test File 11.99 KB 0644
innodb_monitor_reset_basic.test File 11.99 KB 0644
innodb_numa_interleave_basic.test File 305 B 0644
innodb_old_blocks_pct_basic.test File 2.01 KB 0644
innodb_old_blocks_time_basic.test File 1.53 KB 0644
innodb_online_alter_log_max_size_basic.test File 1.97 KB 0644
innodb_open_files_basic.test File 4.25 KB 0644
innodb_optimize_fulltext_only_basic.test File 2.9 KB 0644
innodb_page_hash_locks_basic.test File 762 B 0644
innodb_page_size_basic.test File 446 B 0644
innodb_print_all_deadlocks_basic.test File 2.8 KB 0644
innodb_purge_batch_size_basic.test File 6.57 KB 0644
innodb_purge_run_now_basic.test File 1.4 KB 0644
innodb_purge_stop_now_basic.test File 1.4 KB 0644
innodb_purge_threads_basic.test File 1.28 KB 0644
innodb_random_read_ahead_basic.test File 2.72 KB 0644
innodb_read_ahead_threshold_basic.test File 2.01 KB 0644
innodb_read_io_threads_basic.test File 780 B 0644
innodb_read_only_basic.test File 704 B 0644
innodb_replication_delay_basic.test File 1.57 KB 0644
innodb_rollback_on_timeout_basic.test File 4.4 KB 0644
innodb_rollback_segments_basic.test File 1.62 KB 0644
innodb_saved_page_number_debug_basic.test File 925 B 0644
innodb_sort_buffer_size_basic.test File 716 B 0644
innodb_spin_wait_delay_basic.test File 1.53 KB 0644
innodb_stats_auto_recalc_basic.test File 703 B 0644
innodb_stats_include_delete_marked_basic.test File 2.3 KB 0644
innodb_stats_method_basic.test File 2.15 KB 0644
innodb_stats_on_metadata_basic.test File 2.72 KB 0644
innodb_stats_persistent_basic.test File 690 B 0644
innodb_stats_persistent_sample_pages_basic.test File 1.82 KB 0644
innodb_stats_sample_pages_basic.test File 1.59 KB 0644
innodb_stats_transient_sample_pages_basic.test File 1.8 KB 0644
innodb_status_output_basic.test File 2.81 KB 0644
innodb_status_output_locks_basic.test File 3.05 KB 0644
innodb_strict_mode_basic.test File 3.02 KB 0644
innodb_support_xa_basic.test File 9.08 KB 0644
innodb_support_xa_func.test File 4.51 KB 0644
innodb_sync_array_size_basic.test File 830 B 0644
innodb_sync_spin_loops_basic.test File 6.53 KB 0644
innodb_table_locks_basic.test File 9.11 KB 0644
innodb_table_locks_func.test File 3.58 KB 0644
innodb_thread_concurrency_basic.test File 6.67 KB 0644
innodb_thread_sleep_delay_basic.test File 2.22 KB 0644
innodb_tmpdir_basic.test File 922 B 0644
innodb_trx_purge_view_update_only_debug_basic.test File 2.19 KB 0644
innodb_trx_rseg_n_slots_debug_basic.test File 1.97 KB 0644
innodb_undo_directory_basic.test File 3.65 KB 0644
innodb_undo_logs_basic.test File 3.82 KB 0644
innodb_undo_tablespaces_basic.test File 3.48 KB 0644
innodb_use_native_aio_basic.test File 4.33 KB 0644
innodb_use_sys_malloc_basic.test File 796 B 0644
innodb_version_basic.test File 909 B 0644
innodb_write_io_threads_basic.test File 788 B 0644
insert_id_basic.test File 7.54 KB 0644
insert_id_func.test File 4.04 KB 0644
interactive_timeout_basic.test File 8.85 KB 0644
interactive_timeout_func.test File 3.37 KB 0644
join_buffer_size_basic_32.test File 494 B 0644
join_buffer_size_basic_64.test File 494 B 0644
keep_files_on_create_basic.test File 9.37 KB 0644
key_buffer_size_basic.test File 7.11 KB 0644
key_buffer_size_func.test File 4.72 KB 0644
key_cache_age_threshold_basic_32.test File 501 B 0644
key_cache_age_threshold_basic_64.test File 501 B 0644
key_cache_block_size_basic.test File 7.88 KB 0644
key_cache_division_limit_basic.test File 8.09 KB 0644
large_files_support_basic.test File 597 B 0644
large_page_size_basic.test File 653 B 0644
large_pages_basic.test File 557 B 0644
last_insert_id_basic.test File 1.15 KB 0644
last_insert_id_func-master.opt File 10 B 0644
last_insert_id_func.test File 5.35 KB 0644
lc_messages_basic.test File 1.13 KB 0644
lc_messages_dir_basic.test File 804 B 0644
lc_time_names_basic.test File 25.48 KB 0644
lc_time_names_func.test File 3.93 KB 0644
license_basic.test File 4.07 KB 0644
local_infile_basic.test File 7.31 KB 0644
local_infile_func.test File 3.78 KB 0644
lock_wait_timeout_basic.test File 9.08 KB 0644
locked_in_memory_basic.test File 606 B 0644
log_bin_basename_basic.test File 351 B 0644
log_bin_basic.test File 501 B 0644
log_bin_index_basic.test File 345 B 0644
log_bin_trust_function_creators_basic.test File 7.86 KB 0644
log_bin_trust_function_creators_func.test File 4.78 KB 0644
log_bin_use_v1_row_events_basic.test File 4.58 KB 0644
log_error_basic.test File 516 B 0644
log_error_func.cnf File 125 B 0644
log_error_func.test File 718 B 0644
log_error_func2.cnf File 101 B 0644
log_error_func2.test File 700 B 0644
log_error_func3.test File 236 B 0644
log_output_basic.test File 7.8 KB 0644
log_output_func.test File 4.85 KB 0644
log_queries_not_using_indexes_basic.test File 4.32 KB 0644
log_slave_updates_basic.test File 614 B 0644
log_slow_admin_statements_basic.test File 4.17 KB 0644
log_slow_admin_statements_func.test File 2.43 KB 0644
log_slow_slave_statements_basic.test File 4.17 KB 0644
log_throttle_queries_not_using_indexes_basic.test File 2.79 KB 0644
log_warnings_basic_32.test File 490 B 0644
log_warnings_basic_64.test File 490 B 0644
long_query_time_basic.test File 8.59 KB 0644
low_priority_updates_basic.test File 9.3 KB 0644
lower_case_file_system_basic.test File 1021 B 0644
lower_case_table_names_basic.test File 986 B 0644
master_info_repository_basic.test File 4.1 KB 0644
master_verify_checksum_basic.test File 653 B 0644
max_allowed_packet_basic.test File 9.6 KB 0644
max_allowed_packet_func.test File 5.07 KB 0644
max_binlog_cache_size_basic.test File 8.68 KB 0644
max_binlog_size_basic.test File 7.57 KB 0644
max_binlog_stmt_cache_size_basic.test File 9.13 KB 0644
max_connect_errors_basic_32.test File 496 B 0644
max_connect_errors_basic_64.test File 496 B 0644
max_connections_basic.test File 7.47 KB 0644
max_delayed_threads_basic.test File 9.39 KB 0644
max_digest_length_basic-master.opt File 24 B 0644
max_digest_length_basic.test File 616 B 0644
max_error_count_basic.test File 8.79 KB 0644
max_heap_table_size_basic.test File 9.43 KB 0644
max_insert_delayed_threads_basic.test File 10.01 KB 0644
max_join_size_basic.test File 1.42 KB 0644
max_join_size_func.test File 4.53 KB 0644
max_length_for_sort_data_basic.test File 9.82 KB 0644
max_prepared_stmt_count_basic.test File 8.22 KB 0644
max_prepared_stmt_count_func.test File 6.04 KB 0644
max_relay_log_size_basic.test File 7.73 KB 0644
max_seeks_for_key_basic_32.test File 495 B 0644
max_seeks_for_key_basic_64.test File 495 B 0644
max_seeks_for_key_func.test File 3.06 KB 0644
max_sort_length_basic.test File 8.87 KB 0644
max_sort_length_func.test File 8.95 KB 0644
max_sp_recursion_depth_basic.test File 9.52 KB 0644
max_sp_recursion_depth_func-master.opt File 33 B 0644
max_sp_recursion_depth_func.test File 5.31 KB 0644
max_tmp_tables_basic_32.test File 492 B 0644
max_tmp_tables_basic_64.test File 492 B 0644
max_user_connections_basic.test File 6.93 KB 0644
max_user_connections_func.test File 3.61 KB 0644
max_write_lock_count_basic_32.test File 498 B 0644
max_write_lock_count_basic_64.test File 498 B 0644
maximum_basic-master.opt File 99 B 0644
maximum_basic.test File 312 B 0644
metadata_locks_cache_size_basic-master.opt File 32 B 0644
metadata_locks_cache_size_basic.test File 746 B 0644
metadata_locks_hash_instances_basic.test File 2.73 KB 0644
min_examined_row_limit_basic_32.test File 500 B 0644
min_examined_row_limit_basic_64.test File 500 B 0644
multi_range_count_basic_32.test File 495 B 0644
multi_range_count_basic_64.test File 495 B 0644
myisam_data_pointer_size_basic.test File 8.04 KB 0644
myisam_data_pointer_size_func.test File 4.33 KB 0644
myisam_max_sort_file_size_basic_32.test File 503 B 0644
myisam_max_sort_file_size_basic_64.test File 503 B 0644
myisam_mmap_size_basic.test File 817 B 0644
myisam_recover_options_basic.test File 620 B 0644
myisam_repair_threads_basic_32.test File 499 B 0644
myisam_repair_threads_basic_64.test File 499 B 0644
myisam_sort_buffer_size_basic_32.test File 501 B 0644
myisam_sort_buffer_size_basic_64.test File 501 B 0644
myisam_stats_method_basic.test File 8.34 KB 0644
myisam_stats_method_func.test File 4.08 KB 0644
myisam_use_mmap_basic.test File 4.32 KB 0644
named_pipe_basic.test File 553 B 0644
named_pipe_full_access_group_basic.test File 738 B 0644
net_buffer_length_basic.test File 8.72 KB 0644
net_read_timeout_basic.test File 8.69 KB 0644
net_retry_count_basic_32.test File 493 B 0644
net_retry_count_basic_64.test File 493 B 0644
net_write_timeout_basic.test File 8.65 KB 0644
new_basic.test File 7.67 KB 0644
old_alter_table_basic.test File 1.24 KB 0644
old_basic.test File 493 B 0644
old_passwords_basic.test File 7.29 KB 0644
old_passwords_func.test File 4.2 KB 0644
open_files_limit_basic.test File 702 B 0644
optimizer_prune_level_basic.test File 9.53 KB 0644
optimizer_search_depth_basic.test File 9.09 KB 0644
optimizer_switch_basic.test File 1.81 KB 0644
optimizer_trace_basic.test File 1.14 KB 0644
optimizer_trace_features_basic.test File 1.33 KB 0644
optimizer_trace_limit_basic.test File 1.38 KB 0644
optimizer_trace_max_mem_size_basic.test File 1.76 KB 0644
optimizer_trace_offset_basic.test File 1.74 KB 0644
optimizer_trace_offset_max-master.opt File 42 B 0644
optimizer_trace_offset_max.test File 656 B 0644
performance_schema_basic-master.opt File 34 B 0644
performance_schema_basic.test File 658 B 0644
pfs_accounts_size_basic-master.opt File 79 B 0644
pfs_accounts_size_basic.test File 770 B 0644
pfs_digests_size_basic-master.opt File 78 B 0644
pfs_digests_size_basic.test File 1.87 KB 0644
pfs_events_stages_h_size_basic-master.opt File 91 B 0644
pfs_events_stages_h_size_basic.test File 874 B 0644
pfs_events_stages_hl_size_basic-master.opt File 99 B 0644
pfs_events_stages_hl_size_basic.test File 914 B 0644
pfs_events_statements_h_size_basic-master.opt File 95 B 0644
pfs_events_statements_h_size_basic.test File 906 B 0644
pfs_events_statements_hl_size_basic-master.opt File 103 B 0644
pfs_events_statements_hl_size_basic.test File 946 B 0644
pfs_events_waits_h_size_basic-master.opt File 90 B 0644
pfs_events_waits_h_size_basic.test File 866 B 0644
pfs_events_waits_hl_size_basic-master.opt File 98 B 0644
pfs_events_waits_hl_size_basic.test File 906 B 0644
pfs_hosts_size_basic-master.opt File 76 B 0644
pfs_hosts_size_basic.test File 746 B 0644
pfs_max_cond_classes_basic-master.opt File 82 B 0644
pfs_max_cond_classes_basic.test File 794 B 0644
pfs_max_cond_instances_basic-master.opt File 84 B 0644
pfs_max_cond_instances_basic.test File 810 B 0644
pfs_max_digest_length_basic-master.opt File 43 B 0644
pfs_max_digest_length_basic.test File 820 B 0644
pfs_max_file_classes_basic-master.opt File 82 B 0644
pfs_max_file_classes_basic.test File 794 B 0644
pfs_max_file_handles_basic-master.opt File 82 B 0644
pfs_max_file_handles_basic.test File 794 B 0644
pfs_max_file_instances_basic-master.opt File 84 B 0644
pfs_max_file_instances_basic.test File 810 B 0644
pfs_max_mutex_classes_basic-master.opt File 83 B 0644
pfs_max_mutex_classes_basic.test File 802 B 0644
pfs_max_mutex_instances_basic-master.opt File 85 B 0644
pfs_max_mutex_instances_basic.test File 818 B 0644
pfs_max_rwlock_classes_basic-master.opt File 84 B 0644
pfs_max_rwlock_classes_basic.test File 810 B 0644
pfs_max_rwlock_instances_basic-master.opt File 86 B 0644
pfs_max_rwlock_instances_basic.test File 826 B 0644
pfs_max_socket_classes_basic-master.opt File 84 B 0644
pfs_max_socket_classes_basic.test File 810 B 0644
pfs_max_socket_instances_basic-master.opt File 86 B 0644
pfs_max_socket_instances_basic.test File 826 B 0644
pfs_max_stage_classes_basic-master.opt File 83 B 0644
pfs_max_stage_classes_basic.test File 802 B 0644
pfs_max_statement_classes_basic-master.opt File 87 B 0644
pfs_max_statement_classes_basic.test File 834 B 0644
pfs_max_table_handles_basic-master.opt File 83 B 0644
pfs_max_table_handles_basic.test File 802 B 0644
pfs_max_table_instances_basic-master.opt File 85 B 0644
pfs_max_table_instances_basic.test File 818 B 0644
pfs_max_thread_classes_basic-master.opt File 84 B 0644
pfs_max_thread_classes_basic.test File 810 B 0644
pfs_max_thread_instances_basic-master.opt File 86 B 0644
pfs_max_thread_instances_basic.test File 826 B 0644
pfs_session_connect_attrs_size_basic-master.opt File 93 B 0644
pfs_session_connect_attrs_size_basic.test File 1.98 KB 0644
pfs_setup_actors_size_basic-master.opt File 83 B 0644
pfs_setup_actors_size_basic.test File 802 B 0644
pfs_setup_objects_size_basic-master.opt File 84 B 0644
pfs_setup_objects_size_basic.test File 810 B 0644
pfs_users_size_basic-master.opt File 76 B 0644
pfs_users_size_basic.test File 746 B 0644
pid_file_basic.test File 768 B 0644
plugin_dir_basic-master.opt File 28 B 0644
plugin_dir_basic.test File 937 B 0644
port_basic.test File 706 B 0644
preload_buffer_size_basic.test File 9.35 KB 0644
profiling_basic.test File 1.5 KB 0644
profiling_h_size_basic.test File 1.58 KB 0644
protocol_version_basic.test File 572 B 0644
proxy_user_basic.test File 39 B 0644
pseudo_slave_mode_basic.test File 7.53 KB 0644
pseudo_thread_id_basic.test File 1.46 KB 0644
query_alloc_block_size_basic_32.test File 500 B 0644
query_alloc_block_size_basic_64.test File 500 B 0644
query_cache_limit_basic_32.test File 495 B 0644
query_cache_limit_basic_64.test File 495 B 0644
query_cache_limit_func-master.opt File 21 B 0644
query_cache_limit_func.test File 4.92 KB 0644
query_cache_min_res_unit_basic_32.test File 502 B 0644
query_cache_min_res_unit_basic_64.test File 502 B 0644
query_cache_size_basic_32.test File 494 B 0644
query_cache_size_basic_64.test File 494 B 0644
query_cache_type_basic-master.opt File 21 B 0644
query_cache_type_basic.test File 7.95 KB 0644
query_cache_type_func-master.opt File 21 B 0644
query_cache_type_func.test File 7.07 KB 0644
query_cache_wlock_invalidate_basic.test File 9.91 KB 0644
query_cache_wlock_invalidate_func-master.opt File 21 B 0644
query_cache_wlock_invalidate_func.test File 7.26 KB 0644
query_prealloc_size_basic.test File 9.54 KB 0644
query_prealloc_size_func.test File 3.13 KB 0644
rand_seed1_basic.test File 1022 B 0644
rand_seed2_basic.test File 1 KB 0644
range_alloc_block_size_basic_32.test File 500 B 0644
range_alloc_block_size_basic_64.test File 500 B 0644
read_buffer_size_basic.test File 8.87 KB 0644
read_only_basic.test File 6.81 KB 0644
read_only_func.test File 4.44 KB 0644
read_rnd_buffer_size_basic.test File 8.52 KB 0644
relay_log_basename_basic.test File 404 B 0644
relay_log_basic.test File 550 B 0644
relay_log_index_basic.test File 398 B 0644
relay_log_info_file_basic.test File 630 B 0644
relay_log_info_repository_basic.test File 4.14 KB 0644
relay_log_purge_basic.test File 6.98 KB 0644
relay_log_recovery_basic.test File 860 B 0644
relay_log_space_limit_basic.test File 646 B 0644
report_host_basic.test File 566 B 0644
report_password_basic.test File 598 B 0644
report_port_basic.test File 817 B 0644
report_user_basic.test File 566 B 0644
rpl_init_slave_func.test File 4.91 KB 0644
rpl_max_binlog_size_func-master.opt File 35 B 0644
rpl_max_binlog_size_func.test File 1.33 KB 0644
rpl_semi_sync_master_enabled_basic-master.opt File 21 B 0644
rpl_semi_sync_master_enabled_basic.test File 2.45 KB 0644
rpl_semi_sync_master_timeout_basic-master.opt File 21 B 0644
rpl_semi_sync_master_timeout_basic.test File 1.96 KB 0644
rpl_semi_sync_master_trace_level_basic-master.opt File 21 B 0644
rpl_semi_sync_master_trace_level_basic.test File 2.58 KB 0644
rpl_semi_sync_master_wait_no_slave_basic-master.opt File 21 B 0644
rpl_semi_sync_master_wait_no_slave_basic.test File 2.62 KB 0644
rpl_semi_sync_slave_enabled_basic-master.opt File 21 B 0644
rpl_semi_sync_slave_enabled_basic.test File 2.45 KB 0644
rpl_semi_sync_slave_trace_level_basic-master.opt File 21 B 0644
rpl_semi_sync_slave_trace_level_basic.test File 2.54 KB 0644
rpl_stop_slave_timeout_basic.test File 6.96 KB 0644
secure_auth_basic.test File 7.31 KB 0644
secure_auth_func-master.opt File 15 B 0644
secure_auth_func.test File 4.59 KB 0644
secure_file_priv-master.opt File 22 B 0644
secure_file_priv.test File 645 B 0644
secure_file_priv2-master.opt File 37 B 0644
secure_file_priv2.test File 697 B 0644
secure_file_priv_basic.test File 867 B 0644
server_id_basic.test File 7.44 KB 0644
server_id_bits_basic.test File 7.41 KB 0644
server_uuid_basic.test File 4.01 KB 0644
sha256_password_private_key_path_basic.test File 33 B 0644
sha256_password_public_key_path_basic.test File 32 B 0644
shared_memory_base_name_basic.test File 921 B 0644
shared_memory_basic.test File 611 B 0644
show_old_temporals_basic.test File 1.8 KB 0644
simplified_binlog_gtid_recovery_basic.test File 798 B 0644
skip_external_locking_basic.test File 612 B 0644
skip_name_resolve_basic-master.opt File 20 B 0644
skip_name_resolve_basic.test File 483 B 0644
skip_networking_basic.test File 564 B 0644
skip_show_database_basic.test File 588 B 0644
slave_allow_batching_basic.test File 7.75 KB 0644
slave_checkpoint_group_basic.test File 1.24 KB 0644
slave_checkpoint_period_basic.test File 1.42 KB 0644
slave_compressed_protocol_basic.test File 7.86 KB 0644
slave_exec_mode_basic.test File 2.75 KB 0644
slave_load_tmpdir_basic.test File 844 B 0644
slave_max_allowed_packet_basic.test File 8.01 KB 0644
slave_net_timeout_basic.test File 7.68 KB 0644
slave_parallel_workers_basic.test File 834 B 0644
slave_pending_jobs_size_max_basic.test File 896 B 0644
slave_rows_search_algorithms_basic.test File 1.68 KB 0644
slave_skip_errors_basic.test File 614 B 0644
slave_sql_verify_checksum_basic.test File 677 B 0644
slave_transaction_retries_basic_32.test File 503 B 0644
slave_transaction_retries_basic_64.test File 503 B 0644
slave_type_conversions_basic.test File 793 B 0644
slow_launch_time_basic.test File 7.62 KB 0644
slow_launch_time_func-master.opt File 22 B 0644
slow_launch_time_func.test File 4.98 KB 0644
slow_query_log_basic.test File 7.21 KB 0644
slow_query_log_file_basic-master.opt File 52 B 0644
slow_query_log_file_basic.test File 3.94 KB 0644
slow_query_log_file_func-master.opt File 57 B 0644
slow_query_log_file_func.test File 2.14 KB 0644
slow_query_log_func.test File 4.07 KB 0644
socket_basic.test File 722 B 0644
sort_buffer_size_basic_32.test File 494 B 0644
sort_buffer_size_basic_64.test File 494 B 0644
sql_auto_is_null_basic.test File 3.25 KB 0644
sql_big_selects_basic.test File 7.35 KB 0644
sql_big_selects_func.test File 3.93 KB 0644
sql_buffer_result_basic.test File 7.63 KB 0644
sql_buffer_result_func.test File 3.53 KB 0644
sql_log_bin_basic.test File 7.43 KB 0644
sql_log_off_basic.test File 7.34 KB 0644
sql_log_off_func.test File 3.55 KB 0644
sql_low_priority_updates_func.test File 6.66 KB 0644
sql_mode_basic.test File 13.5 KB 0644
sql_mode_func.test File 5.89 KB 0644
sql_notes_basic.test File 7.2 KB 0644
sql_notes_func.test File 3.6 KB 0644
sql_quote_show_create_basic.test File 7.79 KB 0644
sql_quote_show_create_func.test File 3.45 KB 0644
sql_safe_updates_basic.test File 7.58 KB 0644
sql_safe_updates_func.test File 5.71 KB 0644
sql_select_limit_basic.test File 1.26 KB 0644
sql_select_limit_func.test File 5.42 KB 0644
sql_slave_skip_counter_basic.test File 5.08 KB 0644
sql_warnings_basic.test File 7.32 KB 0644
sql_warnings_func.test File 3.2 KB 0644
ssl_ca_basic.test File 4.09 KB 0644
ssl_capath_basic.test File 4.12 KB 0644
ssl_cert_basic.test File 4.12 KB 0644
ssl_cipher_basic.test File 4.12 KB 0644
ssl_crl_basic.test File 105 B 0644
ssl_crlpath_basic.test File 109 B 0644
ssl_key_basic.test File 4.1 KB 0644
storage_engine_basic-master.opt File 9 B 0644
storage_engine_basic.test File 7.38 KB 0644
stored_program_cache_basic.test File 1.71 KB 0644
sync_binlog_basic.test File 6.32 KB 0644
sync_frm_basic.test File 6.48 KB 0644
sync_master_info_basic.test File 1.1 KB 0644
sync_relay_log_basic.test File 1.1 KB 0644
sync_relay_log_info_basic.test File 1.19 KB 0644
system_time_zone_basic.test File 4.21 KB 0644
table_definition_cache_basic.test File 7.41 KB 0644
table_open_cache_basic.test File 7.21 KB 0644
table_open_cache_instances_basic.test File 3.7 KB 0644
thread_cache_size_basic.test File 1.37 KB 0644
thread_cache_size_func-master.opt File 22 B 0644
thread_cache_size_func.test File 4.1 KB 0644
thread_concurrency_basic.test File 588 B 0644
thread_handling_basic.test File 4.46 KB 0644
thread_stack_basic.test File 695 B 0644
time_format_basic.test File 532 B 0644
time_zone_basic.test File 10.81 KB 0644
time_zone_func.test File 4.85 KB 0644
timed_mutexes_basic.test File 7.39 KB 0644
timestamp_basic.test File 6.4 KB 0644
timestamp_func.test File 2.42 KB 0644
timestamp_sysdate_is_now_func-master.opt File 17 B 0644
timestamp_sysdate_is_now_func.test File 2.17 KB 0644
tmp_table_size_basic.test File 8.34 KB 0644
tmpdir_basic.test File 4.06 KB 0644
transaction_alloc_block_size_basic.test File 9.35 KB 0644
transaction_allow_batching_basic.test File 1.25 KB 0644
transaction_prealloc_size_basic.test File 8.95 KB 0644
tx_isolation_basic.test File 8.32 KB 0644
tx_isolation_func-master.opt File 59 B 0644
tx_isolation_func.test File 9.06 KB 0644
tx_read_only_basic.test File 8.03 KB 0644
unique_checks_basic.test File 6.09 KB 0644
updatable_views_with_limit_basic.test File 10.25 KB 0644
updatable_views_with_limit_func.test File 4.36 KB 0644
version_basic.test File 4.07 KB 0644
version_comment_basic.test File 4.19 KB 0644
version_compile_machine_basic.test File 4.31 KB 0644
version_compile_os_basic.test File 4.23 KB 0644
wait_timeout_basic.test File 8.19 KB 0644
wait_timeout_func.test File 4.59 KB 0644
warning_count_basic.test File 4.1 KB 0644