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-27 22:35:12.728469000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/btree_gist/regress/results/init.out 2024-03-27 22:53:04.874045000 +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-27 22:35:12.729011000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/btree_gist/regress/results/oid.out 2024-03-27 22:53:05.042444000 +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-27 22:35:12.729862000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/btree_gist/regress/results/timetz.out 2024-03-27 22:53:05.149943000 +0000 @@ -4,40 +4,85 @@ 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 +ERROR: could not find junk ctid1 column 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 +ERROR: could not find junk ctid1 column 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 +ERROR: could not find junk ctid1 column 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 +ERROR: could not find junk ctid1 column 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 +ERROR: could not find junk ctid1 column 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 +ERROR: could not find junk ctid1 column 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 +ERROR: could not find junk ctid1 column 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 +ERROR: could not find junk ctid1 column 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 +ERROR: could not find junk ctid1 column 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 +ERROR: could not find junk ctid1 column 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 +ERROR: could not find junk ctid1 column 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 +ERROR: could not find junk ctid1 column 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 +ERROR: could not find junk ctid1 column 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 +ERROR: could not find junk ctid1 column 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 +ERROR: could not find junk ctid1 column SELECT count(*) FROM timetzcmp WHERE a=b; count ------- - 15 + 0 (1 row) 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-27 22:35:12.728902000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/btree_gist/regress/results/not_equal.out 2024-03-27 22:53:05.571042000 +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-27 22:35:12.727672000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/btree_gist/regress/results/bool.out 2024-03-27 22:53:05.624430000 +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-27 22:35:12.729076000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/btree_gist/regress/results/partitions.out 2024-03-27 22:53:05.661827000 +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-27 22:35:12.730621000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/btree_gist/regress/results/without_overlaps.out 2024-03-27 22:53:05.740455000 +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 ----------+-----------+-----------+----------+--------- @@ -52,6 +57,13 @@ REFERENCES temporal_rng (id, PERIOD valid_at) ); \d temporal_fk_rng2rng +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 +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_fk_rng2rng" Column | Type | Collation | Nullable | Default -----------+-----------+-----------+----------+--------- @@ -72,6 +84,7 @@ -- okay INSERT INTO temporal_fk_rng2rng VALUES (1, '[2000-01-01,2001-01-01)', 1); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree -- okay spanning two parent records: INSERT INTO temporal_fk_rng2rng VALUES (2, '[2000-01-01,2002-01-01)', 1);