Debian Codegraph @

mysql-test/suite/sys_vars/t/lower_case_file_system_basic.test

raw
1 #
2 # only global
3 #
4 # 2010-01-20 OBN - Modified to include check for valid values
5 # - Added check for variable value matching I_S tables
6 #
7 select @@global.lower_case_file_system=2;
8 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
9 select @@session.lower_case_file_system;
10
11 # Show variable has a valid value
12 SELECT @@global.lower_case_file_system in (0,1);
13
14 # Show that value of the variable matches the value in the GLOBAL I_S table
15 --disable_warnings
16 SELECT IF(@@global.lower_case_file_system, "ON", "OFF") = VARIABLE_VALUE
17 FROM performance_schema.global_variables
18 WHERE VARIABLE_NAME='lower_case_file_system';
19 --enable_warnings
20
21 # Show that value of the variable matches the value in the SESSION I_S table
22 --disable_warnings
23 SELECT IF(@@global.lower_case_file_system, "ON", "OFF") = VARIABLE_VALUE
24 FROM performance_schema.session_variables
25 WHERE VARIABLE_NAME='lower_case_file_system';
26 --enable_warnings
27
28 #
29 # show that it's read-only
30 #
31 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
32 set global lower_case_file_system=1;
33 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
34 set session lower_case_file_system=1;
35