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 select * from information_schema.global_variables where variable_name='locked_in_memory';
11 select * from information_schema.session_variables where variable_name='locked_in_memory';
12
13 #
14 # show that it's read-only
15 #
16 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
17 set global locked_in_memory=1;
18 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
19 set session locked_in_memory=1;
20