• Monty's avatar
    Indexes where not used for sorting in sub queries · 6f8b60c1
    Monty authored
    This happens when the subquery marks some index fields as constant
    but the fields are still present in GROUP BY
    
    Fixed by checking if the 'constant field' is still part of GROUP BY before
    skipping it.
    
    Other things:
    - Added Item_field::contains() to make it easier to check if a field
      is equal to a Item_field or part of Item_equal.
    6f8b60c1
derived_split_innodb.test 6.38 KB