diff options
| author | Michael Widenius <monty@askmonty.org> | 2010-12-06 11:25:04 +0200 |
|---|---|---|
| committer | Michael Widenius <monty@askmonty.org> | 2010-12-06 11:25:04 +0200 |
| commit | ca94028a36110d0185992fff136aa1be5d196102 (patch) | |
| tree | 754e73b713e0aad5403fa4b8be314427f006c5fd /mysql-test/t/index_merge_innodb.test | |
| parent | 42746a44a276ec6d7ee5217722015b1009e19fd3 (diff) | |
| download | mariadb-git-ca94028a36110d0185992fff136aa1be5d196102.tar.gz | |
Fixed test case to be repeatable (after discussion with Igor)
Diffstat (limited to 'mysql-test/t/index_merge_innodb.test')
| -rw-r--r-- | mysql-test/t/index_merge_innodb.test | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/mysql-test/t/index_merge_innodb.test b/mysql-test/t/index_merge_innodb.test index e68f414e0bc..7c6ffaace4f 100644 --- a/mysql-test/t/index_merge_innodb.test +++ b/mysql-test/t/index_merge_innodb.test @@ -64,9 +64,11 @@ INSERT INTO t1 VALUES (1000000, 0, 0); SET SESSION sort_buffer_size = 1024*36; +# We have to use FORCE INDEX here as Innodb gives inconsistent estimates +# which causes different query plans. EXPLAIN SELECT COUNT(*) FROM - (SELECT * FROM t1 + (SELECT * FROM t1 FORCE INDEX(primary,idx) WHERE a BETWEEN 2 AND 7 OR pk=1000000) AS t; SELECT COUNT(*) FROM (SELECT * FROM t1 |