~maria-captains/maria/5.3

Viewing all changes in revision 3427.

  • Committer: Igor Babaev
  • Date: 2012-02-19 00:06:38 UTC
  • Revision ID: igor@askmonty.org-20120219000638-qfo665vv4w9ubhds
Fixed LP bug #934342.
An outer join query with a semi-join subquery could return a wrong result
if the optimizer chose to materialize the subquery.
It happened because when substituting for the best field into a ref item
used to build access keys not all COND_EQUAL objects that could be employed
at substitution were checked.

Also refined some code in the function check_join_cache_usage to make it
safer. 

expand all expand all

Show diffs side-by-side

added added

removed removed

Lines of Context: