Fix MERGE command tag for cross-partition updates.
authorDean Rasheed <dean.a.rasheed@gmail.com>
Wed, 22 Feb 2023 09:39:09 +0000 (09:39 +0000)
committerDean Rasheed <dean.a.rasheed@gmail.com>
Wed, 22 Feb 2023 09:39:09 +0000 (09:39 +0000)
commit80a48e0f21c51ed65fe647b18019ab6f8eab15cd
tree71ce807c5e89ffbb52d6e7b89fd9a478054391c6
parent2ddab010c2777c6a965cea82dc1b809ddc33ecc1
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
src/backend/executor/nodeModifyTable.c
src/test/regress/expected/merge.out
src/test/regress/sql/merge.sql