Debian Codegraph @

mysql-test/suite/galera/t/MW-309.test

raw
1 #
2 # MW-309 Regression: wsrep_max_ws_rows limit also applies to certain SELECT queries
3 #
4
5 --source include/galera_cluster.inc
6 --source include/have_innodb.inc
7
8 CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
9 INSERT INTO t1 VALUES (1);
10 INSERT INTO t1 SELECT * FROM t1;
11 INSERT INTO t1 SELECT * FROM t1;
12 INSERT INTO t1 SELECT * FROM t1;
13 INSERT INTO t1 SELECT * FROM t1;
14 INSERT INTO t1 SELECT * FROM t1;
15
16 SET GLOBAL wsrep_max_ws_rows = 2;
17
18 SET AUTOCOMMIT=OFF;
19 START TRANSACTION;
20 SELECT * FROM t1 GROUP BY f1;
21 SELECT * FROM t1 GROUP BY f1;
22
23 --error 0
24 SELECT * FROM t1 GROUP BY f1;
25
26 --disable_result_log
27 --error 0
28 SHOW STATUS LIKE '%wsrep%';
29 --enable_result_log
30
31 SET GLOBAL wsrep_max_ws_rows = 0;
32 DROP TABLE t1;