diff options
| author | Annamalai Gurusami <annamalai.gurusami@oracle.com> | 2012-03-16 12:06:29 +0530 |
|---|---|---|
| committer | Annamalai Gurusami <annamalai.gurusami@oracle.com> | 2012-03-16 12:06:29 +0530 |
| commit | 08f051df04675833ff819be306a204c0c9813e29 (patch) | |
| tree | c484f2f08c6656b6d2d00eb4692c950c720b5fa4 /mysql-test/suite | |
| parent | 0023147055f7222a1d454e71729b0013af68881c (diff) | |
| download | mariadb-git-08f051df04675833ff819be306a204c0c9813e29.tar.gz | |
Bug #11766634 59783: INNODB DATA GROWS UNEXPECTEDLY WHEN INSERTING, TRUNCATING, INSERTING THE
The test case must insert all the records using a single transaction. Otherwise the test
case takes more than 15 minutes and will time out in pb2 and mtr.
Diffstat (limited to 'mysql-test/suite')
| -rw-r--r-- | mysql-test/suite/innodb/t/innodb_bug11766634.test | 4 | ||||
| -rw-r--r-- | mysql-test/suite/innodb_plugin/t/innodb_bug11766634.test | 4 |
2 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb/t/innodb_bug11766634.test b/mysql-test/suite/innodb/t/innodb_bug11766634.test index a830955c78a..91be4da0338 100644 --- a/mysql-test/suite/innodb/t/innodb_bug11766634.test +++ b/mysql-test/suite/innodb/t/innodb_bug11766634.test @@ -18,11 +18,13 @@ let $recs = 36262; --disable_query_log let $c = $recs; +start transaction; while ($c) { insert into t1 values ('Hello World'); dec $c; } +commit work; --enable_query_log perl; @@ -35,11 +37,13 @@ create table t1 (f1 char(255)) engine innodb; --disable_query_log let $c = $recs; +start transaction; while ($c) { insert into t1 values ('Hello World'); dec $c; } +commit work; --enable_query_log perl; diff --git a/mysql-test/suite/innodb_plugin/t/innodb_bug11766634.test b/mysql-test/suite/innodb_plugin/t/innodb_bug11766634.test index 1780317675d..cd46deb64fb 100644 --- a/mysql-test/suite/innodb_plugin/t/innodb_bug11766634.test +++ b/mysql-test/suite/innodb_plugin/t/innodb_bug11766634.test @@ -18,11 +18,13 @@ let $recs = 36262; --disable_query_log let $c = $recs; +start transaction; while ($c) { insert into t1 values ('Hello World'); dec $c; } +commit work; --enable_query_log perl; @@ -35,11 +37,13 @@ create table t1 (f1 char(255)) engine innodb; --disable_query_log let $c = $recs; +start transaction; while ($c) { insert into t1 values ('Hello World'); dec $c; } +commit work; --enable_query_log perl; |