diff options
author | Sergey Petrunya <psergey@askmonty.org> | 2011-06-30 20:49:11 +0400 |
---|---|---|
committer | Sergey Petrunya <psergey@askmonty.org> | 2011-06-30 20:49:11 +0400 |
commit | e2eafc3bd1b4af3dabc39e83bdb1e0a71f0d5a53 (patch) | |
tree | 3a201c205a21b93043bd433d14b3e940e7182858 /mysql-test/r/subselect_sj_nonmerged.result | |
parent | f30b4a0ded5ce58780e5ec176c55426cf84efe8e (diff) | |
download | mariadb-git-e2eafc3bd1b4af3dabc39e83bdb1e0a71f0d5a53.tar.gz |
Fix buildbot failures:
- JOIN::prepare would have set JOIN::table_count to incorrect value (bad merge of MWL 106)
- optimize_keyuse() would use table-bit as table number
(the change in optimize_keyuse is also the reason for query plan changes. Not
expected to have much effect because only handles cases of no index statistics)
- st_select_lex::register_dependency_item() ignored the fact that some of the
selects on the dependency paths could have been merged to their parents (because they
were mergeable VIEWs)
- Undo the incorrect fix in Item_subselect::recalc_used_tables(): do not call
fix_after_pullout() for Item_subselect::Ref_to_outside members.
Diffstat (limited to 'mysql-test/r/subselect_sj_nonmerged.result')
-rw-r--r-- | mysql-test/r/subselect_sj_nonmerged.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/subselect_sj_nonmerged.result b/mysql-test/r/subselect_sj_nonmerged.result index 9304c26ece6..e0d1140da74 100644 --- a/mysql-test/r/subselect_sj_nonmerged.result +++ b/mysql-test/r/subselect_sj_nonmerged.result @@ -75,7 +75,7 @@ t4.b in (select max(t2.a) from t1, t2 group by t2.b); id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY <subquery2> ALL distinct_key NULL NULL NULL 5 Using where 1 PRIMARY <subquery3> ALL distinct_key NULL NULL NULL 5 Using where; Using join buffer (flat, BNL join) -1 PRIMARY t4 ref a a 10 <subquery2>.max(t2.a),<subquery3>.max(t2.a) 11 +1 PRIMARY t4 ref a a 10 <subquery2>.max(t2.a),<subquery3>.max(t2.a) 12 3 SUBQUERY t2 ALL NULL NULL NULL NULL 5 Using temporary 3 SUBQUERY t1 ALL NULL NULL NULL NULL 10 Using join buffer (flat, BNL join) 2 SUBQUERY t2 ALL NULL NULL NULL NULL 5 Using temporary |