diff options
author | Daniele Sciascia <daniele.sciascia@galeracluster.com> | 2016-05-05 13:20:32 +0200 |
---|---|---|
committer | Nirbhay Choubey <nirbhay@mariadb.com> | 2016-07-25 11:24:23 -0400 |
commit | 5197fcf6b4611a26b3847d1101f1a4fb6d17570a (patch) | |
tree | 7fa1eb57f7acac2e2adaef9f1b3fff06c3355aa8 /mysql-test/suite/galera/r/galera_var_max_ws_rows.result | |
parent | e373f60fd161eaf050eb117c9a05d8d83fe0e501 (diff) | |
download | mariadb-git-5197fcf6b4611a26b3847d1101f1a4fb6d17570a.tar.gz |
MW-269 Fix outstanding issues with wsrep_max_ws_rows
This patch includes two fixes:
1) Rollback when wsrep_max_ws_rows is exceeded would not switch
back to previous autocommit mode; and 2) Internal rows counter
would not be reset on implicit commits.
Diffstat (limited to 'mysql-test/suite/galera/r/galera_var_max_ws_rows.result')
-rw-r--r-- | mysql-test/suite/galera/r/galera_var_max_ws_rows.result | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/suite/galera/r/galera_var_max_ws_rows.result b/mysql-test/suite/galera/r/galera_var_max_ws_rows.result index e41f0f96c95..6e239c70a3e 100644 --- a/mysql-test/suite/galera/r/galera_var_max_ws_rows.result +++ b/mysql-test/suite/galera/r/galera_var_max_ws_rows.result @@ -89,5 +89,27 @@ DELETE FROM t1 WHERE f2 = 2; SELECT COUNT(*) = 0 FROM t1; COUNT(*) = 0 1 +SET AUTOCOMMIT = ON; +SET GLOBAL wsrep_max_ws_rows = 1; +START TRANSACTION; +INSERT INTO t1 (f2) VALUES (1); +INSERT INTO t1 (f2) VALUES (2); +ERROR HY000: wsrep_max_ws_rows exceeded +INSERT INTO t1 (f2) VALUES (1); +INSERT INTO t1 (f2) VALUES (2); +SET AUTOCOMMIT = OFF; +START TRANSACTION; +INSERT INTO t1 (f2) VALUES (1); +INSERT INTO t1 (f2) VALUES (2); +ERROR HY000: wsrep_max_ws_rows exceeded +INSERT INTO t1 (f2) VALUES (1); +INSERT INTO t1 (f2) VALUES (2); +ERROR HY000: wsrep_max_ws_rows exceeded +START TRANSACTION; +INSERT INTO t1 (f2) VALUES (1); +START TRANSACTION; +INSERT INTO t1 (f2) VALUES (1); +INSERT INTO t1 (f2) VALUES (2); +ERROR HY000: wsrep_max_ws_rows exceeded DROP TABLE t1; DROP TABLE ten; |