← Back to branch summary

~vadim-tk/percona-server/percona-5.5.15-galera

« back to all changes in this revision

Viewing changes to mysql-test/suite/sys_vars/r/lower_case_file_system_basic.result

  • Committer: root
  • Date: 2011-09-10 16:37:18 UTC
  • Revision ID: root@r815.office.percona.com-20110910163718-ydh4zj8hcdgoyavb
Porting Galera to 5.5.15

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/sys_vars/r/lower_case_file_system_basic.result
 
1
select @@global.lower_case_file_system=2;
 
2
@@global.lower_case_file_system=2
 
3
0
 
4
select @@session.lower_case_file_system;
 
5
ERROR HY000: Variable 'lower_case_file_system' is a GLOBAL variable
 
6
SELECT @@global.lower_case_file_system in (0,1);
 
7
@@global.lower_case_file_system in (0,1)
 
8
1
 
9
SELECT IF(@@global.lower_case_file_system, "ON", "OFF") = VARIABLE_VALUE 
 
10
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 
 
11
WHERE VARIABLE_NAME='lower_case_file_system';
 
12
IF(@@global.lower_case_file_system, "ON", "OFF") = VARIABLE_VALUE
 
13
1
 
14
SELECT IF(@@global.lower_case_file_system, "ON", "OFF") = VARIABLE_VALUE 
 
15
FROM INFORMATION_SCHEMA.SESSION_VARIABLES 
 
16
WHERE VARIABLE_NAME='lower_case_file_system';
 
17
IF(@@global.lower_case_file_system, "ON", "OFF") = VARIABLE_VALUE
 
18
1
 
19
set global lower_case_file_system=1;
 
20
ERROR HY000: Variable 'lower_case_file_system' is a read only variable
 
21
set session lower_case_file_system=1;
 
22
ERROR HY000: Variable 'lower_case_file_system' is a read only variable