diff options
Diffstat (limited to 'mysql-test/include/commit.inc')
-rw-r--r-- | mysql-test/include/commit.inc | 15 |
1 files changed, 10 insertions, 5 deletions
diff --git a/mysql-test/include/commit.inc b/mysql-test/include/commit.inc index a28d3e5f3d1..865f3296b39 100644 --- a/mysql-test/include/commit.inc +++ b/mysql-test/include/commit.inc @@ -405,6 +405,11 @@ end| delimiter ;| --echo # Reset Handler_commit and Handler_prepare counters flush status; + +--echo # +--echo # Count of reading of p_verify_status_increment() from mysql.proc +call p_verify_status_increment(2, 0, 2, 0); + --echo # --echo # 1. Read-only statement: SELECT --echo # @@ -562,7 +567,7 @@ begin return 2; end| delimiter ;| -call p_verify_status_increment(0, 0, 0, 0); +call p_verify_status_increment(4, 0, 4, 0); --echo # 16. A function changes non-trans-table. --echo # @@ -571,7 +576,7 @@ call p_verify_status_increment(0, 0, 0, 0); --echo # the binary log. --echo # select f1(); -call p_verify_status_increment(1, 0, 1, 0); +call p_verify_status_increment(3, 0, 3, 0); commit; call p_verify_status_increment(1, 0, 1, 0); @@ -650,7 +655,7 @@ call p_verify_status_increment(0, 0, 0, 0); --echo # 24. DDL: TRUNCATE TEMPORARY TABLE --echo truncate table t2; -call p_verify_status_increment(4, 0, 4, 0); +call p_verify_status_increment(2, 0, 2, 0); commit; --echo # There is nothing left to commit call p_verify_status_increment(0, 0, 0, 0); @@ -763,7 +768,7 @@ call p_verify_status_increment(0, 0, 0, 0); truncate table t3; call p_verify_status_increment(2, 0, 2, 0); create view v1 as select * from t2; -call p_verify_status_increment(2, 0, 2, 0); +call p_verify_status_increment(4, 0, 4, 0); check table t1; call p_verify_status_increment(2, 0, 2, 0); --echo # Sic: after this bug is fixed, CHECK leaves no pending transaction @@ -774,7 +779,7 @@ call p_verify_status_increment(6, 0, 6, 0); commit; call p_verify_status_increment(0, 0, 0, 0); drop view v1; -call p_verify_status_increment(0, 0, 0, 0); +call p_verify_status_increment(2, 0, 2, 0); --echo # --echo # Cleanup |