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