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