Use same lc_collate in CI as on production
Related to !74152 (comment 733215251)
Production DB on gitlab.com uses C.UTF-8
. But when running CI we use en_US.UTF-8
.
Depending on collation, package names can be returned in various order:
> AR query which builds sQL query like: SELECT "packages_packages".name COLLATE "C" FROM "packages_packages" ORDER BY "packages_packages"."name" ASC;
# with C.UTF-8 returns:
["@usernamespace493/foo1 201", "NugetPackage419 202", "zzz 205"]
# with en_US.UTF-8 returns:
["NugetPackage419 202", "@usernamespace493/foo1 201", "zzz 205"]
Would it make sense to run CI with same collation setting as on production to make sure we get same ordering in specs as in production?
Postgres docs: https://www.postgresql.org/docs/12/collation.html
Edited by charlie ablett