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/multi_update2.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/multi_update2.test')
| -rw-r--r-- | mysql-test/t/multi_update2.test | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/mysql-test/t/multi_update2.test b/mysql-test/t/multi_update2.test index a04518f4964..9c5078efb6f 100644 --- a/mysql-test/t/multi_update2.test +++ b/mysql-test/t/multi_update2.test @@ -48,13 +48,14 @@ CREATE TABLE t1 ( a INT NOT NULL, b INT NOT NULL) ; INSERT INTO t1 VALUES (1,1),(2,2),(3,3),(4,4); let $1=19; set @d=4; +begin; while ($1) { eval INSERT INTO t1 SELECT a+@d,b+@d FROM t1; eval SET @d=@d*2; dec $1; } - +commit; --enable_query_log ALTER TABLE t1 ADD INDEX i1(a); DELETE FROM t1 WHERE a > 2000000; |