[PROPOSAL] Skip test citext_utf8 on Windows

Поиск
Список
Период
Сортировка
От Oleg Tselebrovskiy
Тема [PROPOSAL] Skip test citext_utf8 on Windows
Дата
Msg-id 6885a0b52d06f7e5910d2b6276bbb4e8@postgrespro.ru
обсуждение исходный текст
Ответы Re: [PROPOSAL] Skip test citext_utf8 on Windows  (Michael Paquier <michael@paquier.xyz>)
Re: [PROPOSAL] Skip test citext_utf8 on Windows  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-hackers
Greetings, everyone!

While running "installchecks" on databases with UTF-8 encoding the test
citext_utf8 fails because of Turkish dotted I like this:

  SELECT 'i'::citext = 'İ'::citext AS t;
   t
  ---
- t
+ f
  (1 row)

I tried to replicate the test's results by hand and with any collation
that I tried (including --locale="Turkish") this test failed

Also an interesing result of my tesing. If you initialize you DB
with -E utf-8 --locale="Turkish" and then run select LOWER('İ');
the output will be this:
  lower
-------
  İ
(1 row)

Which I find strange since lower() uses collation that was passed
(default in this case but still)

My PostgreSQL version is this:
postgres=# select version();
                                version
----------------------------------------------------------------------
  PostgreSQL 17devel on x86_64-windows, compiled by gcc-13.1.0, 64-bit

The proposed patch for skipping test is attached

Oleg Tselebrovskiy, Postgres Pro
Вложения

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

Предыдущее
От: Masahiko Sawada
Дата:
Сообщение: Re: [PoC] Improve dead tuple storage for lazy vacuum
Следующее
От: Anthonin Bonnefoy
Дата:
Сообщение: Fix expecteddir argument in pg_regress