Horton

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

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

View on postgr.es
Commit: da6257eee35db5d281a115838abaf285b46b52f3
Author: Dean Rasheed <dean.a.rasheed@gmail.com>
Date: 2023-03-13T11:11:10Z
Releases: 15.3 
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