Re: Order changes in PG16 since ICU introduction

Поиск
Список
Период
Сортировка
От Sandro Santilli
Тема Re: Order changes in PG16 since ICU introduction
Дата
Msg-id ZELDOktA75yYG4Z2@hst.kbt.io
обсуждение исходный текст
Ответ на Re: Order changes in PG16 since ICU introduction  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Order changes in PG16 since ICU introduction  (Peter Eisentraut <peter.eisentraut@enterprisedb.com>)
Re: Order changes in PG16 since ICU introduction  (Jeff Davis <pgsql@j-davis.com>)
Список pgsql-hackers
On Fri, Apr 21, 2023 at 11:48:51AM -0400, Tom Lane wrote:
> "Regina Obe" <lr@pcorp.us> writes:
> 
> > https://trac.osgeo.org/postgis/ticket/5375
> 
> If they actually are using locale C, I would say this is a bug.
> That should designate memcmp sorting and nothing else.

Sounds like a bug to me. This is happening with a PostgreSQL cluster
created and served by a build of commit c04c6c5d6f :

  =# select version();
  PostgreSQL 16devel on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.3.0-1ubuntu1~22.04) 11.3.0, 64-bit
  =# show lc_collate;
  C
  =# select '+' < '-';
  f
  =# select '+' < '-' collate "C";
  t

I don't know if it should matter but also:

  =# show lc_messages;
  C

--strk;



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: LLVM strip -x fails
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Remove references to pre-11 versions