Debian Codegraph @

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

raw
1 --source include/have_wsrep.inc
2
3 --echo #
4 --echo # wsrep_node_incoming_address
5 --echo #
6
7 --echo # save the initial value
8 SET @wsrep_node_incoming_address_global_saved = @@global.wsrep_node_incoming_address;
9
10 --echo # default
11 SELECT @@global.wsrep_node_incoming_address;
12
13 --echo
14 --echo # scope
15 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
16 SELECT @@session.wsrep_node_incoming_address;
17 SELECT @@global.wsrep_node_incoming_address;
18
19 --echo
20 --echo # valid values
21 SET @@global.wsrep_node_incoming_address='127.0.0.1:4444';
22 SELECT @@global.wsrep_node_incoming_address;
23 SET @@global.wsrep_node_incoming_address='127.0.0.1';
24 SELECT @@global.wsrep_node_incoming_address;
25 SET @@global.wsrep_node_incoming_address=AUTO;
26 SELECT @@global.wsrep_node_incoming_address;
27 SET @@global.wsrep_node_incoming_address=default;
28 SELECT @@global.wsrep_node_incoming_address;
29
30 --echo
31 --echo # invalid values
32 # The values being assigned to wsrep_node_incoming_address are not verified so
33 # the following values are currently valid too.
34 SET @@global.wsrep_node_incoming_address=ON;
35 SELECT @@global.wsrep_node_incoming_address;
36 SET @@global.wsrep_node_incoming_address='OFF';
37 SELECT @@global.wsrep_node_incoming_address;
38 SET @@global.wsrep_node_incoming_address=NULL;
39 SELECT @@global.wsrep_node_incoming_address;
40 SET @@global.wsrep_node_incoming_address='junk';
41 SELECT @@global.wsrep_node_incoming_address;
42
43 --echo
44 --echo # restore the initial value
45 SET @@global.wsrep_node_incoming_address = @wsrep_node_incoming_address_global_saved;
46
47 --echo # End of test