Thread: pgsql: Fix random regression failure in test case "collate.icu.utf8"

pgsql: Fix random regression failure in test case "collate.icu.utf8"

From
Michael Paquier
Date:
Fix random regression failure in test case "collate.icu.utf8"

This is a fix similar to 2d7d67cc, where slight plan alteration can
cause a random failure of this regression test because of an incorect
tuple ordering, except that this one involves lookups of pg_type.
Similarly to the other case, add ORDER BY clauses to ensure the output
order.

The failure has been seen at least once on buildfarm member skink.

Reported-by: Thomas Munro
Discussion: https://postgr.es/m/CA+hUKGLjR9ZBvhXcr9b-NSBHPw9aRgbjyzGE+kqLsT4vwX+nkQ@mail.gmail.com
Backpatch-through: 12

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/96e7e1bc08919ceb34d95140834f0db94266da2e

Modified Files
--------------
src/test/regress/expected/collate.icu.utf8.out | 6 ++++--
src/test/regress/sql/collate.icu.utf8.sql      | 6 ++++--
2 files changed, 8 insertions(+), 4 deletions(-)