diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/r/lower_case_file_system_basic.result')
-rw-r--r-- | mysql-test/suite/sys_vars/r/lower_case_file_system_basic.result | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/suite/sys_vars/r/lower_case_file_system_basic.result b/mysql-test/suite/sys_vars/r/lower_case_file_system_basic.result new file mode 100644 index 00000000000..4ecd81685c5 --- /dev/null +++ b/mysql-test/suite/sys_vars/r/lower_case_file_system_basic.result @@ -0,0 +1,22 @@ +select @@global.lower_case_file_system=2; +@@global.lower_case_file_system=2 +0 +select @@session.lower_case_file_system; +ERROR HY000: Variable 'lower_case_file_system' is a GLOBAL variable +SELECT @@global.lower_case_file_system in (0,1); +@@global.lower_case_file_system in (0,1) +1 +SELECT IF(@@global.lower_case_file_system, "ON", "OFF") = VARIABLE_VALUE +FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES +WHERE VARIABLE_NAME='lower_case_file_system'; +IF(@@global.lower_case_file_system, "ON", "OFF") = VARIABLE_VALUE +1 +SELECT IF(@@global.lower_case_file_system, "ON", "OFF") = VARIABLE_VALUE +FROM INFORMATION_SCHEMA.SESSION_VARIABLES +WHERE VARIABLE_NAME='lower_case_file_system'; +IF(@@global.lower_case_file_system, "ON", "OFF") = VARIABLE_VALUE +1 +set global lower_case_file_system=1; +ERROR HY000: Variable 'lower_case_file_system' is a read only variable +set session lower_case_file_system=1; +ERROR HY000: Variable 'lower_case_file_system' is a read only variable |