mirror of
https://github.com/MariaDB/server.git
synced 2025-04-10 01:05:48 +02:00
896974fc3d
In the function test_if_cheaper_ordering we make a decision if using an index is better than using filesort for ordering. If we chose to do range access then in test_quick_select we should make sure that cost for table scan is set to DBL_MAX so that it is not picked.
10 lines
454 B
Text
10 lines
454 B
Text
set default_storage_engine='tokudb';
|
|
drop table if exists t2970;
|
|
Warnings:
|
|
Note 1051 Unknown table 'test.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;
|
|
id select_type table type possible_keys key key_len ref rows Extra
|
|
1 SIMPLE t2970 range a,a_2 a_2 5 NULL 2 Using where; Using index
|
|
drop table t2970;
|