1# 2# wsrep_debug 3# 4# save the initial value 5SET @wsrep_debug_global_saved = @@global.wsrep_debug; 6# default 7SELECT @@global.wsrep_debug; 8@@global.wsrep_debug 9NONE 10 11# scope 12SELECT @@session.wsrep_debug; 13ERROR HY000: Variable 'wsrep_debug' is a GLOBAL variable 14SET @@global.wsrep_debug=0; 15SELECT @@global.wsrep_debug; 16@@global.wsrep_debug 17NONE 18SET @@global.wsrep_debug=1; 19Warnings: 20Warning 1231 Setting 'wsrep_debug' has no effect because wsrep is switched off 21SELECT @@global.wsrep_debug; 22@@global.wsrep_debug 23NONE 24 25# valid values 26SET @@global.wsrep_debug=NONE; 27SELECT @@global.wsrep_debug; 28@@global.wsrep_debug 29NONE 30SET @@global.wsrep_debug=SERVER; 31Warnings: 32Warning 1231 Setting 'wsrep_debug' has no effect because wsrep is switched off 33SELECT @@global.wsrep_debug; 34@@global.wsrep_debug 35NONE 36SET @@global.wsrep_debug=default; 37SELECT @@global.wsrep_debug; 38@@global.wsrep_debug 39NONE 40 41# invalid values 42SET @@global.wsrep_debug=NULL; 43ERROR 42000: Variable 'wsrep_debug' can't be set to the value of 'NULL' 44SET @@global.wsrep_debug='junk'; 45ERROR 42000: Variable 'wsrep_debug' can't be set to the value of 'junk' 46SET @@global.wsrep_debug=ON; 47ERROR 42000: Variable 'wsrep_debug' can't be set to the value of 'ON' 48 49# restore the initial value 50SET @@global.wsrep_debug = @wsrep_debug_global_saved; 51# End of test 52