Debian Codegraph @

mysql-test/suite/sys_vars/r/wsrep_node_name_basic.result

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