Debian Codegraph @

mysql-test/suite/sys_vars/t/wsrep_sst_receive_address_basic.test

raw
1 --source include/have_wsrep.inc
2
3 --echo #
4 --echo # wsrep_sst_receive_address
5 --echo #
6
7 --echo # save the initial value
8 SET @wsrep_sst_receive_address_global_saved = @@global.wsrep_sst_receive_address;
9
10 --echo # default
11 SELECT @@global.wsrep_sst_receive_address;
12
13 --echo
14 --echo # scope
15 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
16 SELECT @@session.wsrep_sst_receive_address;
17 SELECT @@global.wsrep_sst_receive_address;
18
19 --echo
20 --echo # valid values
21 SET @@global.wsrep_sst_receive_address=AUTO;
22 SELECT @@global.wsrep_sst_receive_address;
23 SET @@global.wsrep_sst_receive_address=default;
24 SELECT @@global.wsrep_sst_receive_address;
25 SET @@global.wsrep_sst_receive_address='192.168.2.254';
26 SELECT @@global.wsrep_sst_receive_address;
27 SET @@global.wsrep_sst_receive_address=NULL;
28 SELECT @@global.wsrep_sst_receive_address;
29 SET @@global.wsrep_sst_receive_address='';
30 SELECT @@global.wsrep_sst_receive_address;
31
32 --echo
33 --echo # invalid values
34 SELECT @@global.wsrep_sst_receive_address;
35 # Currently there is no strict checking performed for wsrep_sst_receive_address
36 # so following values jusr pass through.
37 SET @@global.wsrep_sst_receive_address='OFF';
38 SELECT @@global.wsrep_sst_receive_address;
39 SET @@global.wsrep_sst_receive_address=ON;
40 SELECT @@global.wsrep_sst_receive_address;
41 SET @@global.wsrep_sst_receive_address='junk';
42 SELECT @@global.wsrep_sst_receive_address;
43
44 --echo
45 --echo # restore the initial value
46 SET @@global.wsrep_sst_receive_address = @wsrep_sst_receive_address_global_saved;
47
48 --echo # End of test