Debian Codegraph @

mysql-test/suite/sys_vars/r/wsrep_debug_basic.result

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