2
# Basic test coverage for --metadata-locks-cache-size startup
3
# parameter and corresponding read-only global @@metadata_locks_cache_size
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;
13
--echo # Check that variable is read only
15
--error ER_INCORRECT_GLOBAL_LOCAL_VAR
16
set @@global.metadata_locks_cache_size= 1024;
17
select @@global.metadata_locks_cache_size = 256;
20
--echo # And only GLOBAL
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;