# # 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 --disable_warnings SELECT @@global.lower_case_table_names = VARIABLE_VALUE FROM performance_schema.global_variables WHERE VARIABLE_NAME='lower_case_table_names'; --enable_warnings # Show that value of the variable matches the value in the SESSION I_S table --disable_warnings SELECT @@global.lower_case_table_names = VARIABLE_VALUE FROM performance_schema.global_variables WHERE VARIABLE_NAME='lower_case_table_names'; --enable_warnings # # 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;