On 4/5/23 15:46, Jim Mlodgenski wrote:
>
>
> On Wed, Apr 5, 2023 at 2:41 PM Tom Lane <tgl@sss.pgh.pa.us
> <mailto:tgl@sss.pgh.pa.us>> wrote:
>
> "Daniel Westermann (DWE)" <daniel.westermann@dbi-services.com
> <mailto: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;
Yep -- RHEL 7.9 is glibc 2.17 (likely -326) and 8.7 is glibc 2.28 (-211
seems to be latest), and they are well known to sort differently even
for "common" characters (e.g. "-")
--
Joe Conway
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com