pgsql: Fix computation of varnullingrels when const-folding field selec - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Fix computation of varnullingrels when const-folding field selec
Date
Msg-id E1r1Bux-004hOx-If@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Fix computation of varnullingrels when const-folding field selection.

We can simplify FieldSelect on a whole-row Var into a plain Var
for the selected field.  However, we should copy the whole-row Var's
varnullingrels when we do so, because the new Var is clearly nullable
by exactly the same rels as the original.  Failure to do this led to
errors like "wrong varnullingrels (b) (expected (b 3)) for Var 2/2".

Richard Guo, per bug #18184 from Marian Krucina.  Back-patch to
v16 where varnullingrels was introduced.

Discussion: https://postgr.es/m/18184-5868dd258782058e@postgresql.org

Branch
------
REL_16_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/6bf2efb38285626a9de3004dd1c23d9a85453372

Modified Files
--------------
src/backend/optimizer/util/clauses.c | 19 +++++++++++++------
src/test/regress/expected/join.out   | 26 ++++++++++++++++++++++++++
src/test/regress/sql/join.sql        | 12 ++++++++++++
3 files changed, 51 insertions(+), 6 deletions(-)


pgsql-committers by date:

Previous
From: Peter Eisentraut
Date:
Subject: pgsql: meson: Install missing example files
Next
From: Bruce Momjian
Date:
Subject: pgsql: doc: remove unnecessary comma in postgres-fdw