Debian Codegraph @

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

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