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