Debian Codegraph @

mysql-test/suite/sys_vars/r/rpl_semi_sync_master_trace_level_basic.result

raw
1 select @@global.rpl_semi_sync_master_trace_level;
2 @@global.rpl_semi_sync_master_trace_level
3 32
4 SET @start_global_value = @@global.rpl_semi_sync_master_trace_level;
5 select @@global.rpl_semi_sync_master_trace_level in (1,16,32,64);
6 @@global.rpl_semi_sync_master_trace_level in (1,16,32,64)
7 1
8 select @@session.rpl_semi_sync_master_trace_level;
9 ERROR HY000: Variable 'rpl_semi_sync_master_trace_level' is a GLOBAL variable
10 show global variables like 'rpl_semi_sync_master_trace_level';
11 Variable_name Value
12 rpl_semi_sync_master_trace_level 32
13 show session variables like 'rpl_semi_sync_master_trace_level';
14 Variable_name Value
15 rpl_semi_sync_master_trace_level 32
16 select * from information_schema.global_variables where variable_name='rpl_semi_sync_master_trace_level';
17 VARIABLE_NAME VARIABLE_VALUE
18 RPL_SEMI_SYNC_MASTER_TRACE_LEVEL 32
19 select * from information_schema.session_variables where variable_name='rpl_semi_sync_master_trace_level';
20 VARIABLE_NAME VARIABLE_VALUE
21 RPL_SEMI_SYNC_MASTER_TRACE_LEVEL 32
22 set global rpl_semi_sync_master_trace_level=16;
23 set session rpl_semi_sync_master_trace_level=99;
24 ERROR HY000: Variable 'rpl_semi_sync_master_trace_level' is a GLOBAL variable and should be set with SET GLOBAL
25 select @@global.rpl_semi_sync_master_trace_level;
26 @@global.rpl_semi_sync_master_trace_level
27 16
28 select @@session.rpl_semi_sync_master_trace_level;
29 ERROR HY000: Variable 'rpl_semi_sync_master_trace_level' is a GLOBAL variable
30 show global variables like 'rpl_semi_sync_master_trace_level';
31 Variable_name Value
32 rpl_semi_sync_master_trace_level 16
33 show session variables like 'rpl_semi_sync_master_trace_level';
34 Variable_name Value
35 rpl_semi_sync_master_trace_level 16
36 select * from information_schema.global_variables where variable_name='rpl_semi_sync_master_trace_level';
37 VARIABLE_NAME VARIABLE_VALUE
38 RPL_SEMI_SYNC_MASTER_TRACE_LEVEL 16
39 select * from information_schema.session_variables where variable_name='rpl_semi_sync_master_trace_level';
40 VARIABLE_NAME VARIABLE_VALUE
41 RPL_SEMI_SYNC_MASTER_TRACE_LEVEL 16
42 NOTE: Value can also be set to values that are combinations of values
43 set global rpl_semi_sync_master_trace_level=42;
44 select @@global.rpl_semi_sync_master_trace_level;
45 @@global.rpl_semi_sync_master_trace_level
46 42
47 select @@session.rpl_semi_sync_master_trace_level;
48 ERROR HY000: Variable 'rpl_semi_sync_master_trace_level' is a GLOBAL variable
49 show global variables like 'rpl_semi_sync_master_trace_level';
50 Variable_name Value
51 rpl_semi_sync_master_trace_level 42
52 show session variables like 'rpl_semi_sync_master_trace_level';
53 Variable_name Value
54 rpl_semi_sync_master_trace_level 42
55 select * from information_schema.global_variables where variable_name='rpl_semi_sync_master_trace_level';
56 VARIABLE_NAME VARIABLE_VALUE
57 RPL_SEMI_SYNC_MASTER_TRACE_LEVEL 42
58 select * from information_schema.session_variables where variable_name='rpl_semi_sync_master_trace_level';
59 VARIABLE_NAME VARIABLE_VALUE
60 RPL_SEMI_SYNC_MASTER_TRACE_LEVEL 42
61 set global rpl_semi_sync_master_trace_level=1.1;
62 ERROR 42000: Incorrect argument type to variable 'rpl_semi_sync_master_trace_level'
63 set global rpl_semi_sync_master_trace_level=1e1;
64 ERROR 42000: Incorrect argument type to variable 'rpl_semi_sync_master_trace_level'
65 set global rpl_semi_sync_master_trace_level="some text";
66 ERROR 42000: Incorrect argument type to variable 'rpl_semi_sync_master_trace_level'
67 SET @@global.rpl_semi_sync_master_trace_level = @start_global_value;
68 select @@global.rpl_semi_sync_master_trace_level;
69 @@global.rpl_semi_sync_master_trace_level
70 32