Re: Order changes in PG16 since ICU introduction

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Regina Obe" <lr(at)pcorp(dot)us>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org, Jeff Davis <pgsql(at)j-davis(dot)com>
Subject: Re: Order changes in PG16 since ICU introduction
Date: 2023-04-21 15:48:51
Message-ID: 3353947.1682092131@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Regina Obe" <lr(at)pcorp(dot)us> writes:
> A couple of days ago, our PostGIS PG16 bots started failing with order
> changes in text.
> We have our tests set to locale=c

> It seems since April 20th, our tests that rely on sorting characters
> changed.
> As noted in this ticket:

> https://trac.osgeo.org/postgis/ticket/5375

> I'm assuming it's result of icu change:
> https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=fcb21b3ac
> dcb9a60313325618fd7080aa36f1626

> I suspect all our bots are compiling with icu enabled. But I haven't
> confirmed.

If they actually are using locale C, I would say this is a bug.
That should designate memcmp sorting and nothing else.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Ranier Vilela 2023-04-21 16:11:56 Re: Improve list manipulation in several places
Previous Message Regina Obe 2023-04-21 15:27:19 Order changes in PG16 since ICU introduction