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

pgsql: Fix WITH attached to a nested set operation(UNION/INTERSECT/EXC

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Fix WITH attached to a nested set operation(UNION/INTERSECT/EXC
Date: 2012-07-31 21:57:12
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-committers
Fix WITH attached to a nested set operation (UNION/INTERSECT/EXCEPT).

Parse analysis neglected to cover the case of a WITH clause attached to an
intermediate-level set operation; it only handled WITH at the top level
or WITH attached to a leaf-level SELECT.  Per report from Adam Mackler.

In HEAD, I rearranged the order of SelectStmt's fields to put withClause
with the other fields that can appear on non-leaf SelectStmts.  In back
branches, leave it alone to avoid a possible ABI break for third-party

Back-patch to 8.4 where WITH support was added.



Modified Files
src/backend/parser/analyze.c       |   21 ++++++++------
src/backend/parser/parse_cte.c     |   15 ++++++++++-
src/test/regress/expected/with.out |   51 ++++++++++++++++++++++++++++++++++++
src/test/regress/sql/with.sql      |   35 ++++++++++++++++++++++++
4 files changed, 112 insertions(+), 10 deletions(-)

pgsql-committers by date

Next:From: Tom LaneDate: 2012-08-01 04:41:57
Subject: pgsql: Add documentation cross-reference for JSON functions.
Previous:From: Tom LaneDate: 2012-07-31 18:38:02
Subject: pgsql: Fix syslogger so that log_truncate_on_rotation works in thefirs

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