1select @@global.lower_case_file_system=2;
2@@global.lower_case_file_system=2
30
4select @@session.lower_case_file_system;
5ERROR HY000: Variable 'lower_case_file_system' is a GLOBAL variable
6SELECT @@global.lower_case_file_system in (0,1);
7@@global.lower_case_file_system in (0,1)
81
9SELECT IF(@@global.lower_case_file_system, "ON", "OFF") = VARIABLE_VALUE
10FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
11WHERE VARIABLE_NAME='lower_case_file_system';
12IF(@@global.lower_case_file_system, "ON", "OFF") = VARIABLE_VALUE
131
14SELECT IF(@@global.lower_case_file_system, "ON", "OFF") = VARIABLE_VALUE
15FROM INFORMATION_SCHEMA.SESSION_VARIABLES
16WHERE VARIABLE_NAME='lower_case_file_system';
17IF(@@global.lower_case_file_system, "ON", "OFF") = VARIABLE_VALUE
181
19set global lower_case_file_system=1;
20ERROR HY000: Variable 'lower_case_file_system' is a read only variable
21set session lower_case_file_system=1;
22ERROR HY000: Variable 'lower_case_file_system' is a read only variable
23