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/join_nested.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/join_nested.result')
| -rw-r--r-- | mysql-test/r/join_nested.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/join_nested.result b/mysql-test/r/join_nested.result index 373472f73ce..9d60059ac28 100644 --- a/mysql-test/r/join_nested.result +++ b/mysql-test/r/join_nested.result @@ -1733,7 +1733,7 @@ id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 eq_ref PRIMARY PRIMARY 4 test.t2.package_id 1 1 SIMPLE t4 eq_ref PRIMARY,id PRIMARY 2 test.t1.carrier 1 Using where 1 SIMPLE t5 ref carrier_id carrier_id 5 test.t4.id 22 Using index -1 SIMPLE t3 ref package_id package_id 5 test.t1.id 1 Using where; Using index +1 SIMPLE t3 ref package_id package_id 5 test.t2.package_id 1 Using index SELECT COUNT(*) FROM ((t2 JOIN t1 ON t2.package_id = t1.id) JOIN t3 ON t3.package_id = t1.id) |