pgsql: Avoid unhelpful internal error for incorrect recursive-WITH quer - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Avoid unhelpful internal error for incorrect recursive-WITH quer
Date
Msg-id E1sT3MK-001eqB-F6@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Avoid unhelpful internal error for incorrect recursive-WITH queries.

checkWellFormedRecursion would issue "missing recursive reference"
if a WITH RECURSIVE query contained a single self-reference but
that self-reference was inside a top-level WITH, ORDER BY, LIMIT,
etc, rather than inside the second arm of the UNION as expected.
We already intended to throw more-on-point errors for such cases,
but those error checks must be done before examining the UNION arm
in order to have the desired results.  So this patch need only
move some code (and improve the comments).

Per bug #18536 from Alexander Lakhin.  Back-patch to all supported
branches.

Discussion: https://postgr.es/m/18536-0a342ec07901203e@postgresql.org

Branch
------
REL_15_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/e7f9f44e3bd95404f4221fab29cd295805ff410d

Modified Files
--------------
src/backend/parser/parse_cte.c     | 53 ++++++++++++++++++++++++--------------
src/test/regress/expected/with.out | 40 ++++++++++++++++++++++++++++
src/test/regress/sql/with.sql      | 29 +++++++++++++++++++++
3 files changed, 102 insertions(+), 20 deletions(-)


pgsql-committers by date:

Previous
From: Andrew Dunstan
Date:
Subject: pgsql: Use correct collate.windows.win1252.out
Next
From: Richard Guo
Date:
Subject: pgsql: Check lateral references within PHVs for memoize cache keys