Debian Codegraph @

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

raw
1 #
2 # Basic test coverage for --metadata-locks-cache-size startup
3 # parameter and corresponding read-only global @@metadata_locks_cache_size
4 # variable.
5 #
6
7 --echo #
8 --echo # Check that the paremeter is correctly set by start-up
9 --echo # option (.opt file sets it to 256 while default is 1024).
10 select @@global.metadata_locks_cache_size = 256;
11
12 --echo #
13 --echo # Check that variable is read only
14 --echo #
15 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
16 set @@global.metadata_locks_cache_size= 1024;
17 select @@global.metadata_locks_cache_size = 256;
18
19 --echo #
20 --echo # And only GLOBAL
21 --echo #
22 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
23 select @@session.metadata_locks_cache_size;
24 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
25 set @@session.metadata_locks_cache_size= 1024;