3
# exists as a global only
5
# 2010-01-21 OBN - Added
8
source include/not_embedded.inc;
9
source include/have_semisync_plugin.inc;
10
# The following is to prevent a mis-match on windows that has the name of of the lib ending with 'dll'
11
--replace_regex /\.dll/.so/
12
eval INSTALL PLUGIN rpl_semi_sync_master SONAME '$SEMISYNC_MASTER_SO';
13
select @@global.rpl_semi_sync_master_enabled;
14
SET @start_global_value = @@global.rpl_semi_sync_master_enabled;
16
select @@global.rpl_semi_sync_master_enabled in (0,1);
17
--error ER_INCORRECT_GLOBAL_LOCAL_VAR
18
select @@session.rpl_semi_sync_master_enabled;
19
show global variables like 'rpl_semi_sync_master_enabled';
20
show session variables like 'rpl_semi_sync_master_enabled';
21
select * from information_schema.global_variables where variable_name='rpl_semi_sync_master_enabled';
22
select * from information_schema.session_variables where variable_name='rpl_semi_sync_master_enabled';
25
# show that it's writable
27
set global rpl_semi_sync_master_enabled=0;
28
--error ER_GLOBAL_VARIABLE
29
set session rpl_semi_sync_master_enabled=0;
30
select @@global.rpl_semi_sync_master_enabled;
31
--error ER_INCORRECT_GLOBAL_LOCAL_VAR
32
select @@session.rpl_semi_sync_master_enabled;
33
show global variables like 'rpl_semi_sync_master_enabled';
34
show session variables like 'rpl_semi_sync_master_enabled';
35
select * from information_schema.global_variables where variable_name='rpl_semi_sync_master_enabled';
36
select * from information_schema.session_variables where variable_name='rpl_semi_sync_master_enabled';
37
set global rpl_semi_sync_master_enabled=1;
38
--error ER_GLOBAL_VARIABLE
39
set session rpl_semi_sync_master_enabled=1;
40
select @@global.rpl_semi_sync_master_enabled;
41
--error ER_INCORRECT_GLOBAL_LOCAL_VAR
42
select @@session.rpl_semi_sync_master_enabled;
43
show global variables like 'rpl_semi_sync_master_enabled';
44
show session variables like 'rpl_semi_sync_master_enabled';
45
select * from information_schema.global_variables where variable_name='rpl_semi_sync_master_enabled';
46
select * from information_schema.session_variables where variable_name='rpl_semi_sync_master_enabled';
51
--error ER_WRONG_TYPE_FOR_VAR
52
set global rpl_semi_sync_master_enabled=1.1;
53
--error ER_WRONG_TYPE_FOR_VAR
54
set global rpl_semi_sync_master_enabled=1e1;
55
--error ER_WRONG_VALUE_FOR_VAR
56
set global rpl_semi_sync_master_enabled="some text";
62
SET @@global.rpl_semi_sync_master_enabled = @start_global_value;
63
select @@global.rpl_semi_sync_master_enabled;
64
UNINSTALL PLUGIN rpl_semi_sync_master;