diff options
| author | Varun Gupta <varun.gupta@mariadb.com> | 2019-09-21 12:14:05 +0530 |
|---|---|---|
| committer | Varun Gupta <varun.gupta@mariadb.com> | 2019-09-21 12:14:05 +0530 |
| commit | 896974fc3d721aabe1afbf637a566cab856a731d (patch) | |
| tree | 7c2b25ebe76c5397beda181ccbbe4ecdcf9c4f35 /mysql-test/suite/maria | |
| parent | 7a4019a1c7bcefceef9b6c2624c89088db3991cc (diff) | |
| download | mariadb-git-896974fc3d721aabe1afbf637a566cab856a731d.tar.gz | |
MDEV-18094: Query with order by limit picking index scan over filesort
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.
Diffstat (limited to 'mysql-test/suite/maria')
| -rw-r--r-- | mysql-test/suite/maria/icp.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/suite/maria/icp.result b/mysql-test/suite/maria/icp.result index e37877c8527..49eaed9dd6d 100644 --- a/mysql-test/suite/maria/icp.result +++ b/mysql-test/suite/maria/icp.result @@ -167,7 +167,7 @@ WHERE ts BETWEEN '0000-00-00' AND '2010-00-01 00:00:00' ORDER BY ts DESC LIMIT 2; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 index PRIMARY PRIMARY 4 NULL 2 Using where +1 SIMPLE t1 range PRIMARY PRIMARY 4 NULL 4 Using where DROP TABLE t1; # |