• Vicențiu Ciorbaru's avatar
    MDEV-12779 Oracle/DB2 Compatibility Implicit Ordering for ROW_NUMBER OVER · 1c6b982e
    Vicențiu Ciorbaru authored
    Users expect window functions to produce a certain ordering of rows in
    the final result set. Although the standard does not require this, we
    already have the filesort result done for when we computed the window
    function. If there is no ORDER BY attached to the query, just keep it
    till the SELECT is completely evaluated and use that to print the
    result.
    
    Update test cases as many did not take care to guarantee a stable
    result.
    1c6b982e
win_rank.test 1.41 KB