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 | 12 |
1 files changed, 12 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..e6b544407e8 --- /dev/null +++ b/storage/tokudb/mysql-test/tokudb_bugs/t/2970.test @@ -0,0 +1,12 @@ +source include/have_tokudb.inc; +set default_storage_engine='tokudb'; + +# 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; +drop table t2970; + |