Debian Codegraph @

mysql-test/suite/sys_vars/r/relay_log_recovery_basic.result

raw
1 SET @start_global_value = @@global.relay_log_recovery;
2 SELECT @start_global_value;
3 @start_global_value
4 0
5 select @@global.relay_log_recovery;
6 @@global.relay_log_recovery
7 0
8 select @@session.relay_log_recovery;
9 ERROR HY000: Variable 'relay_log_recovery' is a GLOBAL variable
10 show global variables like 'relay_log_recovery';
11 Variable_name Value
12 relay_log_recovery OFF
13 show session variables like 'relay_log_recovery';
14 Variable_name Value
15 relay_log_recovery OFF
16 select * from information_schema.global_variables where variable_name='relay_log_recovery';
17 VARIABLE_NAME VARIABLE_VALUE
18 RELAY_LOG_RECOVERY OFF
19 select * from information_schema.session_variables where variable_name='relay_log_recovery';
20 VARIABLE_NAME VARIABLE_VALUE
21 RELAY_LOG_RECOVERY OFF
22 set global relay_log_recovery=1;
23 select @@global.relay_log_recovery;
24 @@global.relay_log_recovery
25 1
26 select * from information_schema.global_variables where variable_name='relay_log_recovery';
27 VARIABLE_NAME VARIABLE_VALUE
28 RELAY_LOG_RECOVERY ON
29 select * from information_schema.session_variables where variable_name='relay_log_recovery';
30 VARIABLE_NAME VARIABLE_VALUE
31 RELAY_LOG_RECOVERY ON
32 set global relay_log_recovery=OFF;
33 select @@global.relay_log_recovery;
34 @@global.relay_log_recovery
35 0
36 select * from information_schema.global_variables where variable_name='relay_log_recovery';
37 VARIABLE_NAME VARIABLE_VALUE
38 RELAY_LOG_RECOVERY OFF
39 select * from information_schema.session_variables where variable_name='relay_log_recovery';
40 VARIABLE_NAME VARIABLE_VALUE
41 RELAY_LOG_RECOVERY OFF
42 set session relay_log_recovery=1;
43 ERROR HY000: Variable 'relay_log_recovery' is a GLOBAL variable and should be set with SET GLOBAL
44 set global relay_log_recovery=1.1;
45 ERROR 42000: Incorrect argument type to variable 'relay_log_recovery'
46 set global relay_log_recovery=1e1;
47 ERROR 42000: Incorrect argument type to variable 'relay_log_recovery'
48 set global relay_log_recovery="foo";
49 ERROR 42000: Variable 'relay_log_recovery' can't be set to the value of 'foo'
50 SET @@global.relay_log_recovery = @start_global_value;
51 SELECT @@global.relay_log_recovery;
52 @@global.relay_log_recovery
53 0