Debian Codegraph @

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

raw
1 --source include/have_wsrep.inc
2
3 --echo #
4 --echo # wsrep_sync_wait
5 --echo #
6
7 --echo # save the initial values
8 SET @wsrep_sync_wait_global_saved = @@global.wsrep_sync_wait;
9 SET @wsrep_sync_wait_session_saved = @@session.wsrep_sync_wait;
10
11 --echo # default
12 SELECT @@global.wsrep_sync_wait;
13 SELECT @@session.wsrep_sync_wait;
14
15 --echo
16 --echo # scope and valid values
17 SET @@global.wsrep_sync_wait=0;
18 SELECT @@global.wsrep_sync_wait;
19 SET @@global.wsrep_sync_wait=7;
20 SELECT @@global.wsrep_sync_wait;
21
22 SET @@session.wsrep_sync_wait=0;
23 SELECT @@session.wsrep_sync_wait;
24 SET @@session.wsrep_sync_wait=7;
25 SELECT @@session.wsrep_sync_wait;
26 SET @@session.wsrep_sync_wait=default;
27 SELECT @@session.wsrep_sync_wait;
28 SET @@session.wsrep_sync_wait=8;
29 SELECT @@session.wsrep_sync_wait;
30
31 --echo
32 --echo # invalid values
33 --error ER_WRONG_TYPE_FOR_VAR
34 SET @@global.wsrep_sync_wait=NULL;
35 --error ER_WRONG_TYPE_FOR_VAR
36 SET @@global.wsrep_sync_wait='junk';
37 --error ER_WRONG_TYPE_FOR_VAR
38 SET @@session.wsrep_sync_wait=NULL;
39 --error ER_WRONG_TYPE_FOR_VAR
40 SET @@session.wsrep_sync_wait='junk';
41
42 --echo
43 --echo # restore the initial values
44 SET @@global.wsrep_sync_wait = @wsrep_sync_wait_global_saved;
45 SET @@session.wsrep_sync_wait = @wsrep_sync_wait_session_saved;
46
47 --echo # End of test