Debian Codegraph @

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

raw
1
2 #
3 # exists as a global only
4 #
5 # 2010-01-21 OBN - Added
6 #
7 source include/not_embedded.inc;
8 select @@global.rpl_semi_sync_master_timeout;
9 SET @start_global_value = @@global.rpl_semi_sync_master_timeout;
10
11 --echo Assuming value will not be more then 100 sec
12 select @@global.rpl_semi_sync_master_timeout between 1 and 100000;
13 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
14 select @@session.rpl_semi_sync_master_timeout;
15 show global variables like 'rpl_semi_sync_master_timeout';
16 show session variables like 'rpl_semi_sync_master_timeout';
17 select * from information_schema.global_variables where variable_name='rpl_semi_sync_master_timeout';
18 select * from information_schema.session_variables where variable_name='rpl_semi_sync_master_timeout';
19
20 #
21 # show that it's writable
22 #
23 set global rpl_semi_sync_master_timeout=42;
24 --error ER_GLOBAL_VARIABLE
25 set session rpl_semi_sync_master_timeout=99;
26 select @@global.rpl_semi_sync_master_timeout;
27 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
28 select @@session.rpl_semi_sync_master_timeout;
29 show global variables like 'rpl_semi_sync_master_timeout';
30 show session variables like 'rpl_semi_sync_master_timeout';
31 select * from information_schema.global_variables where variable_name='rpl_semi_sync_master_timeout';
32 select * from information_schema.session_variables where variable_name='rpl_semi_sync_master_timeout';
33
34 #
35 # incorrect types
36 #
37 --error ER_WRONG_TYPE_FOR_VAR
38 set global rpl_semi_sync_master_timeout=1.1;
39 --error ER_WRONG_TYPE_FOR_VAR
40 set global rpl_semi_sync_master_timeout=1e1;
41 --error ER_WRONG_TYPE_FOR_VAR
42 set global rpl_semi_sync_master_timeout="some text";
43
44
45 #
46 # Cleanup
47 #
48 SET @@global.rpl_semi_sync_master_timeout = @start_global_value;
49 select @@global.rpl_semi_sync_master_timeout;