Debian Codegraph @

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

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