diff options
| author | Igor Babaev <igor@askmonty.org> | 2011-01-15 11:14:36 -0800 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2011-01-15 11:14:36 -0800 |
| commit | 84a0c9b2a245a166b87296b0aa9218730be89c21 (patch) | |
| tree | 205a92844a464232a6992e38ef00b6e2780801db /mysql-test/r/myisam_mrr.result | |
| parent | cb4fa7f401267bf887066100726c53f10b712e6d (diff) | |
| download | mariadb-git-84a0c9b2a245a166b87296b0aa9218730be89c21.tar.gz | |
Fixed LP bug #698882.
Made sure that the optimal fields are used by TABLE_REF objects
when building index access keys to joined tables.
Fixed a bug in the template function that sorts the elements of
a list using the bubble sort algorithm. The bug caused poor
performance of the function. Also added an optimization that
skips comparison with the most heavy elements that has been
already properly placed in the list.
Made the comparison of the fields belonging to the same Item_equal
more granular: fields belonging to the same table are also ordered
according to some rules.
Diffstat (limited to 'mysql-test/r/myisam_mrr.result')
| -rw-r--r-- | mysql-test/r/myisam_mrr.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/myisam_mrr.result b/mysql-test/r/myisam_mrr.result index e1eeb4e1a62..d0f0d12c28e 100644 --- a/mysql-test/r/myisam_mrr.result +++ b/mysql-test/r/myisam_mrr.result @@ -504,7 +504,7 @@ table3.col_varchar_key = table2.col_varchar_nokey AND table3.pk<>0; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE table2 ALL col_varchar_key NULL NULL NULL 20 Using where -1 SIMPLE table3 ref PRIMARY,col_varchar_key col_varchar_key 3 test.table2.col_varchar_key 3 Using index condition(BKA); Using where; Using join buffer (flat, BKA join) +1 SIMPLE table3 ref PRIMARY,col_varchar_key col_varchar_key 3 test.table2.col_varchar_key 3 Using where; Using join buffer (flat, BKA join) set join_cache_level= @save_join_cache_level; set join_buffer_size= @save_join_buffer_size; drop table t1; |