pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: Fix more bugs caused by adding columns to the end of a view.
Date: Tue, 07 Mar 2023 23:22:19 +0000
Message-ID: <E1pZgdO-002Pg0-Ow@gemulon.postgresql.org> (raw)

Fix more bugs caused by adding columns to the end of a view.

If a view is defined atop another view, and then CREATE OR REPLACE
VIEW is used to add columns to the lower view, then when the upper
view's referencing RTE is expanded by ApplyRetrieveRule we will have
a subquery RTE with fewer eref->colnames than output columns.  This
confuses various code that assumes those lists are always in sync,
as they are in plain parser output.

We have seen such problems before (cf commit d5b760ecb), and now
I think the time has come to do what was speculated about in that
commit: let's make ApplyRetrieveRule synthesize some column names to
preserve the invariant that holds in parser output.  Otherwise we'll
be chasing this class of bugs indefinitely.  Moreover, it appears from
testing that this actually gives us better results in the test case
d5b760ecb added, and likely in other corner cases that we lack
coverage for.

In HEAD, I replaced d5b760ecb's hack to make expandRTE exit early with
an elog(ERROR) call, since the case is now presumably unreachable.
But it seems like changing that in back branches would bring more risk
than benefit, so there I just updated the comment.

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

Discussion: https://postgr.es/m/17811-d31686b78f0dffc9@postgresql.org

Branch
------
REL_14_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/9f1e51b5967345afc42efb6c146043b5bcd91679

Modified Files
--------------
src/backend/parser/parse_relation.c       | 17 +++++++-----
src/backend/rewrite/rewriteHandler.c      | 16 ++++++++++++
src/test/regress/expected/alter_table.out | 43 ++++++++++++++++++++++++++-----
src/test/regress/sql/alter_table.sql      | 20 +++++++++++++-
4 files changed, 82 insertions(+), 14 deletions(-)



view thread (6+ messages)

Message-ID: <E1pZgdO-002Pg0-Ow@gemulon.postgresql.org>
Permalink:  ../E1pZgdO-002Pg0-Ow@gemulon.postgresql.org/
Also on:    postgresql.org/message-id/E1pZgdO-002Pg0-Ow@gemulon.postgresql.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-committers@postgresql.org
  Cc: tgl@sss.pgh.pa.us
  Subject: Re: pgsql: Fix more bugs caused by adding columns to the end of a view.
  In-Reply-To: <E1pZgdO-002Pg0-Ow@gemulon.postgresql.org>
  References: <E1pZgdO-002Pg0-Ow@gemulon.postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox