Don't assume a subquery's output is unique if there's a SRF in its tlist.

Tom Lane <tgl@sss.pgh.pa.us>

Commit: fa21a760b2e16b68196da685f29033304b41d4bc
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2014-07-08T18:03:26Z
Releases: 9.1.14
Don't assume a subquery's output is unique if there's a SRF in its tlist.

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

Files