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/subselect_sj.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/subselect_sj.result')
| -rw-r--r-- | mysql-test/r/subselect_sj.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/subselect_sj.result b/mysql-test/r/subselect_sj.result index 3fc91b452a5..2d229db9ec5 100644 --- a/mysql-test/r/subselect_sj.result +++ b/mysql-test/r/subselect_sj.result @@ -2485,7 +2485,7 @@ id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t3 system NULL NULL NULL NULL 1 1 PRIMARY <subquery2> ALL distinct_key NULL NULL NULL 1 1 PRIMARY t1 ref a a 5 const 1 Using index -1 PRIMARY t2 ref a a 5 test.t3.b 1 Using index +1 PRIMARY t2 ref a a 5 func 1 Using index 2 MATERIALIZED t4 ALL NULL NULL NULL NULL 0 SELECT * FROM t1, t2 WHERE t1.a = t2.a AND t2.a IN (SELECT b FROM t3 STRAIGHT_JOIN t4); |