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/subselect_sj2.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/subselect_sj2.result')
| -rw-r--r-- | mysql-test/r/subselect_sj2.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/subselect_sj2.result b/mysql-test/r/subselect_sj2.result index 9a7b6748d29..546ab1c6fdd 100644 --- a/mysql-test/r/subselect_sj2.result +++ b/mysql-test/r/subselect_sj2.result @@ -313,7 +313,7 @@ t2.Population > 100000); id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t1 range Population,Country Population 4 NULL 1 Using index condition; Using MRR 1 PRIMARY t3 eq_ref PRIMARY,Percentage PRIMARY 33 test.t1.Country,const 1 Using index condition; Using where -1 PRIMARY t2 eq_ref PRIMARY,Population PRIMARY 3 test.t3.Country 1 Using index condition; Using where +1 PRIMARY t2 eq_ref PRIMARY,Population PRIMARY 3 test.t1.Country 1 Using where DROP TABLE t1,t2,t3; CREATE TABLE t1 ( Code char(3) NOT NULL DEFAULT '', |