summaryrefslogtreecommitdiff
path: root/mysql-test/t
diff options
context:
space:
mode:
authorunknown <kaa@polly.local>2006-10-11 12:44:03 +0400
committerunknown <kaa@polly.local>2006-10-11 12:44:03 +0400
commit0191c41f4d53e7aef93119ef0b82ab47326d5aa1 (patch)
treec33092a2b1c8efa4b7445597bbad3840ac6dcc5d /mysql-test/t
parentcffec062f8b6f30c309de7cf7f39d45f7b8d4eed (diff)
downloadmariadb-git-0191c41f4d53e7aef93119ef0b82ab47326d5aa1.tar.gz
Fix for bug #22728 "Handler_rollback value is growing".
The bug is present only in 4.1, will be null-merged to 5.0 For InnoDB, check value of thd->transaction.all.innodb_active_trans instead of thd->transaction.stmt.innobase_tid to see if we really need to rollback. mysql-test/r/innodb_mysql.result: Added testcase for bug #22728 "Handler_rollback value is growing" mysql-test/t/innodb_mysql.test: Added testcase for bug #22728 "Handler_rollback value is growing" sql/handler.cc: For InnoDB, check value of thd->transaction.all.innodb_active_trans instead of thd->transaction.stmt.innobase_tid to see if we really need to rollback.
Diffstat (limited to 'mysql-test/t')
-rw-r--r--mysql-test/t/innodb_mysql.test18
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/t/innodb_mysql.test b/mysql-test/t/innodb_mysql.test
index f31e4d64789..ce8030d389d 100644
--- a/mysql-test/t/innodb_mysql.test
+++ b/mysql-test/t/innodb_mysql.test
@@ -57,3 +57,21 @@ where
c.c_id = 218 and expiredate is null;
drop table t1, t2;
+
+#
+# Bug #22728 - Handler_rollback value is growing
+#
+flush status;
+create table t1 (c1 int) engine=innodb;
+connect (con1,localhost,root,,);
+connect (con2,localhost,root,,);
+connection con2;
+handler t1 open;
+handler t1 read first;
+disconnect con2;
+connection con1;
+show /*!50002 GLOBAL */ status like 'Handler_rollback';
+connection default;
+drop table t1;
+disconnect con1;
+--echo End of 4.1 tests