diff options
| author | unknown <sergefp@mysql.com> | 2004-06-22 04:47:28 +0400 |
|---|---|---|
| committer | unknown <sergefp@mysql.com> | 2004-06-22 04:47:28 +0400 |
| commit | cfecdcd36a2dbaba863c178d1170782c1f3e9fbc (patch) | |
| tree | b87bd41117f45565a9107145e291d6bd1d0558c6 /mysql-test/r/heap_btree.result | |
| parent | c4cd310f7f9088572c68f6de139a4c63baf1c3bf (diff) | |
| download | mariadb-git-cfecdcd36a2dbaba863c178d1170782c1f3e9fbc.tar.gz | |
Range optimizer fix:
If cost(full_scan_on_shortest_covering_index) < cost(best_range_scan) < cost(full_table_scan)
use full_scan_on_shortest_covering_index
(before this fix best_range_scan was used)
Diffstat (limited to 'mysql-test/r/heap_btree.result')
| -rw-r--r-- | mysql-test/r/heap_btree.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/heap_btree.result b/mysql-test/r/heap_btree.result index 5c60c97d674..03625d19d04 100644 --- a/mysql-test/r/heap_btree.result +++ b/mysql-test/r/heap_btree.result @@ -66,7 +66,7 @@ a alter table t1 engine=myisam; explain select * from t1 where a in (869751,736494,226312,802616); id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range uniq_id uniq_id 4 NULL 4 Using where; Using index +1 SIMPLE t1 index uniq_id uniq_id 4 NULL 4 Using where; Using index drop table t1; create table t1 (x int not null, y int not null, key x using BTREE (x,y), unique y using BTREE (y)) engine=heap; |