diff options
author | Monty <monty@mariadb.org> | 2019-04-01 19:42:26 +0300 |
---|---|---|
committer | Monty <monty@mariadb.org> | 2019-04-01 19:47:24 +0300 |
commit | 884004502134d881af0bcb59f97a838784ab5bbe (patch) | |
tree | 499c76eb6ad251e1f62d464f146b614dc4ae393e /mysql-test/main/index_merge_innodb.test | |
parent | 48810a00144481b7fec4ce8e23024e9f899626a7 (diff) | |
download | mariadb-git-884004502134d881af0bcb59f97a838784ab5bbe.tar.gz |
index_merge_innodb did sometimes give wrong results
Fixed by adding more rows to a table
Other things:
- Speed up index_merge tests 20% by adding begin/commit around loops that
generated rows.
Diffstat (limited to 'mysql-test/main/index_merge_innodb.test')
-rw-r--r-- | mysql-test/main/index_merge_innodb.test | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/main/index_merge_innodb.test b/mysql-test/main/index_merge_innodb.test index 2581cccced0..7f9d6ac6eb1 100644 --- a/mysql-test/main/index_merge_innodb.test +++ b/mysql-test/main/index_merge_innodb.test @@ -47,6 +47,7 @@ CREATE TABLE t1 ( INDEX idx(a)) ENGINE=INNODB; +begin; INSERT INTO t1(a,b) VALUES (11, 1100), (2, 200), (1, 100), (14, 1400), (5, 500), (3, 300), (17, 1700), (4, 400), (12, 1200), (8, 800), @@ -66,6 +67,7 @@ INSERT INTO t1(a,b) SELECT a,b FROM t1; INSERT INTO t1(a,b) SELECT a,b FROM t1; INSERT INTO t1(a,b) SELECT a,b FROM t1; INSERT INTO t1 VALUES (1000000, 0, 0); +commit; SET SESSION sort_buffer_size = 1024*36; set @tmp_optimizer_switch=@@optimizer_switch; |