summaryrefslogtreecommitdiff
path: root/mysql-test/t/insert.test
diff options
context:
space:
mode:
authorMichael Widenius <monty@askmonty.org>2009-10-28 09:52:34 +0200
committerMichael Widenius <monty@askmonty.org>2009-10-28 09:52:34 +0200
commit358327618d5a71138be6ca27a4c8472723b67c45 (patch)
treec3e3a8863d7b69f2710398758721ffd6e75a02ca /mysql-test/t/insert.test
parentf3e3fe866bfaa14986db5bb6a10e5c130af69137 (diff)
downloadmariadb-git-358327618d5a71138be6ca27a4c8472723b67c45.tar.gz
Speed up of test suite:
- Added --disable_query_log ; begin ; .... commit; --enable_query_log around all while loops that does insert
Diffstat (limited to 'mysql-test/t/insert.test')
-rw-r--r--mysql-test/t/insert.test7
1 files changed, 5 insertions, 2 deletions
diff --git a/mysql-test/t/insert.test b/mysql-test/t/insert.test
index 155ae6937ef..5ec0aefe021 100644
--- a/mysql-test/t/insert.test
+++ b/mysql-test/t/insert.test
@@ -151,7 +151,8 @@ drop table t1;
create table t1(id1 int not null auto_increment primary key, t char(12));
create table t2(id2 int not null, t char(12));
create table t3(id3 int not null, t char(12), index(id3));
-disable_query_log;
+--disable_query_log
+begin;
let $1 = 100;
while ($1)
{
@@ -170,7 +171,9 @@ while ($1)
}
dec $1;
}
-enable_query_log;
+commit;
+--enable_query_log
+
select count(*) from t2;
insert into t2 select t1.* from t1, t2 t, t3 where t1.id1 = t.id2 and t.id2 = t3.id3;
select count(*) from t2;