Debian Codegraph @

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

raw
1 #
2 # wsrep_sst_method
3 #
4 # save the initial value
5 SET @wsrep_sst_method_global_saved = @@global.wsrep_sst_method;
6 # default
7 SELECT @@global.wsrep_sst_method;
8 @@global.wsrep_sst_method
9 rsync
10
11 # scope
12 SELECT @@session.wsrep_sst_method;
13 ERROR HY000: Variable 'wsrep_sst_method' is a GLOBAL variable
14 SET @@global.wsrep_sst_method=rsync;
15 SELECT @@global.wsrep_sst_method;
16 @@global.wsrep_sst_method
17 rsync
18
19 # valid values
20 SET @@global.wsrep_sst_method=rsync;
21 SELECT @@global.wsrep_sst_method;
22 @@global.wsrep_sst_method
23 rsync
24 SET @@global.wsrep_sst_method=mysqldump;
25 SELECT @@global.wsrep_sst_method;
26 @@global.wsrep_sst_method
27 mysqldump
28 SET @@global.wsrep_sst_method=xtrabackup;
29 SELECT @@global.wsrep_sst_method;
30 @@global.wsrep_sst_method
31 xtrabackup
32 SET @@global.wsrep_sst_method="xtrabackup-v2";
33 SELECT @@global.wsrep_sst_method;
34 @@global.wsrep_sst_method
35 xtrabackup-v2
36 SET @@global.wsrep_sst_method="mariabackup";
37 SELECT @@global.wsrep_sst_method;
38 @@global.wsrep_sst_method
39 mariabackup
40 SET @@global.wsrep_sst_method=default;
41 SELECT @@global.wsrep_sst_method;
42 @@global.wsrep_sst_method
43 rsync
44 SET @@global.wsrep_sst_method='junk';
45 SELECT @@global.wsrep_sst_method;
46 @@global.wsrep_sst_method
47 junk
48
49 # invalid values
50 SET @@global.wsrep_sst_method=NULL;
51 ERROR 42000: Variable 'wsrep_sst_method' can't be set to the value of 'NULL'
52 SELECT @@global.wsrep_sst_method;
53 @@global.wsrep_sst_method
54 junk
55
56 # restore the initial value
57 SET @@global.wsrep_sst_method = @wsrep_sst_method_global_saved;
58 # End of test