diff -U3 /tmp/cirrus-ci-build/contrib/btree_gist/expected/init.out /tmp/cirrus-ci-build/build/testrun/btree_gist/regress/results/init.out --- /tmp/cirrus-ci-build/contrib/btree_gist/expected/init.out 2024-03-19 15:41:20.182734000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/btree_gist/regress/results/init.out 2024-03-19 15:59:09.577157000 +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) diff -U3 /tmp/cirrus-ci-build/contrib/btree_gist/expected/oid.out /tmp/cirrus-ci-build/build/testrun/btree_gist/regress/results/oid.out --- /tmp/cirrus-ci-build/contrib/btree_gist/expected/oid.out 2024-03-19 15:41:20.182815000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/btree_gist/regress/results/oid.out 2024-03-19 15:59:09.721169000 +0000 @@ -2,6 +2,7 @@ SET enable_seqscan=on; CREATE TEMPORARY TABLE oidtmp (oid oid); INSERT INTO oidtmp SELECT g.i::oid FROM generate_series(1, 1000) g(i); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree SELECT count(*) FROM oidtmp WHERE oid < 17; count ------- diff -U3 /tmp/cirrus-ci-build/contrib/btree_gist/expected/timetz.out /tmp/cirrus-ci-build/build/testrun/btree_gist/regress/results/timetz.out --- /tmp/cirrus-ci-build/contrib/btree_gist/expected/timetz.out 2024-03-19 15:41:20.182914000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/btree_gist/regress/results/timetz.out 2024-03-19 15:59:09.820792000 +0000 @@ -4,37 +4,67 @@ CREATE TABLE timetzcmp ( r_id int2, a int4, b int4 ); SET enable_seqscan=on; INSERT INTO timetzcmp (r_id,a) SELECT 1,count(*) FROM timetztmp WHERE a < '07:46:45 GMT+3'; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INSERT INTO timetzcmp (r_id,a) SELECT 2,count(*) FROM timetztmp WHERE a <= '07:46:45 GMT+3'; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INSERT INTO timetzcmp (r_id,a) SELECT 3,count(*) FROM timetztmp WHERE a = '07:46:45 GMT+3'; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INSERT INTO timetzcmp (r_id,a) SELECT 4,count(*) FROM timetztmp WHERE a >= '07:46:45 GMT+3'; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INSERT INTO timetzcmp (r_id,a) SELECT 5,count(*) FROM timetztmp WHERE a > '07:46:45 GMT+3'; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INSERT INTO timetzcmp (r_id,a) SELECT 11,count(*) FROM timetztmp WHERE a < '07:46:45 GMT+2'; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INSERT INTO timetzcmp (r_id,a) SELECT 12,count(*) FROM timetztmp WHERE a <= '07:46:45 GMT+2'; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INSERT INTO timetzcmp (r_id,a) SELECT 13,count(*) FROM timetztmp WHERE a = '07:46:45 GMT+2'; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INSERT INTO timetzcmp (r_id,a) SELECT 14,count(*) FROM timetztmp WHERE a >= '07:46:45 GMT+2'; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INSERT INTO timetzcmp (r_id,a) SELECT 15,count(*) FROM timetztmp WHERE a > '07:46:45 GMT+2'; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INSERT INTO timetzcmp (r_id,a) SELECT 21,count(*) FROM timetztmp WHERE a < '07:46:45 GMT+4'; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INSERT INTO timetzcmp (r_id,a) SELECT 22,count(*) FROM timetztmp WHERE a <= '07:46:45 GMT+4'; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INSERT INTO timetzcmp (r_id,a) SELECT 23,count(*) FROM timetztmp WHERE a = '07:46:45 GMT+4'; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INSERT INTO timetzcmp (r_id,a) SELECT 24,count(*) FROM timetztmp WHERE a >= '07:46:45 GMT+4'; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INSERT INTO timetzcmp (r_id,a) SELECT 25,count(*) FROM timetztmp WHERE a > '07:46:45 GMT+4'; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree CREATE INDEX timetzidx ON timetztmp USING gist ( a ); SET enable_seqscan=off; UPDATE timetzcmp SET b=c FROM ( SELECT count(*) AS c FROM timetztmp WHERE a < '07:46:45 GMT+3'::timetz ) q WHERE r_id=1 ; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree UPDATE timetzcmp SET b=c FROM ( SELECT count(*) AS c FROM timetztmp WHERE a <= '07:46:45 GMT+3'::timetz ) q WHERE r_id=2 ; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree UPDATE timetzcmp SET b=c FROM ( SELECT count(*) AS c FROM timetztmp WHERE a = '07:46:45 GMT+3'::timetz ) q WHERE r_id=3 ; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree UPDATE timetzcmp SET b=c FROM ( SELECT count(*) AS c FROM timetztmp WHERE a >= '07:46:45 GMT+3'::timetz ) q WHERE r_id=4 ; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree UPDATE timetzcmp SET b=c FROM ( SELECT count(*) AS c FROM timetztmp WHERE a > '07:46:45 GMT+3'::timetz ) q WHERE r_id=5 ; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree UPDATE timetzcmp SET b=c FROM ( SELECT count(*) AS c FROM timetztmp WHERE a < '07:46:45 GMT+2'::timetz ) q WHERE r_id=11 ; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree UPDATE timetzcmp SET b=c FROM ( SELECT count(*) AS c FROM timetztmp WHERE a <= '07:46:45 GMT+2'::timetz ) q WHERE r_id=12 ; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree UPDATE timetzcmp SET b=c FROM ( SELECT count(*) AS c FROM timetztmp WHERE a = '07:46:45 GMT+2'::timetz ) q WHERE r_id=13 ; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree UPDATE timetzcmp SET b=c FROM ( SELECT count(*) AS c FROM timetztmp WHERE a >= '07:46:45 GMT+2'::timetz ) q WHERE r_id=14 ; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree UPDATE timetzcmp SET b=c FROM ( SELECT count(*) AS c FROM timetztmp WHERE a > '07:46:45 GMT+2'::timetz ) q WHERE r_id=15 ; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree UPDATE timetzcmp SET b=c FROM ( SELECT count(*) AS c FROM timetztmp WHERE a < '07:46:45 GMT+4'::timetz ) q WHERE r_id=21 ; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree UPDATE timetzcmp SET b=c FROM ( SELECT count(*) AS c FROM timetztmp WHERE a <= '07:46:45 GMT+4'::timetz ) q WHERE r_id=22 ; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree UPDATE timetzcmp SET b=c FROM ( SELECT count(*) AS c FROM timetztmp WHERE a = '07:46:45 GMT+4'::timetz ) q WHERE r_id=23 ; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree UPDATE timetzcmp SET b=c FROM ( SELECT count(*) AS c FROM timetztmp WHERE a >= '07:46:45 GMT+4'::timetz ) q WHERE r_id=24 ; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree UPDATE timetzcmp SET b=c FROM ( SELECT count(*) AS c FROM timetztmp WHERE a > '07:46:45 GMT+4'::timetz ) q WHERE r_id=25 ; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree SELECT count(*) FROM timetzcmp WHERE a=b; count ------- diff -U3 /tmp/cirrus-ci-build/contrib/btree_gist/expected/not_equal.out /tmp/cirrus-ci-build/build/testrun/btree_gist/regress/results/not_equal.out --- /tmp/cirrus-ci-build/contrib/btree_gist/expected/not_equal.out 2024-03-19 15:41:20.182797000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/btree_gist/regress/results/not_equal.out 2024-03-19 15:59:10.178669000 +0000 @@ -6,9 +6,11 @@ ); CREATE INDEX test_ne_idx ON test_ne USING gist (a, b); INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree INSERT INTO test_ne VALUES('2007-02-03', -91.3); INSERT INTO test_ne VALUES('2011-09-01', 43.7); INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree SET enable_indexscan to false; EXPLAIN (COSTS OFF) SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7; QUERY PLAN diff -U3 /tmp/cirrus-ci-build/contrib/btree_gist/expected/bool.out /tmp/cirrus-ci-build/build/testrun/btree_gist/regress/results/bool.out --- /tmp/cirrus-ci-build/contrib/btree_gist/expected/bool.out 2024-03-19 15:41:20.182612000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/btree_gist/regress/results/bool.out 2024-03-19 15:59:10.215794000 +0000 @@ -1,6 +1,7 @@ -- bool check CREATE TABLE booltmp (a bool); INSERT INTO booltmp VALUES (false), (true); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree SET enable_seqscan=on; SELECT count(*) FROM booltmp WHERE a < true; count diff -U3 /tmp/cirrus-ci-build/contrib/btree_gist/expected/partitions.out /tmp/cirrus-ci-build/build/testrun/btree_gist/regress/results/partitions.out --- /tmp/cirrus-ci-build/contrib/btree_gist/expected/partitions.out 2024-03-19 15:41:20.182824000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/btree_gist/regress/results/partitions.out 2024-03-19 15:59:10.245575000 +0000 @@ -16,6 +16,7 @@ (11, '[2000-01-01, 2000-02-01)'), (11, '[2000-02-01, 2000-03-01)'), (12, '[2000-01-01, 2000-02-01)'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree select * from parttmp order by id, valid_at; id | valid_at ----+------------------------- diff -U3 /tmp/cirrus-ci-build/contrib/btree_gist/expected/without_overlaps.out /tmp/cirrus-ci-build/build/testrun/btree_gist/regress/results/without_overlaps.out --- /tmp/cirrus-ci-build/contrib/btree_gist/expected/without_overlaps.out 2024-03-19 15:41:20.182979000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/btree_gist/regress/results/without_overlaps.out 2024-03-19 15:59:10.290937000 +0000 @@ -9,6 +9,11 @@ CONSTRAINT temporal_rng_pk PRIMARY KEY (id, valid_at WITHOUT OVERLAPS) ); \d temporal_rng +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree Table "public.temporal_rng" Column | Type | Collation | Nullable | Default ----------+-----------+-----------+----------+---------