Debian Codegraph @

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

raw
1 --source include/have_wsrep.inc
2
3 --echo #
4 --echo # wsrep_node_name
5 --echo #
6
7 call mtr.add_suppression("WSREP: Failed to get provider options");
8
9 --echo # save the initial value
10 SET @wsrep_node_name_global_saved = @@global.wsrep_node_name;
11
12 --echo # default (expect 1)
13 SELECT COUNT(@@global.wsrep_node_name);
14
15 --echo
16 --echo # scope
17 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
18 SELECT @@session.wsrep_node_name;
19 SET @@global.wsrep_node_name='node_name';
20 SELECT @@global.wsrep_node_name;
21
22 --echo
23 --echo # valid values
24 SET @@global.wsrep_node_name='my_node';
25 SELECT @@global.wsrep_node_name;
26 SET @@global.wsrep_node_name='hyphenated-node-name';
27 SELECT @@global.wsrep_node_name;
28 SET @@global.wsrep_node_name=default;
29 --echo # default (expect 1)
30 SELECT COUNT(@@global.wsrep_node_name);
31
32 --echo
33 --echo # invalid values
34 --error ER_WRONG_VALUE_FOR_VAR
35 SET @@global.wsrep_node_name=NULL;
36 SELECT COUNT(@@global.wsrep_node_name);
37 --error ER_WRONG_TYPE_FOR_VAR
38 SET @@global.wsrep_node_name=1;
39 SELECT COUNT(@@global.wsrep_node_name);
40
41 --echo #
42 --echo # MDEV-6699 : wsrep_node_name not automaticly set to hostname
43 --echo #
44 SET @@global.wsrep_node_name=default;
45 SELECT @@GLOBAL.wsrep_node_name = VARIABLE_VALUE FROM
46 INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='hostname';
47 SELECT @@GLOBAL.wsrep_node_name = VARIABLE_VALUE FROM
48 INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='wsrep_node_name';
49
50 --echo
51 --echo # restore the initial value
52 SET @@global.wsrep_node_name = @wsrep_node_name_global_saved;
53
54 --echo # End of test