• Tom Lane's avatar
    Don't assume a subquery's output is unique if there's a SRF in its tlist. · 9e2f2d7a
    Tom Lane authored
    While the x output of "select x from t group by x" can be presumed unique,
    this does not hold for "select x, generate_series(1,10) from t group by x",
    because we may expand the set-returning function after the grouping step.
    (Perhaps that should be re-thought; but considering all the other oddities
    involved with SRFs in targetlists, it seems unlikely we'll change it.)
    Put a check in query_is_distinct_for() so it's not fooled by such cases.
    
    Back-patch to all supported branches.
    
    David Rowley
    9e2f2d7a
pathnode.c 63.6 KB