Debian Codegraph @

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

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