• evgen@moonbone.local's avatar
    Bug#12122: The MERGE algorithm isn't applicable if the ORDER BY clause is · a2414463
    evgen@moonbone.local authored
    present.
    
    A view created with CREATE VIEW ... ORDER BY ... cannot be resolved with
    the MERGE algorithm, even when no other part of the CREATE VIEW statement
    would require the view to be resolved using the TEMPTABLE algorithm.
    
    The check for presence of the ORDER BY clause in the underlying select is 
    removed from the st_lex::can_be_merged() function.
    The ORDER BY list of the underlying select is appended to the ORDER BY list 
    a2414463
sql_lex.cc 57.6 KB