diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2014-07-08 14:03:19 -0400 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2014-07-08 14:03:19 -0400 |
commit | 6d36aee5b718524f718436d0973822bc2cb30bdd (patch) | |
tree | 894c28440dbcc9b143f33ca57f0fd54a80df74f3 /src/backend/utils/adt/ruleutils.c | |
parent | f1d7ff5bb8a7beef9afaa311c6f61a37ed4e000e (diff) |
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
Diffstat (limited to 'src/backend/utils/adt/ruleutils.c')
0 files changed, 0 insertions, 0 deletions