Debian Codegraph @

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

raw
1
2
3 #
4 # 2010-01-10 - Added check for I_S values aver variable value change
5 #
6
7
8 #
9 # exists as global only
10 #
11 select @@global.relay_log_recovery;
12 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
13 select @@session.relay_log_recovery;
14 show global variables like 'relay_log_recovery';
15 show session variables like 'relay_log_recovery';
16 --disable_warnings
17 select * from performance_schema.global_variables where variable_name='relay_log_recovery';
18 select * from performance_schema.session_variables where variable_name='relay_log_recovery';
19 --enable_warnings
20
21 #
22 # show that it's read-only
23 #
24 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
25 set global relay_log_recovery=1;
26 select @@global.relay_log_recovery;
27 --disable_warnings
28 select * from performance_schema.global_variables where variable_name='relay_log_recovery';
29 select * from performance_schema.session_variables where variable_name='relay_log_recovery';
30 --enable_warnings
31
32