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