show_trgm is still affected with the same issue:
CREATE EXTENSION IF NOT EXISTS pg_trgm;
CREATE TEMP TABLE st_a(x text COLLATE "C"); INSERT INTO st_a
VALUES ('hello');
CREATE TEMP TABLE st_b(y text COLLATE "POSIX"); INSERT INTO st_b
VALUES ('world');
SELECT show_trgm(x || y) FROM st_a, st_b;
And I noticed one more thing, is this change expected, as it doesn't
seem intentional? (also with posix or ucs_basic)
SELECT show_trgm('Привет мир' COLLATE "C");
-- {}
postgres=# SELECT similarity('Привет мир' COLLATE "C", 'Привет мир'
COLLATE "C");
-- 0
Looking back this is caused by 0002, and was there since v2 and I
completely missed it before.