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