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