Debian Codegraph @

mysql-test/suite/galera/t/galera_var_sst_method.test

raw
1 #
2 # Check the handling of @@wsrep_sst_method
3 #
4 --source include/galera_cluster.inc
5
6 --connection node_1
7 SET @sst_method_orig=@@GLOBAL.wsrep_sst_method;
8 --error ER_WRONG_VALUE_FOR_VAR
9 set global wsrep_sst_method='mariabackup;';
10 select @@wsrep_sst_method;
11 --error ER_WRONG_VALUE_FOR_VAR
12 set global wsrep_sst_method='mariabackup\'';
13 select @@wsrep_sst_method;
14 --error ER_WRONG_VALUE_FOR_VAR
15 set global wsrep_sst_method='mariabackup&';
16 select @@wsrep_sst_method;
17 --error ER_WRONG_VALUE_FOR_VAR
18 set global wsrep_sst_method='mariabackup|';
19 select @@wsrep_sst_method;
20 --error ER_WRONG_VALUE_FOR_VAR
21 set global wsrep_sst_method=NULL;
22 select @@wsrep_sst_method;
23 --error ER_WRONG_VALUE_FOR_VAR
24 set global wsrep_sst_method='';
25 select @@wsrep_sst_method;
26
27 set global wsrep_sst_method='mariabackup';
28 select @@wsrep_sst_method;
29 set global wsrep_sst_method='rsync';
30 select @@wsrep_sst_method;
31
32 --disable_query_log
33 SET GLOBAL wsrep_sst_method = @sst_method_orig;
34 --enable_query_log
35
36 --source include/galera_end.inc