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