Horton

Fix MERGE command tag for cross-partition updates.

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

View on postgr.es
Commit: 018af1cc1c8075346e6a5fe3bb77b7e31399be70
Author: Dean Rasheed <dean.a.rasheed@gmail.com>
Date: 2023-02-22T09:41:28Z
Releases: 15.3 
Fix MERGE command tag for cross-partition updates.

This ensures that the row count in the command tag for a MERGE is
correctly computed. Previously, if MERGE updated a partitioned table,
the row count would be incorrect if any row was moved to a different
partition, since such updates were counted twice.

Back-patch to v15, where MERGE was introduced.

Discussion: https://postgr.es/m/CAEZATCWRMG7XX2QEsVL1LswmNo2d_YG8tKTLkpD3=Lp644S7rg@mail.gmail.com

Files

PathChange+/−
src/backend/executor/nodeModifyTable.c modified +1 −1
src/test/regress/expected/merge.out modified +16 −0
src/test/regress/sql/merge.sql modified +11 −0

Discussion