Debian Codegraph @

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

raw
1 #
2 # wsrep_sync_wait
3 #
4 # save the initial values
5 SET @wsrep_sync_wait_global_saved = @@global.wsrep_sync_wait;
6 SET @wsrep_sync_wait_session_saved = @@session.wsrep_sync_wait;
7 # default
8 SELECT @@global.wsrep_sync_wait;
9 @@global.wsrep_sync_wait
10 0
11 SELECT @@session.wsrep_sync_wait;
12 @@session.wsrep_sync_wait
13 0
14
15 # scope and valid values
16 SET @@global.wsrep_sync_wait=0;
17 SELECT @@global.wsrep_sync_wait;
18 @@global.wsrep_sync_wait
19 0
20 SET @@global.wsrep_sync_wait=7;
21 SELECT @@global.wsrep_sync_wait;
22 @@global.wsrep_sync_wait
23 7
24 SET @@session.wsrep_sync_wait=0;
25 SELECT @@session.wsrep_sync_wait;
26 @@session.wsrep_sync_wait
27 0
28 SET @@session.wsrep_sync_wait=7;
29 SELECT @@session.wsrep_sync_wait;
30 @@session.wsrep_sync_wait
31 7
32 SET @@session.wsrep_sync_wait=default;
33 SELECT @@session.wsrep_sync_wait;
34 @@session.wsrep_sync_wait
35 7
36 SET @@session.wsrep_sync_wait=8;
37 SELECT @@session.wsrep_sync_wait;
38 @@session.wsrep_sync_wait
39 8
40
41 # invalid values
42 SET @@global.wsrep_sync_wait=NULL;
43 ERROR 42000: Incorrect argument type to variable 'wsrep_sync_wait'
44 SET @@global.wsrep_sync_wait='junk';
45 ERROR 42000: Incorrect argument type to variable 'wsrep_sync_wait'
46 SET @@session.wsrep_sync_wait=NULL;
47 ERROR 42000: Incorrect argument type to variable 'wsrep_sync_wait'
48 SET @@session.wsrep_sync_wait='junk';
49 ERROR 42000: Incorrect argument type to variable 'wsrep_sync_wait'
50
51 # restore the initial values
52 SET @@global.wsrep_sync_wait = @wsrep_sync_wait_global_saved;
53 SET @@session.wsrep_sync_wait = @wsrep_sync_wait_session_saved;
54 # End of test