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