Debian Codegraph @

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

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