On Tue, 2024-09-17 at 08:00 +0200, Laurenz Albe wrote:
> Using a trigram index with an non-deterministic collation can
> lead to wrong query results:
> [...]
>
> I don't know what the correct fix would be. Perhaps just refusing to use
> the index for equality comparisons with non-deterministic co
Using a trigram index with an non-deterministic collation can
lead to wrong query results:
CREATE COLLATION faux_cn (PROVIDER = icu, LOCALE = 'und', DETERMINISTIC =
FALSE, RULES = '&l = r');
CREATE TABLE boom (id integer PRIMARY KEY, t text COLLATE faux_cn);
INSERT INTO boom VALUES (1, 'r
