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.
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 Lane||Date: 2012-08-01 04:41:57|
|Subject: pgsql: Add documentation cross-reference for JSON functions.|
|Previous:||From: Tom Lane||Date: 2012-07-31 18:38:02|
|Subject: pgsql: Fix syslogger so that log_truncate_on_rotation works in thefirs|