Debian Codegraph @

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

raw
1
2 #
3 # exists as a global only
4 #
5 # 2010-01-21 OBN - Added
6 #
7 #
8 source include/not_embedded.inc;
9 select @@global.rpl_semi_sync_slave_enabled;
10 SET @start_global_value = @@global.rpl_semi_sync_slave_enabled;
11
12 select @@global.rpl_semi_sync_slave_enabled in (0,1);
13 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
14 select @@session.rpl_semi_sync_slave_enabled;
15 show global variables like 'rpl_semi_sync_slave_enabled';
16 show session variables like 'rpl_semi_sync_slave_enabled';
17 select * from information_schema.global_variables where variable_name='rpl_semi_sync_slave_enabled';
18 select * from information_schema.session_variables where variable_name='rpl_semi_sync_slave_enabled';
19
20 #
21 # show that it's writable
22 #
23 set global rpl_semi_sync_slave_enabled=0;
24 --error ER_GLOBAL_VARIABLE
25 set session rpl_semi_sync_slave_enabled=0;
26 select @@global.rpl_semi_sync_slave_enabled;
27 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
28 select @@session.rpl_semi_sync_slave_enabled;
29 show global variables like 'rpl_semi_sync_slave_enabled';
30 show session variables like 'rpl_semi_sync_slave_enabled';
31 select * from information_schema.global_variables where variable_name='rpl_semi_sync_slave_enabled';
32 select * from information_schema.session_variables where variable_name='rpl_semi_sync_slave_enabled';
33 set global rpl_semi_sync_slave_enabled=1;
34 --error ER_GLOBAL_VARIABLE
35 set session rpl_semi_sync_slave_enabled=1;
36 select @@global.rpl_semi_sync_slave_enabled;
37 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
38 select @@session.rpl_semi_sync_slave_enabled;
39 show global variables like 'rpl_semi_sync_slave_enabled';
40 show session variables like 'rpl_semi_sync_slave_enabled';
41 select * from information_schema.global_variables where variable_name='rpl_semi_sync_slave_enabled';
42 select * from information_schema.session_variables where variable_name='rpl_semi_sync_slave_enabled';
43
44 #
45 # incorrect types
46 #
47 --error ER_WRONG_TYPE_FOR_VAR
48 set global rpl_semi_sync_slave_enabled=1.1;
49 --error ER_WRONG_TYPE_FOR_VAR
50 set global rpl_semi_sync_slave_enabled=1e1;
51 --error ER_WRONG_VALUE_FOR_VAR
52 set global rpl_semi_sync_slave_enabled="some text";
53 --error ER_WRONG_VALUE_FOR_VAR
54
55
56 #
57 # Cleanup
58 #
59 SET @@global.rpl_semi_sync_slave_enabled = @start_global_value;
60 select @@global.rpl_semi_sync_slave_enabled;