• Evgeny Potemkin's avatar
    Bug#38195: Incorrect handling of aggregate functions when loose index scan is · dcf82665
    Evgeny Potemkin authored
    used causes server crash.
          
    When the loose index scan access method is used values of aggregated functions
    are precomputed by it. Aggregation of such functions shouldn't be performed
    in this case and functions should be treated as normal ones.
    The create_tmp_table function wasn't taking this into account and this led to
    a crash if a query has MIN/MAX aggregate functions and employs temporary table
    and loose index scan.
    Now the JOIN::exec and the create_tmp_table functions treat MIN/MAX aggregate
    functions as normal ones when the loose index scan is used.
    
    
    mysql-test/r/group_min_max.result:
      Added a test case for the bug#38195.
    mysql-test/t/group_min_max.test:
      Added a test case for the bug#38195.
    sql/sql_select.cc:
      Bug#38195: Incorrect handling of aggregate functions when loose index scan is
      used causes server crash.
      The JOIN::exec and the create_tmp_table functions treat MIN/MAX aggregate
      functions as normal ones when the loose index scan is used.
    dcf82665
group_min_max.test 47.2 KB