• Sergey Glukhov's avatar
    Bug#11756928 48916: SERVER INCORRECTLY PROCESSING HAVING CLAUSES WITH AN ORDER BY CLAUSE · 801b0ca2
    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.
    
    
    mysql-test/r/having.result:
      test case
    mysql-test/t/having.test:
      test case
    sql/sql_select.cc:
      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.
    801b0ca2
having.test 17.2 KB