Horton

Fix MERGE command tag for cross-partition updates.

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

View on postgr.es
Commit: 80a48e0f21c51ed65fe647b18019ab6f8eab15cd
Author: Dean Rasheed <dean.a.rasheed@gmail.com>
Date: 2023-02-22T09:39:09Z
Releases: 16.0 
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