From: | Amit Langote <amitlan(at)postgresql(dot)org> |
---|---|
To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
Subject: | pgsql: Fix an oversight in cbc127917 to handle MERGE correctly |
Date: | 2025-02-17 07:13:12 |
Message-ID: | E1tjvJX-007Z9J-RU@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Fix an oversight in cbc127917 to handle MERGE correctly
ExecInitModifyTable() forgot to trim MERGE-related lists to exclude
entries for result relations pruned during initial pruning, so fix
that.
While at it, make the function's use of the pruned resultRelations
list, rather than ModifyTable.resultRelations, more consistent.
Reported-by: Alexander Lakhin <exclusion(at)gmail(dot)com> (via sqlsmith)
Reviewed-by: Junwang Zhao <zhjwpku(at)gmail(dot)com>
Discussion: https://postgr.es/m/e72c94d9-e5f9-4753-9bc1-69d72bd54b8a@gmail.com
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/75dfde13639a57513e23e58c961a69c5bbf017b6
Modified Files
--------------
src/backend/executor/nodeModifyTable.c | 35 +++++++++---
src/include/nodes/execnodes.h | 7 ++-
src/test/regress/expected/partition_prune.out | 77 +++++++++++++++++++++++++++
src/test/regress/sql/partition_prune.sql | 25 +++++++++
4 files changed, 134 insertions(+), 10 deletions(-)
From | Date | Subject | |
---|---|---|---|
Next Message | Alexander Korotkov | 2025-02-17 10:40:42 | pgsql: Revert: Get rid of WALBufMappingLock |
Previous Message | Michael Paquier | 2025-02-17 06:15:51 | pgsql: Add information about WAL buffers full to VACUUM/ANALYZE (VERBOS |