summaryrefslogtreecommitdiff
path: root/mysql-test/include/commit.inc
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/include/commit.inc')
-rw-r--r--mysql-test/include/commit.inc13
1 files changed, 4 insertions, 9 deletions
diff --git a/mysql-test/include/commit.inc b/mysql-test/include/commit.inc
index 770871fbcca..9bd11bf33c1 100644
--- a/mysql-test/include/commit.inc
+++ b/mysql-test/include/commit.inc
@@ -421,15 +421,10 @@ call p_verify_status_increment(2, 2, 2, 2);
--echo # 4. Read-write statement: UPDATE, update 0 rows, 1 row matches WHERE
--echo #
---echo # Note the wrong Handler_prepare/Handler_commit count is due to
---echo # Bug#29157 "UPDATE, changed rows incorrect" and
---echo # Bug#Bug #33846 UPDATE word:Wrong 'Changed rows' if InnoDB, unique
---echo # key and no rows qualify WHERE
---echo #
update t1 set a=2;
-call p_verify_status_increment(2, 2, 2, 2);
+call p_verify_status_increment(2, 2, 1, 0);
commit;
-call p_verify_status_increment(2, 2, 2, 2);
+call p_verify_status_increment(2, 2, 1, 0);
--echo # 5. Read-write statement: UPDATE, update 0 rows, 0 rows match WHERE
--echo #
@@ -483,9 +478,9 @@ call p_verify_status_increment(2, 2, 2, 2);
--echo # 10. Read-write statement: REPLACE, change 0 rows.
--echo #
replace t1 set a=1;
-call p_verify_status_increment(2, 2, 2, 2);
+call p_verify_status_increment(2, 2, 1, 0);
commit;
-call p_verify_status_increment(2, 2, 2, 2);
+call p_verify_status_increment(2, 2, 1, 0);
--echo # 11. Read-write statement: IODKU, change 1 row.
--echo #