Edit File: lower_case_table_names_basic.test
# # only global # # 2010-01-20 OBN - Modified to include check for valid values # - Added check for variable value matching I_S tables # select @@global.lower_case_table_names=20; --error ER_INCORRECT_GLOBAL_LOCAL_VAR select @@session.lower_case_table_names; # Show variable has a valid value SELECT @@global.lower_case_table_names in (0,1,2); # Show that value of the variable matches the value in the GLOBAL I_S table SELECT @@global.lower_case_table_names = VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='lower_case_table_names'; # Show that value of the variable matches the value in the SESSION I_S table SELECT @@global.lower_case_table_names = VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='lower_case_table_names'; # # show that it's read-only # --error ER_INCORRECT_GLOBAL_LOCAL_VAR set global lower_case_table_names=1; --error ER_INCORRECT_GLOBAL_LOCAL_VAR set session lower_case_table_names=1;