• Sergey Glukhov's avatar
    Bug#11756928 48916: SERVER INCORRECTLY PROCESSING HAVING CLAUSES WITH AN ORDER BY CLAUSE · 76f37a02
    Sergey Glukhov authored
    Before sorting HAVING condition is split into two parts,
    first part is a table related condition and the rest of is
    HAVING part. Extraction of HAVING part does not take into account
    the fact that some of conditions might be non-const but
    have 'used_tables' == 0 (independent subqueries)
    and because of that these conditions are cut off by
    make_cond_for_table() function.
    The fix is to use (table_map) 0 instead of used_tables in
    third argument for make_cond_for_table() function.
    It allows to extract elements which belong to sorted
    table and in addition elements which are independend
    subqueries.
    76f37a02
having.result 16.3 KB