Debian Codegraph @

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

raw
1 #
2 # wsrep_max_ws_rows
3 #
4 # save the initial value
5 SET @wsrep_max_ws_rows_global_saved = @@global.wsrep_max_ws_rows;
6 # default
7 SELECT @@global.wsrep_max_ws_rows;
8 @@global.wsrep_max_ws_rows
9 0
10
11 # scope
12 SELECT @@session.wsrep_max_ws_rows;
13 ERROR HY000: Variable 'wsrep_max_ws_rows' is a GLOBAL variable
14 SET @@global.wsrep_max_ws_rows=1;
15 SELECT @@global.wsrep_max_ws_rows;
16 @@global.wsrep_max_ws_rows
17 1
18
19 # valid values
20 SET @@global.wsrep_max_ws_rows=131072;
21 SELECT @@global.wsrep_max_ws_rows;
22 @@global.wsrep_max_ws_rows
23 131072
24 SET @@global.wsrep_max_ws_rows=131073;
25 SELECT @@global.wsrep_max_ws_rows;
26 @@global.wsrep_max_ws_rows
27 131073
28 SET @@global.wsrep_max_ws_rows=0;
29 SELECT @@global.wsrep_max_ws_rows;
30 @@global.wsrep_max_ws_rows
31 0
32 SET @@global.wsrep_max_ws_rows=default;
33 SELECT @global.wsrep_max_ws_rows;
34 @global.wsrep_max_ws_rows
35 NULL
36
37 # invalid values
38 SET @@global.wsrep_max_ws_rows=NULL;
39 ERROR 42000: Incorrect argument type to variable 'wsrep_max_ws_rows'
40 SET @@global.wsrep_max_ws_rows='junk';
41 ERROR 42000: Incorrect argument type to variable 'wsrep_max_ws_rows'
42 SET @@global.wsrep_max_ws_rows=-1;
43 Warnings:
44 Warning 1292 Truncated incorrect wsrep_max_ws_rows value: '-1'
45 SELECT @global.wsrep_max_ws_rows;
46 @global.wsrep_max_ws_rows
47 NULL
48
49 # restore the initial value
50 SET @@global.wsrep_max_ws_rows = @wsrep_max_ws_rows_global_saved;
51 # End of test