Inherit regression outputs rows in alternative ordering when run on other table AM than heap
Pavel Borisov <pashkin.elfe@gmail.com>
From: Pavel Borisov <pashkin.elfe@gmail.com>
To: Postgres hackers <pgsql-hackers@lists.postgresql.org>
Date: 2026-03-27T12:54:25Z
Lists: pgsql-hackers
Attachments
- v1-0001-Stabilize-output-of-inherit-regression-test.patch (application/octet-stream) patch v1-0001
Hi, hackers! Existing inherit regression test results are tied to the particular row order after UPDATE clause. The context is approximately the same as in [1]. When run on different table AM it shows the following difference in output: @@ -157,12 +157,12 @@ SELECT relname, a.* FROM a, pg_class where a.tableoid = pg_class.oid; relname | aa ---------+---------- + a | zzzzzz a | zzzz a | zzzzz a | zzzzzz a | zzzzzz a | zzzzzz - a | zzzzzz b | bbb b | bbbb b | bbbbb @@ -231,12 +231,12 @@ SELECT relname, a.* FROM ONLY a, pg_class where a.tableoid = pg_class.oid; relname | aa ---------+-------- + a | zzzzzz a | zzzz a | zzzzz a | zzzzzz a | zzzzzz a | zzzzzz - a | zzzzzz (6 rows) SELECT relname, b.* FROM ONLY b, pg_class where b.tableoid = pg_class.oid; @@ -276,9 +276,9 @@ SELECT relname, a.* FROM a, pg_class where a.tableoid = pg_class.oid; relname | aa ---------+---------- + a | zzzzzz a | zzzz a | zzzzz - a | zzzzzz a | zzzzzz a | zzzzzz a | zzzzzz @@ -350,12 +350,12 @@ SELECT relname, a.* FROM ONLY a, pg_class where a.tableoid = pg_class.oid; relname | aa ---------+-------- + a | zzzzzz a | zzzz a | zzzzz a | zzzzzz a | zzzzzz a | zzzzzz - a | zzzzzz (6 rows) This could be easily fixed by adding ORDER BY clause to the test. See the patch proposed. I added order by not only to places prone to the difference quoted but also to other places as it's cheap and doesn't harm. If the committer don't agree with extra order by's I can leave only those necessary for fixing quoted test output. [1] https://github.com/postgres/postgres/commit/4c1a27e53a508f74883cda52a6c8612121d7fd6b
Commits
Same data as JSON:
GET /api/v1/messages/:b64id/commits
the thread's linked commits as JSON, with link sources.
API reference →
-
Stabilize output of new isolation test insert-conflict-do-update-4.
- 4c1a27e53a50 19 (unreleased) cited