diff -U3 /tmp/cirrus-ci-build/contrib/hstore/expected/hstore.out /tmp/cirrus-ci-build/build/testrun/hstore/regress/results/hstore.out --- /tmp/cirrus-ci-build/contrib/hstore/expected/hstore.out 2024-03-26 23:35:26.132413000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/hstore/regress/results/hstore.out 2024-03-26 23:53:28.936487000 +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) @@ -266,12 +267,14 @@ (1 row) select * from pg_input_error_info('a=b', 'hstore'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree message | detail | hint | sql_error_code ------------------------------------------------+--------+------+---------------- syntax error in hstore, near "b" at position 2 | | | 42601 (1 row) select * from pg_input_error_info(' =>b', 'hstore'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree message | detail | hint | sql_error_code ------------------------------------------------+--------+------+---------------- syntax error in hstore, near "=" at position 1 | | | 42601 @@ -949,6 +952,7 @@ -- records select hstore(v) from (values (1, 'foo', 1.2, 3::float8)) v(a,b,c,d); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree hstore -------------------------------------------- "a"=>"1", "b"=>"foo", "c"=>"1.2", "d"=>"3" @@ -1126,6 +1130,7 @@ select null::testhstore1 #= hstore ''; ERROR: domain hstestdom1 does not allow null values select v #= h from testhstore1 v, (values (hstore 'a=>123',1),('b=>foo,c=>3.21',2),('a=>null',3),('e=>123',4),('f=>blah',5)) x(h,i) order by i; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ?column? ------------------- (123,foo,1.2,3,0) @@ -1203,6 +1208,7 @@ (1 row) select * from skeys('aa=>1 , b=>2, cq=>3'::hstore || 'cq=>l, b=>g, fg=>f'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree skeys ------- b @@ -1212,17 +1218,20 @@ (4 rows) select * from skeys('""=>1'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree skeys ------- (1 row) select * from skeys(''); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree skeys ------- (0 rows) select * from svals('aa=>1 , b=>2, cq=>3'::hstore || 'cq=>l, b=>g, fg=>f'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree svals ------- g @@ -1232,6 +1241,7 @@ (4 rows) select *, svals is null from svals('aa=>1 , b=>2, cq=>3'::hstore || 'cq=>l, b=>g, fg=>NULL'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree svals | ?column? -------+---------- g | f @@ -1241,17 +1251,20 @@ (4 rows) select * from svals('""=>1'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree svals ------- 1 (1 row) select * from svals(''); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree svals ------- (0 rows) select * from each('aaa=>bq, b=>NULL, ""=>1 '); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree key | value -----+------- | 1 @@ -1463,12 +1476,14 @@ (1 row) select count(*) from (select (each(h)).key from testhstore) as wow ; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree count ------- 4781 (1 row) select key, count(*) from (select (each(h)).key from testhstore) as wow group by key order by count desc, key; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree key | count -----------+------- line | 884 @@ -1504,6 +1519,7 @@ set enable_hashagg = false; select count(*) from (select h from (select * from testhstore union all select * from testhstore) hs group by h) hs2; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree count ------- 885 @@ -1512,12 +1528,14 @@ set enable_hashagg = true; set enable_sort = false; select count(*) from (select h from (select * from testhstore union all select * from testhstore) hs group by h) hs2; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree count ------- 885 (1 row) select distinct * from (values (hstore '' || ''),('')) v(h); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree h --- @@ -1580,6 +1598,7 @@ create table test_json_agg (f1 text, f2 hstore); insert into test_json_agg values ('rec1','"a key" =>1, b => t, c => null, d=> 12345, e => 012345, f=> 1.234, g=> 2.345e+4'), ('rec2','"a key" =>2, b => f, c => "null", d=> -12345, e => 012345.6, f=> -1.234, g=> 0.345e-4'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree select json_agg(q) from test_json_agg q; json_agg ---------------------------------------------------------------------------------------------------------------------------- @@ -1588,6 +1607,7 @@ (1 row) select json_agg(q) from (select f1, hstore_to_json_loose(f2) as f2 from test_json_agg) q; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree json_agg ---------------------------------------------------------------------------------------------------------------------- [{"f1":"rec1","f2":{"b": true, "c": null, "d": 12345, "e": "012345", "f": 1.234, "g": 2.345e+4, "a key": 1}}, + @@ -1629,6 +1649,7 @@ ('e => 012345'), ('g => 2.345e+4')) x(v) WHERE hstore_hash(v)::bit(32) != hstore_hash_extended(v, 0)::bit(32) OR hstore_hash(v)::bit(32) = hstore_hash_extended(v, 1)::bit(32); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree value | standard | extended0 | extended1 -------+----------+-----------+----------- (0 rows)