Wrong sorting on docker image

Поиск
Список
Период
Сортировка
Искать
От
Oleksandr Voytsekhovskyy
Тема
Wrong sorting on docker image
Дата
Msg-id
F29709C9-A061-4034-A77D-7E237CF36391@gmail.com
Список
Дерево обсуждения
Wrong sorting on docker image Oleksandr Voytsekhovskyy <young.inbox@gmail.com>
Re: Wrong sorting on docker image Tom Lane <tgl@sss.pgh.pa.us>
Re: Wrong sorting on docker image Thomas Munro <thomas.munro@gmail.com>
Re: Wrong sorting on docker image "Peter J. Holzer" <hjp-pgsql@hjp.at>
Greetings

Starting from version 12.0 official docker image switched from Debian-stretch to Debian-bullseye and from that point we have a huge pain with sorting issues on Russian collation.

Dockerfile:

FROM postgres:14
RUN apt-get clean && apt-get update && apt-get install -y locales
RUN localedef -i ru_RU -c -f UTF-8 -A /usr/share/locale/locale.alias ru_RU.UTF-8
ENV LANG ru_RU.utf8

postgres=# select version();
                                                           version                                                           
-----------------------------------------------------------------------------------------------------------------------------
 PostgreSQL 14.0 (Debian 14.0-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit


Issue:

postgres=# SELECT * FROM unnest(ARRAY ['ея', 'ёа']) name ORDER BY name;
 name 
------
 ёа
 ея
(2 строки)



  еqя should go before  ёqа

postgres=# SELECT 'ея' COLLATE "ru_RU" < 'ёа' COLLATE "ru_RU";
 ?column? 
----------
 f
(1 строка)

And should be TRUE here

Any idea how to fix that?

We are not able manage this for 3 years already (((


В списке pgsql-general по дате отправления
Предыдущее
От: Gavin Flower
Дата:
Следующее
От: Peter J. Holzer
Дата:
FAQ