Debian Codegraph @

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

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