pgsql: Fix EvalPlanQualStart to handle partitioned result relscorrectl - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Fix EvalPlanQualStart to handle partitioned result relscorrectl
Date
Msg-id E1hDX0Y-0002dV-Ht@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Fix EvalPlanQualStart to handle partitioned result rels correctly.

The es_root_result_relations array needs to be shallow-copied in the
same way as the main es_result_relations array, else EPQ rechecks on
partitioned result relations fail, as seen in bug #15677 from
Norbert Benkocs.

Amit Langote, isolation test case added by me

Discussion: https://postgr.es/m/15677-0bf089579b4cd02d@postgresql.org
Discussion: https://postgr.es/m/19321.1554567786@sss.pgh.pa.us

Branch
------
master

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

Modified Files
--------------
src/backend/executor/execMain.c                | 14 +++++++++++++-
src/test/isolation/expected/eval-plan-qual.out | 12 ++++++++++++
src/test/isolation/specs/eval-plan-qual.spec   | 17 +++++++++++++++++
3 files changed, 42 insertions(+), 1 deletion(-)


pgsql-committers by date:

Previous
From: Peter Eisentraut
Date:
Subject: pgsql: doc: Add note about generated columns in foreign tables
Next
From: Peter Eisentraut
Date:
Subject: pgsql: doc: Update serial explanation