EVOLUTION-MANAGER

Edit File: MW-313.result

CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB; INSERT INTO t1 VALUES (1); INSERT INTO t1 SELECT * FROM t1; INSERT INTO t1 SELECT * FROM t1; INSERT INTO t1 SELECT * FROM t1; INSERT INTO t1 SELECT * FROM t1; INSERT INTO t1 SELECT * FROM t1; SET GLOBAL wsrep_max_ws_rows = 2; SET AUTOCOMMIT=OFF; START TRANSACTION; SELECT * FROM t1 GROUP BY f1; f1 1 SELECT * FROM t1 GROUP BY f1; f1 1 SELECT * FROM t1 GROUP BY f1; f1 1 SHOW STATUS LIKE '%wsrep%'; INSERT INTO t1 SELECT * FROM t1; ERROR HY000: wsrep_max_ws_rows exceeded START TRANSACTION; INSERT INTO t1 (f1) VALUES (1); INSERT INTO t1 (f1) VALUES (2),(3),(4); ERROR HY000: wsrep_max_ws_rows exceeded ROLLBACK; START TRANSACTION; DELETE FROM t1; ERROR HY000: wsrep_max_ws_rows exceeded DROP TABLE t1; SET GLOBAL wsrep_max_ws_rows = 0;