Horton

Fix MERGE command tag for actions blocked by BEFORE ROW triggers.

Dean Rasheed <dean.a.rasheed@gmail.com>

View on postgr.es
Commit: 7b14e20b12cc8358cad9bdd05dd6b7de7f73c431
Author: Dean Rasheed <dean.a.rasheed@gmail.com>
Date: 2023-03-13T11:12:20Z
Releases: 16.0 
Fix MERGE command tag for actions blocked by BEFORE ROW triggers.

This ensures that the row count in the command tag for a MERGE is
correctly computed in the case where UPDATEs or DELETEs are skipped
due to a BEFORE ROW trigger returning NULL (the INSERT case was
already handled correctly by ExecMergeNotMatched() calling
ExecInsert()).

Back-patch to v15, where MERGE was introduced.

Discussion: https://postgr.es/m/CAEZATCU8XEmR0JWKDtyb7iZ%3DqCffxS9uyJt0iOZ4TV4RT%2Bow1w%40mail.gmail.com

Files

PathChange+/−
src/backend/executor/nodeModifyTable.c modified +6 −4
src/test/regress/expected/merge.out modified +15 −0
src/test/regress/sql/merge.sql modified +13 −0

Discussion