• Igor Babaev's avatar
    MDEV-25565 Crash on 2-nd execution of SP/PS for query calculating window functions · 4c387945
    Igor Babaev authored
               from view
    
    A crash of the server happened when executing a stored procedure whose the
    only query calculated window functions over a mergeable view specified
    as a select from non-mergeable view. The crash could be reproduced if
    the window specifications of the window functions were identical and both
    contained PARTITION lists and ORDER BY lists. A crash also happened on
    the second execution of the prepared statement created for such query.
    If to use derived tables or CTE instead of views the problem still
    manifests itself crashing the server.
    
    When optimizing the window specifications of a window function the
    server can substitute the partition lists and the order lists for
    the corresponding lists from another window specification in the case
    when the lists are identical. This substitution is not permanent and should
    be rolled back before the second execution. It was not done and this
    ultimately led to a crash when resolving the column names at the second
    execution of SP/PS.
    4c387945
sql_window.cc 84 KB