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
v1-0001-Stabilize-output-of-inherit-regression-test.patch
Description: Binary data
