Skip site navigation (1) Skip section navigation (2)

pgsql: Fix some issues with LATERAL(SELECT UNION ALL SELECT).

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Fix some issues with LATERAL(SELECT UNION ALL SELECT).
Date: 2012-08-11 22:43:43
Message-ID: E1T0KPH-0008Bj-Bz@gemulon.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Fix some issues with LATERAL(SELECT UNION ALL SELECT).

The LATERAL marking has to be propagated down to the UNION leaf queries
when we pull them up.  Also, fix the formerly stubbed-off
set_append_rel_pathlist().  It does already have enough smarts to cope with
making a parameterized Append path at need; it just has to not assume that
there *must* be an unparameterized path.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/e76af54137c051cafcb1e39f68383a31d1d55ff6

Modified Files
--------------
src/backend/optimizer/path/allpaths.c     |   50 +++++++++++++++-------------
src/backend/optimizer/prep/prepjointree.c |   39 ++++++++++++++++++----
src/test/regress/expected/join.out        |   26 +++++++++++++++
src/test/regress/sql/join.sql             |    9 +++++
4 files changed, 94 insertions(+), 30 deletions(-)

pgsql-committers by date

Next:From: Tom LaneDate: 2012-08-14 14:55:27
Subject: pgsql: Update time zone data files to tzdata release 2012e.
Previous:From: Tom LaneDate: 2012-08-11 17:51:53
Subject: pgsql: Add link from COPY ref page to psql \copy.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group