git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit

Fix WITH attached to a nested set operation (UNION/INTERSECT/EXCEPT).

author Tom Lane <tgl@sss.pgh.pa.us>

2012年7月31日 21:56:21 +0000 (17:56 -0400)

committer Tom Lane <tgl@sss.pgh.pa.us>

2012年7月31日 21:56:21 +0000 (17:56 -0400)

commit f6ce81f55a3c6932d5f88bc89374f404688f054e

tree bc5fc3caa565d7c9c2f72eb8656246be3ef21c07 tree

parent b76356ac22d8322e6074981b4d34ee19cd0dbc8a commit | diff

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/nodes/copyfuncs.c diff | blob | blame | history

src/backend/nodes/equalfuncs.c diff | blob | blame | history

src/backend/nodes/nodeFuncs.c diff | blob | blame | history

src/backend/nodes/outfuncs.c diff | blob | blame | history

src/backend/parser/analyze.c diff | blob | blame | history

src/backend/parser/parse_cte.c diff | blob | blame | history

src/backend/parser/parse_type.c diff | blob | blame | history

src/include/nodes/parsenodes.h diff | blob | blame | history

src/test/regress/expected/with.out diff | blob | blame | history

src/test/regress/sql/with.sql diff | blob | blame | history

This is the main PostgreSQL git repository.

RSS Atom