Re: Wrong results with postgres_fdw and merge anti join from RHEL 7.9 to RHEL 8.7 - Mailing list pgsql-bugs

"Daniel Westermann (DWE)" <daniel.westermann@dbi-services.com> writes:
> I am not sure if this qualifies as  bug, but anyway:

> Source instance: PostgreSQL 13.7 on RHEL 7.9
> Target instance PostgreSQL 13.7 on RHEL 8.7

glibc on those 2 versions of RHEL have very different ideas of what the sort order should be. Try running the following and you'll likely see different results on RHEL 7.9 vs 8.7

CREATE TABLE t1 (c1 varchar PRIMARY KEY);
INSERT INTO t1 VALUES ('1-a'), ('1a'), ('1-aa');
SELECT * FROM t1 ORDER BY c1;