• unknown's avatar
    Fixed bug lp:900375 · 6404504d
    unknown authored
    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.
    6404504d
group_min_max.test 52.4 KB