diff options
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb_bugs/t/2970.test')
| -rw-r--r-- | storage/tokudb/mysql-test/tokudb_bugs/t/2970.test | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/storage/tokudb/mysql-test/tokudb_bugs/t/2970.test b/storage/tokudb/mysql-test/tokudb_bugs/t/2970.test new file mode 100644 index 00000000000..6335bb74119 --- /dev/null +++ b/storage/tokudb/mysql-test/tokudb_bugs/t/2970.test @@ -0,0 +1,11 @@ +# test that the query planner chooses a covering index over a non-covering index with the same +# record cost + +drop table if exists t2970; +create table t2970 (a int, b int, c int, d int, key(a), key(a,b)); +insert into t2970 values (1,1,1,1),(1,2,3,4); +explain select a,count(b),max(b) from t2970 where a > 0 group by a order by a; +alter table t2970 engine=tokudb; +explain select a,count(b),max(b) from t2970 where a > 0 group by a order by a; +drop table t2970; + |