]> granicus.if.org Git - postgresql/commit
Fix WITH attached to a nested set operation (UNION/INTERSECT/EXCEPT).
authorTom Lane <tgl@sss.pgh.pa.us>
Tue, 31 Jul 2012 21:56:27 +0000 (17:56 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Tue, 31 Jul 2012 21:56:27 +0000 (17:56 -0400)
commit3786b9b4668743b99e837fe276e14be1f1bdfde9
tree6674d832fc55b76d4391d2b647b9e11b48ce134c
parent63aba79c7f1f06422b22e2b44fdcb563bbc3f7a5
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
code.

Back-patch to 8.4 where WITH support was added.
src/backend/parser/analyze.c
src/backend/parser/parse_cte.c
src/test/regress/expected/with.out
src/test/regress/sql/with.sql