• Igor Babaev's avatar
    Fixed LP bug #917990. · 746dbbe5
    Igor Babaev authored
    If the expression for a derived table of a query contained a LIMIT
    clause the estimate of the number of rows in this derived table
    returned by the EXPLAIN command could be badly off since the
    optimizer ignored the limit number from the LIMIT clause when
    getting the estimate. 
    The call of the method SELECT_LEX_UNIT->set_limit added in the code
    of mysql_derived_optimize() will be needed also in maria-5.5 where
    parameters in the LIMIT clause are supported. 
    746dbbe5
sql_select.cc 706 KB