Debian Codegraph @

mysql-test/suite/sys_vars/t/open_files_limit_basic.test

raw
1 #
2 # show the global and session values;
3 #
4 --replace_column 1 #
5 select @@global.open_files_limit;
6 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
7 select @@session.open_files_limit;
8 --replace_column 2 #
9 show global variables like 'open_files_limit';
10 --replace_column 2 #
11 show session variables like 'open_files_limit';
12 --replace_column 2 #
13 select * from information_schema.global_variables where variable_name='open_files_limit';
14 --replace_column 2 #
15 select * from information_schema.session_variables where variable_name='open_files_limit';
16
17 #
18 # show that it's read-only
19 #
20 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
21 set global open_files_limit=1;
22 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
23 set session open_files_limit=1;
24