Debian Codegraph @

mysql-test/suite/galera/r/MW-313.result

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
4 INSERT INTO t1 VALUES (1);
5 INSERT INTO t1 SELECT * FROM t1;
6 INSERT INTO t1 SELECT * FROM t1;
7 INSERT INTO t1 SELECT * FROM t1;
8 INSERT INTO t1 SELECT * FROM t1;
9 INSERT INTO t1 SELECT * FROM t1;
10 SET GLOBAL wsrep_max_ws_rows = 2;
11 SET AUTOCOMMIT=OFF;
12 START TRANSACTION;
13 SELECT * FROM t1 GROUP BY f1;
14 f1
15 1
16 SELECT * FROM t1 GROUP BY f1;
17 f1
18 1
19 SELECT * FROM t1 GROUP BY f1;
20 f1
21 1
22 SHOW STATUS LIKE '%wsrep%';
23 INSERT INTO t1 SELECT * FROM t1;
24 ERROR HY000: wsrep_max_ws_rows exceeded
25 START TRANSACTION;
26 INSERT INTO t1 (f1) VALUES (1);
27 INSERT INTO t1 (f1) VALUES (2),(3),(4);
28 ERROR HY000: wsrep_max_ws_rows exceeded
29 ROLLBACK;
30 START TRANSACTION;
31 DELETE FROM t1;
32 ERROR HY000: wsrep_max_ws_rows exceeded
33 DROP TABLE t1;
34 SET GLOBAL wsrep_max_ws_rows = 0;