]> granicus.if.org Git - postgresql/commit
Fix "cannot handle unplanned sub-select" error that can occur when a
authorTom Lane <tgl@sss.pgh.pa.us>
Thu, 8 Jul 2010 00:14:33 +0000 (00:14 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Thu, 8 Jul 2010 00:14:33 +0000 (00:14 +0000)
commit8bed5e2726eac9950e149127553a426e2924df80
tree6e90cb5edcbdcf30999c2167a294dbff4fd30ea4
parentc778f898188e931bfefda02c97c37864858f14de
Fix "cannot handle unplanned sub-select" error that can occur when a
sub-select contains a join alias reference that expands into an expression
containing another sub-select.  Per yesterday's report from Merlin Moncure
and subsequent off-list investigation.

Back-patch to 7.4.  Older versions didn't attempt to flatten sub-selects in
ways that would trigger this problem.
src/backend/optimizer/util/var.c
src/test/regress/expected/subselect.out
src/test/regress/sql/subselect.sql