| 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: | [email protected] |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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
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(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2012-08-14 14:55:27 | pgsql: Update time zone data files to tzdata release 2012e. |
| Previous Message | Tom Lane | 2012-08-11 17:51:53 | pgsql: Add link from COPY ref page to psql \copy. |