Debian Codegraph @

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

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