From: | Oleksandr Voytsekhovskyy <young(dot)inbox(at)gmail(dot)com> |
---|---|
To: | PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Wrong sorting on docker image |
Date: | 2021-10-16 10:50:31 |
Message-ID: | F29709C9-A061-4034-A77D-7E237CF36391@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 (((
From | Date | Subject | |
---|---|---|---|
Next Message | Peter J. Holzer | 2021-10-16 12:32:35 | Re: Wrong sorting on docker image |
Previous Message | Gavin Flower | 2021-10-16 08:31:56 | Re: "two time periods with only an endpoint in common do not overlap" ??? |