From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Daniel Westermann (DWE)" <daniel.westermann@dbi-services.com>
cc: "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Subject: Re: Wrong results with postgres_fdw and merge anti join from RHEL 7.9
 to RHEL 8.7
In-reply-to: 
 <GV0P278MB041930B2E5FE2DFEC77FE36FD2909@GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM>
References: 
 <GV0P278MB0419C826AF173592DA648C88D2909@GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM>
 <2017352.1680720065@sss.pgh.pa.us>
 <GV0P278MB04193FBC28A1744C6945B81ED2909@GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM>
 <2020213.1680721496@sss.pgh.pa.us>
 <GV0P278MB041930B2E5FE2DFEC77FE36FD2909@GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM>
Comments: In-reply-to "Daniel Westermann (DWE)"
 <daniel.westermann@dbi-services.com>
	message dated "Wed, 05 Apr 2023 19:20:21 -0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <2060815.1680725248.1@sss.pgh.pa.us>
Date: Wed, 05 Apr 2023 16:07:28 -0400
Message-ID: <2060816.1680725248@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/2060816.1680725248%40sss.pgh.pa.us>
Precedence: bulk

"Daniel Westermann (DWE)" <daniel.westermann@dbi-services.com> writes:
>> The sample data you showed seemed to only involve numeric-ish strings,
>> which would be highly unlikely to change sort order across locale
>> updates.  But maybe there are weirder entries elsewhere in the column?

> I can probably provide a dump, but I've to ask. Would that help?

I wasn't volunteering to check the data for you ;-), just suggesting
that you might find it interesting to do so yourself.

			regards, tom lane