Debian Codegraph @

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

raw
1 --source include/have_debug.inc
2
3 #
4 # exists as global only
5 #
6 select @@global.innodb_force_recovery_crash in (0, 1);
7 select @@global.innodb_force_recovery_crash;
8 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
9 select @@session.innodb_force_recovery_crash;
10 show global variables like 'innodb_force_recovery_crash';
11 show session variables like 'innodb_force_recovery_crash';
12 --disable_warnings
13 select * from performance_schema.global_variables where variable_name='innodb_force_recovery_crash';
14 select * from performance_schema.session_variables where variable_name='innodb_force_recovery_crash';
15 --enable_warnings
16
17 # show that it's read-only
18 #
19 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
20 set global innodb_force_recovery_crash=1;
21 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
22 set global innodb_force_recovery_crash=0;
23 select @@global.innodb_force_recovery_crash;
24 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
25 set session innodb_force_recovery_crash='some';
26 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
27 set @@session.innodb_force_recovery_crash='some';
28 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
29 set global innodb_force_recovery_crash='some';