diff options
author | Michael Widenius <monty@askmonty.org> | 2009-10-28 09:52:34 +0200 |
---|---|---|
committer | Michael Widenius <monty@askmonty.org> | 2009-10-28 09:52:34 +0200 |
commit | 358327618d5a71138be6ca27a4c8472723b67c45 (patch) | |
tree | c3e3a8863d7b69f2710398758721ffd6e75a02ca /mysql-test/t/derived.test | |
parent | f3e3fe866bfaa14986db5bb6a10e5c130af69137 (diff) | |
download | mariadb-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/derived.test')
-rw-r--r-- | mysql-test/t/derived.test | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/mysql-test/t/derived.test b/mysql-test/t/derived.test index d28c19bbd18..a1456246e94 100644 --- a/mysql-test/t/derived.test +++ b/mysql-test/t/derived.test @@ -45,14 +45,16 @@ select * from (select * from t1 where t1.a=(select t2.a from t2 where t2.a=t1.a) explain select * from (select t1.*, t2.a as t2a from t1,t2 where t1.a=t2.a) t1; drop table t1, t2; create table t1(a int not null, t char(8), index(a)); -disable_query_log; +--disable_query_log +begin; let $1 = 10000; while ($1) { eval insert into t1 values ($1,'$1'); dec $1; } -enable_query_log; +commit; +--enable_query_log SELECT * FROM (SELECT * FROM t1) as b ORDER BY a ASC LIMIT 0,20; explain select count(*) from t1 as tt1, (select * from t1) as tt2; drop table t1; |