]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Stabilize output of new isolation test insert-conflict-do-update-4.
authorTom Lane <tgl@sss.pgh.pa.us>
Wed, 25 Feb 2026 15:51:42 +0000 (10:51 -0500)
committerTom Lane <tgl@sss.pgh.pa.us>
Wed, 25 Feb 2026 15:51:42 +0000 (10:51 -0500)
commitb57d35dde7dde5e94ce534a6f2a0a24cb5ccb2c1
treed478092b2341acd3fc9c0dde871d437e2857a7af
parente726620d208ee1fca37a6cbfe0fc9a7031ff659e
Stabilize output of new isolation test insert-conflict-do-update-4.

The test added by commit 4b760a181 assumed that a table's physical
row order would be predictable after an UPDATE.  But a non-heap table
AM might produce some other order.  Even with heap AM, the assumption
seems risky; compare a3fd53bab for instance.  Adding an ORDER BY is
cheap insurance and doesn't break any goal of the test.

Author: Pavel Borisov <pashkin.elfe@gmail.com>
Reviewed-by: Tom Lane <tgl@sss.pgh.pa.us>
Discussion: https://postgr.es/m/CALT9ZEHcE6tpvumScYPO6pGk_ASjTjWojLkodHnk33dvRPHXVw@mail.gmail.com
Backpatch-through: 14
src/test/isolation/expected/insert-conflict-do-update-4.out
src/test/isolation/specs/insert-conflict-do-update-4.spec