Debian Codegraph @

mysql-test/suite/sys_vars/r/lower_case_table_names_basic.result

raw
1 select @@global.lower_case_table_names=20;
2 @@global.lower_case_table_names=20
3 0
4 select @@session.lower_case_table_names;
5 ERROR HY000: Variable 'lower_case_table_names' is a GLOBAL variable
6 SELECT @@global.lower_case_table_names in (0,1,2);
7 @@global.lower_case_table_names in (0,1,2)
8 1
9 SELECT @@global.lower_case_table_names = VARIABLE_VALUE
10 FROM performance_schema.global_variables
11 WHERE VARIABLE_NAME='lower_case_table_names';
12 @@global.lower_case_table_names = VARIABLE_VALUE
13 1
14 SELECT @@global.lower_case_table_names = VARIABLE_VALUE
15 FROM performance_schema.global_variables
16 WHERE VARIABLE_NAME='lower_case_table_names';
17 @@global.lower_case_table_names = VARIABLE_VALUE
18 1
19 set global lower_case_table_names=1;
20 ERROR HY000: Variable 'lower_case_table_names' is a read only variable
21 set session lower_case_table_names=1;
22 ERROR HY000: Variable 'lower_case_table_names' is a read only variable