Debian Codegraph @

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

raw
1 #
2 # wsrep_desync
3 #
4 call mtr.add_suppression("WSREP: SET desync failed 9 for schema: test, query: SET @@global.wsrep_desync=ON");
5 # save the initial value
6 SET @wsrep_desync_global_saved = @@global.wsrep_desync;
7 # default
8 SELECT @@global.wsrep_desync;
9 @@global.wsrep_desync
10 0
11
12 # scope
13 SELECT @@session.wsrep_desync;
14 ERROR HY000: Variable 'wsrep_desync' is a GLOBAL variable
15 SET @@global.wsrep_desync=OFF;
16 SELECT @@global.wsrep_desync;
17 @@global.wsrep_desync
18 0
19 SET @@global.wsrep_desync=ON;
20 Got one of the listed errors
21 SELECT @@global.wsrep_desync;
22 @@global.wsrep_desync
23 0
24
25 # valid values
26 SET @@global.wsrep_desync='OFF';
27 SELECT @@global.wsrep_desync;
28 @@global.wsrep_desync
29 0
30 SET @@global.wsrep_desync=ON;
31 Got one of the listed errors
32 SELECT @@global.wsrep_desync;
33 @@global.wsrep_desync
34 0
35 SET @@global.wsrep_desync=default;
36 SELECT @@global.wsrep_desync;
37 @@global.wsrep_desync
38 0
39
40 # invalid values
41 SET @@global.wsrep_desync=NULL;
42 ERROR 42000: Variable 'wsrep_desync' can't be set to the value of 'NULL'
43 SET @@global.wsrep_desync='junk';
44 ERROR 42000: Variable 'wsrep_desync' can't be set to the value of 'junk'
45
46 # restore the initial value
47 SET @@global.wsrep_desync = @wsrep_desync_global_saved;
48 # End of test