1#
2# wsrep_sst_donor_rejects_queries
3#
4# save the initial value
5SET @wsrep_sst_donor_rejects_queries_global_saved = @@global.wsrep_sst_donor_rejects_queries;
6# default
7SELECT @@global.wsrep_sst_donor_rejects_queries;
8@@global.wsrep_sst_donor_rejects_queries
90
10
11# scope
12SELECT @@session.wsrep_sst_donor_rejects_queries;
13ERROR HY000: Variable 'wsrep_sst_donor_rejects_queries' is a GLOBAL variable
14SET @@global.wsrep_sst_donor_rejects_queries=OFF;
15SELECT @@global.wsrep_sst_donor_rejects_queries;
16@@global.wsrep_sst_donor_rejects_queries
170
18SET @@global.wsrep_sst_donor_rejects_queries=ON;
19SELECT @@global.wsrep_sst_donor_rejects_queries;
20@@global.wsrep_sst_donor_rejects_queries
211
22
23# valid values
24SET @@global.wsrep_sst_donor_rejects_queries='OFF';
25SELECT @@global.wsrep_sst_donor_rejects_queries;
26@@global.wsrep_sst_donor_rejects_queries
270
28SET @@global.wsrep_sst_donor_rejects_queries=ON;
29SELECT @@global.wsrep_sst_donor_rejects_queries;
30@@global.wsrep_sst_donor_rejects_queries
311
32SET @@global.wsrep_sst_donor_rejects_queries=default;
33SELECT @@global.wsrep_sst_donor_rejects_queries;
34@@global.wsrep_sst_donor_rejects_queries
350
36
37# invalid values
38SET @@global.wsrep_sst_donor_rejects_queries=NULL;
39ERROR 42000: Variable 'wsrep_sst_donor_rejects_queries' can't be set to the value of 'NULL'
40SET @@global.wsrep_sst_donor_rejects_queries='junk';
41ERROR 42000: Variable 'wsrep_sst_donor_rejects_queries' can't be set to the value of 'junk'
42
43# restore the initial value
44SET @@global.wsrep_sst_donor_rejects_queries = @wsrep_sst_donor_rejects_queries_global_saved;
45# End of test
46