diff options
| author | Igor Babaev <igor@askmonty.org> | 2011-12-06 02:46:42 -0800 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2011-12-06 02:46:42 -0800 |
| commit | b4c9fa321dd1fc08227333439695ec4314fb34c8 (patch) | |
| tree | 87d9af5b83c70fa3b246b2bfb520b4c3ff6e13db /mysql-test/r/derived.result | |
| parent | 62e4c73ebb633880785dee44688153477e2c5454 (diff) | |
| download | mariadb-git-b4c9fa321dd1fc08227333439695ec4314fb34c8.tar.gz | |
Fixed LP bug #899509.
The optimizer must ignore any possible hash join key when looking for the
query execution plan with join_cache_level set to 0.
Diffstat (limited to 'mysql-test/r/derived.result')
| -rw-r--r-- | mysql-test/r/derived.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/derived.result b/mysql-test/r/derived.result index f34810ada6a..a9247ff41bf 100644 --- a/mysql-test/r/derived.result +++ b/mysql-test/r/derived.result @@ -192,13 +192,13 @@ pla_id test explain SELECT STRAIGHT_JOIN d.pla_id, m2.mat_id FROM t1 m2 INNER JOIN (SELECT mp.pla_id, MIN(m1.matintnum) AS matintnum FROM t2 mp INNER JOIN t1 m1 ON mp.mat_id=m1.mat_id GROUP BY mp.pla_id) d ON d.matintnum=m2.matintnum; id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY m2 ALL NULL NULL NULL NULL 9 -1 PRIMARY <derived2> ALL NULL NULL NULL NULL 9 Using where +1 PRIMARY <derived2> ALL NULL NULL NULL NULL 9 Using where; Using join buffer (flat, BNL join) 2 DERIVED mp ALL NULL NULL NULL NULL 9 Using temporary; Using filesort 2 DERIVED m1 eq_ref PRIMARY PRIMARY 3 test.mp.mat_id 1 explain SELECT STRAIGHT_JOIN d.pla_id, m2.test FROM t1 m2 INNER JOIN (SELECT mp.pla_id, MIN(m1.matintnum) AS matintnum FROM t2 mp INNER JOIN t1 m1 ON mp.mat_id=m1.mat_id GROUP BY mp.pla_id) d ON d.matintnum=m2.matintnum; id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY m2 ALL NULL NULL NULL NULL 9 -1 PRIMARY <derived2> ALL NULL NULL NULL NULL 9 Using where +1 PRIMARY <derived2> ALL NULL NULL NULL NULL 9 Using where; Using join buffer (flat, BNL join) 2 DERIVED mp ALL NULL NULL NULL NULL 9 Using temporary; Using filesort 2 DERIVED m1 eq_ref PRIMARY PRIMARY 3 test.mp.mat_id 1 drop table t1,t2; |