diff -U3 /tmp/cirrus-ci-build/contrib/pg_trgm/expected/pg_trgm.out /tmp/cirrus-ci-build/build/testrun/pg_trgm/regress/results/pg_trgm.out --- /tmp/cirrus-ci-build/contrib/pg_trgm/expected/pg_trgm.out 2024-03-29 10:06:46.562417000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_trgm/regress/results/pg_trgm.out 2024-03-29 10:24:51.745959000 +0000 @@ -3,6 +3,7 @@ SELECT amname, opcname FROM pg_opclass opc LEFT JOIN pg_am am ON am.oid = opcmethod WHERE opc.oid >= 16384 AND NOT amvalidate(opc.oid); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree amname | opcname --------+--------- (0 rows) @@ -4694,6 +4695,7 @@ create temp table t_test_trgm(t text COLLATE "C"); create index t_trgm_idx on t_test_trgm using gin (t gin_trgm_ops); insert into t_test_trgm values ('qwerty99'), ('qwerty01'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree explain (costs off) select count(*) from t_test_trgm where t like '%99%' and t like '%qwerty%'; QUERY PLAN @@ -5353,7 +5355,9 @@ -- Check similarity threshold (bug #14202) CREATE TEMP TABLE restaurants (city text); INSERT INTO restaurants SELECT 'Warsaw' FROM generate_series(1, 10000); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INSERT INTO restaurants SELECT 'Szczecin' FROM generate_series(1, 10000); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree CREATE INDEX ON restaurants USING gist(city gist_trgm_ops); -- Similarity of the two names (for reference). SELECT similarity('Szczecin', 'Warsaw');