~maria-captains/maria/5.2

Viewing all changes in revision 3069.

  • Committer: timour at askmonty
  • Date: 2011-12-12 10:36:46 UTC
  • Revision ID: timour@askmonty.org-20111212103646-f2qsupbk9yydkz6h
Fixed bug lp:900375

The range optimizer incorrectly chose a loose scan for group by
when there is a correlated WHERE condition. This range access
method cannot be executed for correlated conditions also with the
"range checked for each record" because generally the range access
method can change for each outer record. Loose scan destructively
changes the query plan and removes the GROUP operation, which will
result in wrong query plans if another range access is chosen
dynamically.

expand all expand all

Show diffs side-by-side

added added

removed removed

Lines of Context: