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 SELECT IF(@@global.lower_case_file_system, "ON", "OFF") = VARIABLE_VALUE
16 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
17 WHERE VARIABLE_NAME='lower_case_file_system';
18
19 # Show that value of the variable matches the value in the SESSION I_S table
20 SELECT IF(@@global.lower_case_file_system, "ON", "OFF") = VARIABLE_VALUE
21 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
22 WHERE VARIABLE_NAME='lower_case_file_system';
23
24 #
25 # show that it's read-only
26 #
27 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
28 set global lower_case_file_system=1;
29 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
30 set session lower_case_file_system=1;
31