1#
2# wsrep_node_address
3#
4# save the initial value
5SET @wsrep_node_address_global_saved = @@global.wsrep_node_address;
6# default
7SELECT @@global.wsrep_node_address;
8@@global.wsrep_node_address
9
10
11# scope
12SELECT @@session.wsrep_node_address;
13ERROR HY000: Variable 'wsrep_node_address' is a GLOBAL variable
14SELECT @@global.wsrep_node_address;
15@@global.wsrep_node_address
16
17
18# valid values
19SET @@global.wsrep_node_address='127.0.0.1';
20SELECT @@global.wsrep_node_address;
21@@global.wsrep_node_address
22127.0.0.1
23SET @@global.wsrep_node_address=default;
24SELECT @@global.wsrep_node_address;
25@@global.wsrep_node_address
26
27
28# invalid values
29SET @@global.wsrep_node_address=NULL;
30ERROR 42000: Variable 'wsrep_node_address' can't be set to the value of 'NULL'
31SELECT @@global.wsrep_node_address;
32@@global.wsrep_node_address
33
34SET @@global.wsrep_node_address=ON;
35SELECT @@global.wsrep_node_address;
36@@global.wsrep_node_address
37ON
38SET @@global.wsrep_node_address='OFF';
39SELECT @@global.wsrep_node_address;
40@@global.wsrep_node_address
41OFF
42SET @@global.wsrep_node_address='junk';
43SELECT @@global.wsrep_node_address;
44@@global.wsrep_node_address
45junk
46
47# restore the initial value
48SET @@global.wsrep_node_address = @wsrep_node_address_global_saved;
49# End of test
50