1#
2# wsrep_node_name
3#
4call mtr.add_suppression("WSREP: Failed to get provider options");
5# save the initial value
6SET @wsrep_node_name_global_saved = @@global.wsrep_node_name;
7# default (expect 1)
8SELECT COUNT(@@global.wsrep_node_name);
9COUNT(@@global.wsrep_node_name)
101
11
12# scope
13SELECT @@session.wsrep_node_name;
14ERROR HY000: Variable 'wsrep_node_name' is a GLOBAL variable
15SET @@global.wsrep_node_name='node_name';
16SELECT @@global.wsrep_node_name;
17@@global.wsrep_node_name
18node_name
19
20# valid values
21SET @@global.wsrep_node_name='my_node';
22SELECT @@global.wsrep_node_name;
23@@global.wsrep_node_name
24my_node
25SET @@global.wsrep_node_name='hyphenated-node-name';
26SELECT @@global.wsrep_node_name;
27@@global.wsrep_node_name
28hyphenated-node-name
29SET @@global.wsrep_node_name=default;
30# default (expect 1)
31SELECT COUNT(@@global.wsrep_node_name);
32COUNT(@@global.wsrep_node_name)
331
34
35# invalid values
36SET @@global.wsrep_node_name=NULL;
37ERROR 42000: Variable 'wsrep_node_name' can't be set to the value of 'NULL'
38SELECT COUNT(@@global.wsrep_node_name);
39COUNT(@@global.wsrep_node_name)
401
41SET @@global.wsrep_node_name=1;
42ERROR 42000: Incorrect argument type to variable 'wsrep_node_name'
43SELECT COUNT(@@global.wsrep_node_name);
44COUNT(@@global.wsrep_node_name)
451
46#
47# MDEV-6699 : wsrep_node_name not automaticly set to hostname
48#
49SET @@global.wsrep_node_name=default;
50SELECT @@GLOBAL.wsrep_node_name = VARIABLE_VALUE FROM
51INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='hostname';
52@@GLOBAL.wsrep_node_name = VARIABLE_VALUE
531
54SELECT @@GLOBAL.wsrep_node_name = VARIABLE_VALUE FROM
55INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='wsrep_node_name';
56@@GLOBAL.wsrep_node_name = VARIABLE_VALUE
571
58
59# restore the initial value
60SET @@global.wsrep_node_name = @wsrep_node_name_global_saved;
61# End of test
62