Debian Codegraph @

mysql-test/suite/sys_vars/t/wsrep_desync_basic.test

raw
1 --source include/have_wsrep.inc
2
3 --echo #
4 --echo # wsrep_desync
5 --echo #
6
7 # expected as no wsrep provider is currently loaded
8 call mtr.add_suppression("WSREP: SET desync failed 9 for schema: test, query: SET @@global.wsrep_desync=ON");
9
10 --echo # save the initial value
11 SET @wsrep_desync_global_saved = @@global.wsrep_desync;
12
13 --echo # default
14 SELECT @@global.wsrep_desync;
15
16 --echo
17 --echo # scope
18 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
19 SELECT @@session.wsrep_desync;
20 --disable_warnings
21 --error 0,ER_WRONG_ARGUMENTS
22 SET @@global.wsrep_desync=OFF;
23 --enable_warnings
24 SELECT @@global.wsrep_desync;
25 # expected as no wsrep provider is currently loaded
26 --error ER_CANNOT_USER,ER_WRONG_ARGUMENTS
27 SET @@global.wsrep_desync=ON;
28 SELECT @@global.wsrep_desync;
29
30 --echo
31 --echo # valid values
32 --error 0,ER_WRONG_ARGUMENTS
33 SET @@global.wsrep_desync='OFF';
34 SELECT @@global.wsrep_desync;
35 # expected as no wsrep provider is currently loaded
36 --error ER_CANNOT_USER,ER_WRONG_ARGUMENTS
37 SET @@global.wsrep_desync=ON;
38 SELECT @@global.wsrep_desync;
39 --error 0,ER_WRONG_ARGUMENTS
40 SET @@global.wsrep_desync=default;
41 SELECT @@global.wsrep_desync;
42
43 --echo
44 --echo # invalid values
45 --error ER_WRONG_VALUE_FOR_VAR
46 SET @@global.wsrep_desync=NULL;
47 --error ER_WRONG_VALUE_FOR_VAR
48 SET @@global.wsrep_desync='junk';
49
50 --echo
51 --echo # restore the initial value
52 --disable_warnings
53 --error 0,ER_WRONG_ARGUMENTS
54 SET @@global.wsrep_desync = @wsrep_desync_global_saved;
55 --enable_warnings
56
57 --echo # End of test