Debian Codegraph @

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

raw
1 --source include/not_windows.inc
2 #
3 # only global
4 #
5 select @@global.locked_in_memory;
6 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
7 select @@session.locked_in_memory;
8 show global variables like 'locked_in_memory';
9 show session variables like 'locked_in_memory';
10 --disable_warnings
11 select * from performance_schema.global_variables where variable_name='locked_in_memory';
12 select * from performance_schema.session_variables where variable_name='locked_in_memory';
13 --enable_warnings
14
15 #
16 # show that it's read-only
17 #
18 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
19 set global locked_in_memory=1;
20 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
21 set session locked_in_memory=1;
22