diff options
| author | Guilhem Bichot <guilhem@mysql.com> | 2009-08-25 17:53:43 +0200 |
|---|---|---|
| committer | Guilhem Bichot <guilhem@mysql.com> | 2009-08-25 17:53:43 +0200 |
| commit | 24ebb184ca3f9a472d1244edd2170e7ba2babb1b (patch) | |
| tree | 4dabe801fcdcc80e35a7107e1a622c74c1b9ff52 /mysql-test/t/index_merge_innodb.test | |
| parent | c3b2933b3a6272dbfe054ba7a062d63c0f107107 (diff) | |
| download | mariadb-git-24ebb184ca3f9a472d1244edd2170e7ba2babb1b.tar.gz | |
fix for Bug#46897 'Test "index_merge_innodb" fails (mostly)':
that was already analyzed by Oracle: EXPLAIN can return 3 or 4 in "rows"; using replace_column to work around this.
mysql-test/include/index_merge2.inc:
replace "rows" column of some EXPLAINs by "#", if told so
mysql-test/r/index_merge_innodb.result:
result update
mysql-test/t/index_merge_innodb.test:
tell index_merge2.inc to accept random "rows" values in some EXPLAINs; we don't do this in index_merge_myisam.test
which has no randomness here.
Diffstat (limited to 'mysql-test/t/index_merge_innodb.test')
| -rw-r--r-- | mysql-test/t/index_merge_innodb.test | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/t/index_merge_innodb.test b/mysql-test/t/index_merge_innodb.test index a3bda0ad00c..04516f45bfe 100644 --- a/mysql-test/t/index_merge_innodb.test +++ b/mysql-test/t/index_merge_innodb.test @@ -12,6 +12,12 @@ --source include/have_innodb.inc let $engine_type= InnoDB; +# According to Oracle: "InnoDB's estimate for the index cardinality +# depends on a pseudo random number generator (it picks up random +# pages to sample). After an optimization that was made in r2625 two +# EXPLAINs started returning a different number of rows (3 instead of +# 4)", so: +let $index_merge_random_rows_in_EXPLAIN = 1; # InnoDB does not support Merge tables (affects include/index_merge1.inc) let $merge_table_support= 0; |