Re: BUG #18362: unaccent rules and Old Greek text

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, Peter Eisentraut <peter(at)eisentraut(dot)org>, Cees van Zeeland <cees(dot)van(dot)zeeland(at)freedom(dot)nl>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #18362: unaccent rules and Old Greek text
Date: 2024-05-23 06:21:02
Message-ID: Zk7gTggGrBFnFwGl@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Wed, May 22, 2024 at 12:47:37PM -0400, Robert Haas wrote:
> On Sat, May 18, 2024 at 5:37 AM Thomas Munro <thomas(dot)munro(at)gmail(dot)com> wrote:
>> And in the tests I now see that Michael had already figured that out!
>> I've included a kludge to remove that. Someone should file a ticket with CLDR.

That was some time ago.. I was not sure back then how to handle that
with upstream data, so thanks for the bug report and the pointers.
I'll try to remember that.

> I think you should update the comment that says "a mistake?" to
> instead link to the CLDR issue that Peter filed. Other than that, I'm
> not sure this needs any other changes. I can't actually testify to the
> correctness of the Python code, but the results look sane so hey, why
> not?

+1 for the comment refresh in the test, keeping the test.

+ if src == "ℌ":
+ # a mistake?
+ continue

Perhaps this should use the codepoint rather than the non-ascii
character in the script.

Another thing would be to add some tests that cover the new characters
that get a conversion. Just a few of them in the new ranges, checking
the recursive case with is_letter_with_marks() would be fine.
--
Michael

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Önder Kalacı 2024-05-23 06:54:31 Re: BUG #18467: postgres_fdw (deparser) ignores LimitOption
Previous Message Noah Misch 2024-05-22 23:59:01 Re: relfrozenxid may disagree with row XIDs after 1ccc1e05ae