Debian Codegraph @

mysql-test/suite/sys_vars/t/wsrep_max_ws_rows_basic.test

raw
1 --source include/have_wsrep.inc
2
3 --echo #
4 --echo # wsrep_max_ws_rows
5 --echo #
6
7 --echo # save the initial value
8 SET @wsrep_max_ws_rows_global_saved = @@global.wsrep_max_ws_rows;
9
10 --echo # default
11 SELECT @@global.wsrep_max_ws_rows;
12
13 --echo
14 --echo # scope
15 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
16 SELECT @@session.wsrep_max_ws_rows;
17 SET @@global.wsrep_max_ws_rows=1;
18 SELECT @@global.wsrep_max_ws_rows;
19
20 --echo
21 --echo # valid values
22 SET @@global.wsrep_max_ws_rows=131072;
23 SELECT @@global.wsrep_max_ws_rows;
24 SET @@global.wsrep_max_ws_rows=131073;
25 SELECT @@global.wsrep_max_ws_rows;
26 SET @@global.wsrep_max_ws_rows=0;
27 SELECT @@global.wsrep_max_ws_rows;
28 SET @@global.wsrep_max_ws_rows=default;
29 SELECT @global.wsrep_max_ws_rows;
30
31 --echo
32 --echo # invalid values
33 --error ER_WRONG_TYPE_FOR_VAR
34 SET @@global.wsrep_max_ws_rows=NULL;
35 --error ER_WRONG_TYPE_FOR_VAR
36 SET @@global.wsrep_max_ws_rows='junk';
37 # expect warnings (Truncated incorrect wsrep_max_ws_rows value: '-1')
38 SET @@global.wsrep_max_ws_rows=-1;
39 SELECT @global.wsrep_max_ws_rows;
40
41 --echo
42 --echo # restore the initial value
43 SET @@global.wsrep_max_ws_rows = @wsrep_max_ws_rows_global_saved;
44
45 --echo # End of test