]> granicus.if.org Git - postgresql/commit
Don't assume a subquery's output is unique if there's a SRF in its tlist.
authorTom Lane <tgl@sss.pgh.pa.us>
Tue, 8 Jul 2014 18:03:16 +0000 (14:03 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Tue, 8 Jul 2014 18:03:45 +0000 (14:03 -0400)
commitac45aa1dde2dd690682bf74f7535ba6d1a87bff8
tree1466ea6c449c106b1169cae927c5318faa456406
parent443dd97001c4cdb78ec388fffd5780ddccb3218f
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
src/backend/optimizer/util/pathnode.c
src/test/regress/expected/subselect.out
src/test/regress/sql/subselect.sql