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/select_found.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/select_found.test')
| -rw-r--r-- | mysql-test/t/select_found.test | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/mysql-test/t/select_found.test b/mysql-test/t/select_found.test index e4bc54a5538..e043ec4d143 100644 --- a/mysql-test/t/select_found.test +++ b/mysql-test/t/select_found.test @@ -54,7 +54,8 @@ CREATE TABLE t2 ( UNIQUE KEY e_n (email,name) ); -disable_query_log; +--disable_query_log +begin; let $1=200; let $2=0; while ($1) @@ -63,7 +64,8 @@ while ($1) eval INSERT INTO t2 VALUES ($2,'name$2','email$2'); dec $1; } -enable_query_log; +commit; +--enable_query_log EXPLAIN SELECT SQL_CALC_FOUND_ROWS DISTINCT email FROM t2 LEFT JOIN t1 ON kid = t2.id WHERE t1.id IS NULL LIMIT 10; SELECT SQL_CALC_FOUND_ROWS DISTINCT email FROM t2 LEFT JOIN t1 ON kid = t2.id WHERE t1.id IS NULL LIMIT 10; |