Debian Codegraph @

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

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