Debian Codegraph @

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

raw
1 #
2 # wsrep_sst_receive_address
3 #
4 # save the initial value
5 SET @wsrep_sst_receive_address_global_saved = @@global.wsrep_sst_receive_address;
6 # default
7 SELECT @@global.wsrep_sst_receive_address;
8 @@global.wsrep_sst_receive_address
9 AUTO
10
11 # scope
12 SELECT @@session.wsrep_sst_receive_address;
13 ERROR HY000: Variable 'wsrep_sst_receive_address' is a GLOBAL variable
14 SELECT @@global.wsrep_sst_receive_address;
15 @@global.wsrep_sst_receive_address
16 AUTO
17
18 # valid values
19 SET @@global.wsrep_sst_receive_address=AUTO;
20 SELECT @@global.wsrep_sst_receive_address;
21 @@global.wsrep_sst_receive_address
22 AUTO
23 SET @@global.wsrep_sst_receive_address=default;
24 SELECT @@global.wsrep_sst_receive_address;
25 @@global.wsrep_sst_receive_address
26 AUTO
27 SET @@global.wsrep_sst_receive_address='192.168.2.254';
28 SELECT @@global.wsrep_sst_receive_address;
29 @@global.wsrep_sst_receive_address
30 192.168.2.254
31 SET @@global.wsrep_sst_receive_address=NULL;
32 SELECT @@global.wsrep_sst_receive_address;
33 @@global.wsrep_sst_receive_address
34 NULL
35 SET @@global.wsrep_sst_receive_address='';
36 SELECT @@global.wsrep_sst_receive_address;
37 @@global.wsrep_sst_receive_address
38
39
40 # invalid values
41 SELECT @@global.wsrep_sst_receive_address;
42 @@global.wsrep_sst_receive_address
43
44 SET @@global.wsrep_sst_receive_address='OFF';
45 SELECT @@global.wsrep_sst_receive_address;
46 @@global.wsrep_sst_receive_address
47 OFF
48 SET @@global.wsrep_sst_receive_address=ON;
49 SELECT @@global.wsrep_sst_receive_address;
50 @@global.wsrep_sst_receive_address
51 ON
52 SET @@global.wsrep_sst_receive_address='junk';
53 SELECT @@global.wsrep_sst_receive_address;
54 @@global.wsrep_sst_receive_address
55 junk
56
57 # restore the initial value
58 SET @@global.wsrep_sst_receive_address = @wsrep_sst_receive_address_global_saved;
59 # End of test