• B
    Incorrect Decorrelation results in wrong plan · 378426fe
    Bhuvnesh Chaudhary 提交于
    While attempting to decorrelate the subquery, we were
    incorrectly pulling up the join before calculating the window function
    of the results of the join. In cases where we have subqueries with
    window function and the subquery has outer references we should not
    attempt decorrelating it.
    
    There are further optimization which can be done in case of existential
    queries but this PR fixes the plan.
    Signed-off-by: NJemish Patel <jpatel@pivotal.io>
    378426fe
configure 522.0 KB