Debian Codegraph @

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

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