Debian Codegraph @

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

raw
1 #
2 # MW-313 Enforce wsrep_max_ws_rows also when binlog is enabled
3 #
4
5 --source include/galera_cluster.inc
6 --source include/have_innodb.inc
7 --source include/have_binlog_format_row.inc
8
9 # No error expected for SELECT and SHOW
10
11 CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
12 INSERT INTO t1 VALUES (1);
13 INSERT INTO t1 SELECT * FROM t1;
14 INSERT INTO t1 SELECT * FROM t1;
15 INSERT INTO t1 SELECT * FROM t1;
16 INSERT INTO t1 SELECT * FROM t1;
17 INSERT INTO t1 SELECT * FROM t1;
18
19 SET GLOBAL wsrep_max_ws_rows = 2;
20
21 SET AUTOCOMMIT=OFF;
22 START TRANSACTION;
23 SELECT * FROM t1 GROUP BY f1;
24 SELECT * FROM t1 GROUP BY f1;
25
26 --error 0
27 SELECT * FROM t1 GROUP BY f1;
28
29 --disable_result_log
30 --error 0
31 SHOW STATUS LIKE '%wsrep%';
32 --enable_result_log
33
34 # Error expected for DML
35
36 --error ER_ERROR_DURING_COMMIT
37 INSERT INTO t1 SELECT * FROM t1;
38
39 START TRANSACTION;
40 INSERT INTO t1 (f1) VALUES (1);
41
42 --error ER_ERROR_DURING_COMMIT
43 INSERT INTO t1 (f1) VALUES (2),(3),(4);
44
45 ROLLBACK;
46 START TRANSACTION;
47 --error ER_ERROR_DURING_COMMIT
48 DELETE FROM t1;
49
50 DROP TABLE t1;
51 SET GLOBAL wsrep_max_ws_rows = 0;