Debian Codegraph @

mysql-test/suite/sys_vars/t/rpl_semi_sync_master_trace_level_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_trace_level;
9 SET @start_global_value = @@global.rpl_semi_sync_master_trace_level;
10
11 select @@global.rpl_semi_sync_master_trace_level in (1,16,32,64);
12 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
13 select @@session.rpl_semi_sync_master_trace_level;
14 show global variables like 'rpl_semi_sync_master_trace_level';
15 show session variables like 'rpl_semi_sync_master_trace_level';
16 select * from information_schema.global_variables where variable_name='rpl_semi_sync_master_trace_level';
17 select * from information_schema.session_variables where variable_name='rpl_semi_sync_master_trace_level';
18
19 #
20 # show that it's writable
21 #
22 set global rpl_semi_sync_master_trace_level=16;
23 --error ER_GLOBAL_VARIABLE
24 set session rpl_semi_sync_master_trace_level=99;
25 select @@global.rpl_semi_sync_master_trace_level;
26 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
27 select @@session.rpl_semi_sync_master_trace_level;
28 show global variables like 'rpl_semi_sync_master_trace_level';
29 show session variables like 'rpl_semi_sync_master_trace_level';
30 select * from information_schema.global_variables where variable_name='rpl_semi_sync_master_trace_level';
31 select * from information_schema.session_variables where variable_name='rpl_semi_sync_master_trace_level';
32
33 --echo NOTE: Value can also be set to values that are combinations of values
34 set global rpl_semi_sync_master_trace_level=42;
35 select @@global.rpl_semi_sync_master_trace_level;
36 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
37 select @@session.rpl_semi_sync_master_trace_level;
38 show global variables like 'rpl_semi_sync_master_trace_level';
39 show session variables like 'rpl_semi_sync_master_trace_level';
40 select * from information_schema.global_variables where variable_name='rpl_semi_sync_master_trace_level';
41 select * from information_schema.session_variables where variable_name='rpl_semi_sync_master_trace_level';
42
43 #
44 # incorrect types
45 #
46 --error ER_WRONG_TYPE_FOR_VAR
47 set global rpl_semi_sync_master_trace_level=1.1;
48 --error ER_WRONG_TYPE_FOR_VAR
49 set global rpl_semi_sync_master_trace_level=1e1;
50 --error ER_WRONG_TYPE_FOR_VAR
51 set global rpl_semi_sync_master_trace_level="some text";
52
53 #
54 # Cleanup
55 #
56 SET @@global.rpl_semi_sync_master_trace_level = @start_global_value;
57 select @@global.rpl_semi_sync_master_trace_level;