diff options
| author | Igor Babaev <igor@askmonty.org> | 2013-08-23 07:25:45 -0700 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2013-08-23 07:25:45 -0700 |
| commit | 540eeebbb053da2bec21567da2519cd40cedaf86 (patch) | |
| tree | 9a2e7ca694e6e86fdaae825150658f509970dcbc /mysql-test/r/join.result | |
| parent | 2ead54d0fba84927a9a603b8f431039cc171a561 (diff) | |
| download | mariadb-git-540eeebbb053da2bec21567da2519cd40cedaf86.tar.gz | |
Fixed bug mdev-4420.
The code of JOIN::optimize that performed substitutions for the best equal
field in all ref items did not take into account that a multiple equality
could contain the result of the single-value subquery if the subquery is
inexpensive. This code was corrected.
Also made necessary corresponding corrections in the code of make_join_select().
Diffstat (limited to 'mysql-test/r/join.result')
| -rw-r--r-- | mysql-test/r/join.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/join.result b/mysql-test/r/join.result index ae224fe0220..a1796d7fa3b 100644 --- a/mysql-test/r/join.result +++ b/mysql-test/r/join.result @@ -1460,7 +1460,7 @@ id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE D system PRIMARY NULL NULL NULL 1 1 SIMPLE DSAR system NULL NULL NULL NULL 1 1 SIMPLE DT range t_id t_id 2 NULL 2 Using where -1 SIMPLE DSA ref PRIMARY PRIMARY 8 const,test.DT.t_id,test.D.birthday 1 Using index +1 SIMPLE DSA ref PRIMARY PRIMARY 8 const,test.DT.t_id,func 1 Using index SELECT * FROM t5 DU, t1 D, t4 DT, t2 DSA, t3 DSAR WHERE DU.dog_id=D.dog_id AND D.dog_id=DT.dog_id AND D.birthday=DT.birthday AND DT.t_id=DSA.t_id AND DT.birthday=DSA.birthday AND DSA.dog_id=DSAR.dog_id; |