pgsql: Don't assume a subquery's output is unique if there's a SRF in i - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Don't assume a subquery's output is unique if there's a SRF in i
Date
Msg-id E1X4ZkM-0002sr-Dr@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
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

Branch
------
REL9_3_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/6d36aee5b718524f718436d0973822bc2cb30bdd

Modified Files
--------------
src/backend/optimizer/util/pathnode.c   |   11 +++++++++++
src/test/regress/expected/subselect.out |   33 +++++++++++++++++++++++++++++++
src/test/regress/sql/subselect.sql      |    9 +++++++++
3 files changed, 53 insertions(+)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Don't assume a subquery's output is unique if there's a SRF in i
Next
From: Peter Eisentraut
Date:
Subject: pgsql: doc: Link text to table by id