summaryrefslogtreecommitdiff
path: root/mysql-test/r/subselect_sj_nonmerged.result
diff options
context:
space:
mode:
authorSergey Petrunya <psergey@askmonty.org>2011-06-30 20:49:11 +0400
committerSergey Petrunya <psergey@askmonty.org>2011-06-30 20:49:11 +0400
commite2eafc3bd1b4af3dabc39e83bdb1e0a71f0d5a53 (patch)
tree3a201c205a21b93043bd433d14b3e940e7182858 /mysql-test/r/subselect_sj_nonmerged.result
parentf30b4a0ded5ce58780e5ec176c55426cf84efe8e (diff)
downloadmariadb-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.result2
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