Re: BUG #15892: URGENT: Using an ICU collation in a primary key column breaks ILIKE query - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #15892: URGENT: Using an ICU collation in a primary key column breaks ILIKE query
Date
Msg-id 12522.1565630258@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #15892: URGENT: Using an ICU collation in a primary keycolumn breaks ILIKE query  (Arthur Zakirov <a.zakirov@postgrespro.ru>)
List pgsql-bugs
Arthur Zakirov <a.zakirov@postgrespro.ru> writes:
> On 12.08.2019 00:32, Tom Lane wrote:
>> I think Daniel's patch leaves more on the table than it needs to,
>> and I don't like Arthur's patch because it's assuming more than it
>> should about whether it's okay to pass a "char" to u_isalpha().
>> I propose that we do things as attached, instead.

> Yeah, u_isalpha() wasn't such good idea here. BTW Daniel already 
> mentioned it above.
> With the patch regression tests pass for me and James test case works 
> fine as expected.

Thanks for double-checking!  Pushed now.

            regards, tom lane



pgsql-bugs by date:

Previous
From: Jeff Janes
Date:
Subject: Re: BUG #15949: pg_basebackup failed(PG-12-Beta3)
Next
From: PG Bug reporting form
Date:
Subject: BUG #15950: pg_freespace.avail is 0