• Varun Gupta's avatar
    MDEV-21318: Wrong results with window functions and implicit grouping · 891609b5
    Varun Gupta authored
    The issue here is for degenerate joins we should execute the window
    function but it is not getting executed in all the cases.
    
    To get the window function values window function needs to be executed
    always. This currently does not happen in few cases
    where the join would return 0 or 1 row like
      1) IMPOSSIBLE WHERE
      2) MIN/MAX optimization
      3) EMPTY CONST TABLE
    
    The fix is to make sure that window functions get executed
    and the temporary table is setup for the execution of window functions
    891609b5
sql_select.cc 874 KB