1# 2# wsrep_dbug_option 3# 4# save the initial value 5SET @wsrep_dbug_option_global_saved = @@global.wsrep_dbug_option; 6# default 7SELECT @@global.wsrep_dbug_option; 8@@global.wsrep_dbug_option 9 10 11# scope 12SELECT @@session.wsrep_dbug_option; 13ERROR HY000: Variable 'wsrep_dbug_option' is a GLOBAL variable 14SET @@global.wsrep_dbug_option='test-dbug-string'; 15SELECT @@global.wsrep_dbug_option; 16@@global.wsrep_dbug_option 17test-dbug-string 18 19# valid values 20SET @@global.wsrep_dbug_option='quoted-dbug-string'; 21SELECT @@global.wsrep_dbug_option; 22@@global.wsrep_dbug_option 23quoted-dbug-string 24SET @@global.wsrep_dbug_option=unquoted_dbug_string; 25SELECT @@global.wsrep_dbug_option; 26@@global.wsrep_dbug_option 27unquoted_dbug_string 28SET @@global.wsrep_dbug_option=OFF; 29SELECT @@global.wsrep_dbug_option; 30@@global.wsrep_dbug_option 31OFF 32SET @@global.wsrep_dbug_option=NULL; 33SELECT @@global.wsrep_dbug_option; 34@@global.wsrep_dbug_option 35NULL 36SET @@global.wsrep_dbug_option=default; 37SELECT @@global.wsrep_dbug_option; 38@@global.wsrep_dbug_option 39 40 41# invalid values 42SET @@global.wsrep_dbug_option=1; 43ERROR 42000: Incorrect argument type to variable 'wsrep_dbug_option' 44 45# restore the initial value 46SET @@global.wsrep_dbug_option = @wsrep_dbug_option_global_saved; 47# End of test 48