pgsql: Fix transition tables for MERGE with cross-partition UPDATEs.
pgsql: Fix transition tables for MERGE with cross-partition UPDATEs.
От:
Dean Rasheed <dean.a.rasheed@gmail.com>
Дата:
Fix transition tables for MERGE with cross-partition UPDATEs. When a MERGE UPDATE action moved a row between partitions, the old and new rows were not included in the transition tables of AFTER UPDATE statement triggers, and could instead be incorrectly included in the transition tables of AFTER INSERT and AFTER DELETE statement triggers. Fix by capturing both halves of a cross-partition MERGE UPDATE action in the UPDATE transition tables and exclude them from the DELETE and INSERT transition tables, as we do for a plain UPDATE. Backpatch to v15, where MERGE was introduced. Reported-by: Michael Ries Reported-by: Tender Wang Author: Tender Wang Reviewed-by: shihao zhong Discussion: https://postgr.es/m/CAKWDHLgETF86qEW40HcEzMgn5DdmS6yR-nSYwemXF7zFGrU%2BsQ%40mail.gmail.com Discussion: https://postgr.es/m/CAHewXNk8MgaFMD87s%3DxHeguzmErEjsqeroxrMyQbKyXwG5eocw%40mail.gmail.com Backpatch-through: 15 Branch ------ REL_18_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/84b36063f4092c54f0cc628e6d9c684af6128d07 Modified Files -------------- src/backend/executor/nodeModifyTable.c | 69 +++++++++++++++++----------------- src/test/regress/expected/triggers.out | 31 +++++++++++++++ src/test/regress/sql/triggers.sql | 30 +++++++++++++++ 3 files changed, 95 insertions(+), 35 deletions(-)