Debian Codegraph @

mysql-test/suite/wsrep/t/wsrep_variables_sst_method.test

raw
1 --source include/have_wsrep.inc
2 --source include/have_innodb.inc
3
4 SELECT @@wsrep_on;
5
6 SET @wsrep_sst_method_saved = @@global.wsrep_sst_method;
7
8 /* test currently supported methods */
9 SET GLOBAL wsrep_sst_method=DEFAULT;
10 SELECT @@global.wsrep_sst_method;
11
12 SET GLOBAL wsrep_sst_method='rsync';
13 SELECT @@global.wsrep_sst_method;
14
15 SET GLOBAL wsrep_sst_method='mysqldump';
16 SELECT @@global.wsrep_sst_method;
17
18 SET GLOBAL wsrep_sst_method='mariabackup';
19 SELECT @@global.wsrep_sst_method;
20
21 SET GLOBAL wsrep_sst_method='backup';
22 SELECT @@global.wsrep_sst_method;
23
24 SET GLOBAL wsrep_sst_method='backup1.sh';
25 SELECT @@global.wsrep_sst_method;
26
27 --error ER_WRONG_VALUE_FOR_VAR
28 SET GLOBAL wsrep_sst_method='my method';
29 SELECT @@global.wsrep_sst_method;
30 SHOW WARNINGS;
31
32 --error ER_WRONG_VALUE_FOR_VAR
33 SET GLOBAL wsrep_sst_method='/method';
34 SELECT @@global.wsrep_sst_method;
35 SHOW WARNINGS;
36
37 --error ER_WRONG_VALUE_FOR_VAR
38 SET GLOBAL wsrep_sst_method='method!';
39 SELECT @@global.wsrep_sst_method;
40 SHOW WARNINGS;
41
42 --error ER_WRONG_VALUE_FOR_VAR
43 SET GLOBAL wsrep_sst_method='method;';
44 SELECT @@global.wsrep_sst_method;
45 SHOW WARNINGS;
46
47 --disable_query_log
48 SET @@global.wsrep_sst_method = @wsrep_sst_method_saved;
49 --enable_query_log