Re: Postgres 12: backend crashes when creating non-deterministiccollation

Laurenz Albe schrieb am 04.10.2019 um 16:04:
>> I was trying to learn how the new non-deterministic collations in v12
>> work, but the following makes the backend crash:
>>
>> CREATE COLLATION de_ci (provider = icu, locale = 'de-x-icu',
>> deterministic = false);
>>
>> Which leads to:
>>
>> 2019-10-04 11:54:23 CEST   LOG:  server process (PID 7540) was
>> terminated by exception 0xC0000005
>>
>> I might have misunderstood how to use deterministic to create a case-
>> insensitive collation, but I don't think the backend should crash if
>> I do something wrong ;)
>
> Yes, there is a bug somewhere.  FWIW, it works on my Linux system.

It also works on Windows when I specify "correct" locale names - the above seems to be an edge case.
Is it worth the effort to report that through the bug reporting form?

> To get a case insensitive collation you'd have to use something like
>
>      LOCALE = 'de-DE-u-ks-level2'

Creating works, but apparently on Windows ICU does not support this.

The following works fine on Linux (returns both rows), but not on Windows (returns nothing)

   create collation de_ci (provider = icu, locale = 'de-DE-u-ks-level2', deterministic = false);
   create table test (name text);
   insert into test values ('FOO'), ('Foo');

   select *
   from test
   where name = 'foo' collate de_ci;

Not a big deal, but might surprise some people.

Thomas