Debian Codegraph @

mysql-test/suite/wsrep/r/wsrep_variables_sst_method.result

raw
1 SELECT @@wsrep_on;
2 @@wsrep_on
3 1
4 SET @wsrep_sst_method_saved = @@global.wsrep_sst_method;
5 /* test currently supported methods */
6 SET GLOBAL wsrep_sst_method=DEFAULT;
7 SELECT @@global.wsrep_sst_method;
8 @@global.wsrep_sst_method
9 rsync
10 SET GLOBAL wsrep_sst_method='rsync';
11 SELECT @@global.wsrep_sst_method;
12 @@global.wsrep_sst_method
13 rsync
14 SET GLOBAL wsrep_sst_method='mysqldump';
15 SELECT @@global.wsrep_sst_method;
16 @@global.wsrep_sst_method
17 mysqldump
18 SET GLOBAL wsrep_sst_method='mariabackup';
19 SELECT @@global.wsrep_sst_method;
20 @@global.wsrep_sst_method
21 mariabackup
22 SET GLOBAL wsrep_sst_method='backup';
23 SELECT @@global.wsrep_sst_method;
24 @@global.wsrep_sst_method
25 backup
26 SET GLOBAL wsrep_sst_method='backup1.sh';
27 SELECT @@global.wsrep_sst_method;
28 @@global.wsrep_sst_method
29 backup1.sh
30 SET GLOBAL wsrep_sst_method='my method';
31 ERROR 42000: Variable 'wsrep_sst_method' can't be set to the value of 'my method'
32 SELECT @@global.wsrep_sst_method;
33 @@global.wsrep_sst_method
34 backup1.sh
35 SHOW WARNINGS;
36 Level Code Message
37 Error 1231 Variable 'wsrep_sst_method' can't be set to the value of 'my method'
38 SET GLOBAL wsrep_sst_method='/method';
39 ERROR 42000: Variable 'wsrep_sst_method' can't be set to the value of '/method'
40 SELECT @@global.wsrep_sst_method;
41 @@global.wsrep_sst_method
42 backup1.sh
43 SHOW WARNINGS;
44 Level Code Message
45 Error 1231 Variable 'wsrep_sst_method' can't be set to the value of '/method'
46 SET GLOBAL wsrep_sst_method='method!';
47 ERROR 42000: Variable 'wsrep_sst_method' can't be set to the value of 'method!'
48 SELECT @@global.wsrep_sst_method;
49 @@global.wsrep_sst_method
50 backup1.sh
51 SHOW WARNINGS;
52 Level Code Message
53 Error 1231 Variable 'wsrep_sst_method' can't be set to the value of 'method!'
54 SET GLOBAL wsrep_sst_method='method;';
55 ERROR 42000: Variable 'wsrep_sst_method' can't be set to the value of 'method;'
56 SELECT @@global.wsrep_sst_method;
57 @@global.wsrep_sst_method
58 backup1.sh
59 SHOW WARNINGS;
60 Level Code Message
61 Error 1231 Variable 'wsrep_sst_method' can't be set to the value of 'method;'