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 --source include/not_embedded.inc
8
9 SET @start_global_value = @@global.relay_log_recovery;
10 SELECT @start_global_value;
11
12 #
13 # exists as global only
14 #
15 select @@global.relay_log_recovery;
16 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
17 select @@session.relay_log_recovery;
18 show global variables like 'relay_log_recovery';
19 show session variables like 'relay_log_recovery';
20 select * from information_schema.global_variables where variable_name='relay_log_recovery';
21 select * from information_schema.session_variables where variable_name='relay_log_recovery';
22
23 #
24 # show that it's writable
25 #
26 set global relay_log_recovery=1;
27 select @@global.relay_log_recovery;
28 select * from information_schema.global_variables where variable_name='relay_log_recovery';
29 select * from information_schema.session_variables where variable_name='relay_log_recovery';
30 set global relay_log_recovery=OFF;
31 select @@global.relay_log_recovery;
32 select * from information_schema.global_variables where variable_name='relay_log_recovery';
33 select * from information_schema.session_variables where variable_name='relay_log_recovery';
34 --error ER_GLOBAL_VARIABLE
35 set session relay_log_recovery=1;
36
37 #
38 # incorrect types
39 #
40 --error ER_WRONG_TYPE_FOR_VAR
41 set global relay_log_recovery=1.1;
42 --error ER_WRONG_TYPE_FOR_VAR
43 set global relay_log_recovery=1e1;
44 --error ER_WRONG_VALUE_FOR_VAR
45 set global relay_log_recovery="foo";
46
47 SET @@global.relay_log_recovery = @start_global_value;
48 SELECT @@global.relay_log_recovery;
49