1#
2# wsrep_max_ws_size
3#
4# default
5SELECT @@global.wsrep_max_ws_size;
6@@global.wsrep_max_ws_size
72147483647
8
9# scope
10SELECT @@session.wsrep_max_ws_size;
11ERROR HY000: Variable 'wsrep_max_ws_size' is a GLOBAL variable
12SET @@global.wsrep_max_ws_size=1;
13ERROR HY000: WSREP (galera) not started
14SELECT @@global.wsrep_max_ws_size;
15@@global.wsrep_max_ws_size
162147483647
17
18# valid values
19SET @@global.wsrep_max_ws_size=1073741824;
20ERROR HY000: WSREP (galera) not started
21SELECT @@global.wsrep_max_ws_size;
22@@global.wsrep_max_ws_size
232147483647
24SET @@global.wsrep_max_ws_size=1073741825;
25ERROR HY000: WSREP (galera) not started
26SELECT @@global.wsrep_max_ws_size;
27@@global.wsrep_max_ws_size
282147483647
29SET @@global.wsrep_max_ws_size=0;
30ERROR HY000: WSREP (galera) not started
31SELECT @@global.wsrep_max_ws_size;
32@@global.wsrep_max_ws_size
332147483647
34SET @@global.wsrep_max_ws_size=default;
35ERROR HY000: WSREP (galera) not started
36SELECT @global.wsrep_max_ws_size;
37@global.wsrep_max_ws_size
38NULL
39
40# invalid values
41SET @@global.wsrep_max_ws_size=NULL;
42ERROR 42000: Incorrect argument type to variable 'wsrep_max_ws_size'
43SET @@global.wsrep_max_ws_size='junk';
44ERROR 42000: Incorrect argument type to variable 'wsrep_max_ws_size'
45SELECT @global.wsrep_max_ws_size;
46@global.wsrep_max_ws_size
47NULL
48SET @@global.wsrep_max_ws_size=-1;
49ERROR HY000: WSREP (galera) not started
50SELECT @global.wsrep_max_ws_size;
51@global.wsrep_max_ws_size
52NULL
53# End of test
54