Debian Codegraph @

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

raw
1 #
2 # wsrep_cluster_name
3 #
4 # save the initial value
5 SET @wsrep_cluster_name_global_saved = @@global.wsrep_cluster_name;
6 # default
7 SELECT @@global.wsrep_cluster_name;
8 @@global.wsrep_cluster_name
9 my_wsrep_cluster
10
11 # scope
12 SELECT @@session.wsrep_cluster_name;
13 ERROR HY000: Variable 'wsrep_cluster_name' is a GLOBAL variable
14 SET @@global.wsrep_cluster_name='my_galera_cluster';
15 SELECT @@global.wsrep_cluster_name;
16 @@global.wsrep_cluster_name
17 my_galera_cluster
18
19 # valid values
20 SET @@global.wsrep_cluster_name='my_quoted_galera_cluster';
21 SELECT @@global.wsrep_cluster_name;
22 @@global.wsrep_cluster_name
23 my_quoted_galera_cluster
24 SET @@global.wsrep_cluster_name=my_unquoted_cluster;
25 SELECT @@global.wsrep_cluster_name;
26 @@global.wsrep_cluster_name
27 my_unquoted_cluster
28 SET @@global.wsrep_cluster_name=OFF;
29 SELECT @@global.wsrep_cluster_name;
30 @@global.wsrep_cluster_name
31 OFF
32 SET @@global.wsrep_cluster_name=default;
33 SELECT @@global.wsrep_cluster_name;
34 @@global.wsrep_cluster_name
35 my_wsrep_cluster
36
37 # invalid values
38 SET @@global.wsrep_cluster_name=NULL;
39 ERROR 42000: Variable 'wsrep_cluster_name' can't be set to the value of 'NULL'
40
41 # restore the initial value
42 SET @@global.wsrep_cluster_name = @wsrep_cluster_name_global_saved;
43 # End of test