diff -U3 /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/create_extension.out /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/create_extension.out --- /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/create_extension.out 2024-03-27 22:35:14.247770000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/create_extension.out 2024-03-27 22:53:42.564770000 +0000 @@ -2,4 +2,5 @@ --- CREATE_EXTENSION --- CREATE EXTENSION pg_stat_statements; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree NOTICE: DDL test: type simple, tag CREATE EXTENSION diff -U3 /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/create_schema.out /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/create_schema.out --- /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/create_schema.out 2024-03-27 22:35:14.247904000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/create_schema.out 2024-03-27 22:53:42.583870000 +0000 @@ -2,18 +2,23 @@ -- CREATE_SCHEMA -- CREATE SCHEMA foo; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree NOTICE: DDL test: type simple, tag CREATE SCHEMA CREATE SCHEMA IF NOT EXISTS bar; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree NOTICE: DDL test: type simple, tag CREATE SCHEMA CREATE SCHEMA baz; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree NOTICE: DDL test: type simple, tag CREATE SCHEMA -- Will not be created, and will not be handled by the -- event trigger CREATE SCHEMA IF NOT EXISTS baz; NOTICE: schema "baz" already exists, skipping +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree CREATE SCHEMA element_test CREATE TABLE foo (id int) CREATE VIEW bar AS SELECT * FROM foo; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree NOTICE: DDL test: type simple, tag CREATE SCHEMA NOTICE: DDL test: type simple, tag CREATE TABLE NOTICE: DDL test: type simple, tag CREATE VIEW diff -U3 /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/create_type.out /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/create_type.out --- /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/create_type.out 2024-03-27 22:35:14.248204000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/create_type.out 2024-03-27 22:53:42.604757000 +0000 @@ -7,6 +7,7 @@ LANGUAGE internal STABLE STRICT; NOTICE: type "text_w_default" is not yet defined DETAIL: Creating a shell type definition. +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree NOTICE: DDL test: type simple, tag CREATE FUNCTION CREATE FUNCTION text_w_default_out(text_w_default) RETURNS cstring diff -U3 /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/create_conversion.out /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/create_conversion.out --- /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/create_conversion.out 2024-03-27 22:35:14.247689000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/create_conversion.out 2024-03-27 22:53:42.619761000 +0000 @@ -3,4 +3,5 @@ --- -- Simple test should suffice for this CREATE CONVERSION myconv FOR 'LATIN1' TO 'UTF8' FROM iso8859_1_to_utf8; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree NOTICE: DDL test: type simple, tag CREATE CONVERSION diff -U3 /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/create_domain.out /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/create_domain.out --- /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/create_domain.out 2024-03-27 22:35:14.247733000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/create_domain.out 2024-03-27 22:53:42.634514000 +0000 @@ -2,6 +2,7 @@ --- CREATE_DOMAIN --- CREATE DOMAIN domainvarchar VARCHAR(5); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree NOTICE: DDL test: type simple, tag CREATE DOMAIN CREATE DOMAIN japanese_postal_code AS TEXT CHECK( diff -U3 /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/create_sequence_1.out /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/create_sequence_1.out --- /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/create_sequence_1.out 2024-03-27 22:35:14.247946000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/create_sequence_1.out 2024-03-27 22:53:42.649830000 +0000 @@ -8,4 +8,5 @@ START 10 CACHE 10 CYCLE; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree NOTICE: DDL test: type simple, tag CREATE SEQUENCE diff -U3 /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/create_table.out /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/create_table.out --- /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/create_table.out 2024-03-27 22:35:14.248056000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/create_table.out 2024-03-27 22:53:42.713359000 +0000 @@ -50,11 +50,13 @@ PRIMARY KEY (id), UNIQUE (id_big) ); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree NOTICE: DDL test: type simple, tag CREATE SEQUENCE NOTICE: DDL test: type simple, tag CREATE SEQUENCE NOTICE: DDL test: type simple, tag CREATE SEQUENCE NOTICE: DDL test: type simple, tag CREATE TABLE NOTICE: DDL test: type alter table, tag ALTER TABLE +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree NOTICE: subcommand: type SET ATTNOTNULL desc NOTICE: DDL test: type simple, tag CREATE INDEX NOTICE: DDL test: type simple, tag CREATE INDEX @@ -166,16 +168,20 @@ CREATE TEMP TABLE temp_table ( id INT PRIMARY KEY ); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree NOTICE: DDL test: type simple, tag CREATE TABLE NOTICE: DDL test: type alter table, tag ALTER TABLE +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree NOTICE: subcommand: type SET ATTNOTNULL desc NOTICE: DDL test: type simple, tag CREATE INDEX CREATE TEMP TABLE temp_table_commit_delete ( id INT PRIMARY KEY ) ON COMMIT DELETE ROWS; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree NOTICE: DDL test: type simple, tag CREATE TABLE NOTICE: DDL test: type alter table, tag ALTER TABLE +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree NOTICE: subcommand: type SET ATTNOTNULL desc NOTICE: DDL test: type simple, tag CREATE INDEX CREATE TEMP TABLE temp_table_commit_drop ( diff -U3 /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/create_transform.out /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/create_transform.out --- /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/create_transform.out 2024-03-27 22:35:14.248107000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/create_transform.out 2024-03-27 22:53:42.728043000 +0000 @@ -11,5 +11,6 @@ CREATE TRANSFORM FOR int LANGUAGE SQL ( FROM SQL WITH FUNCTION prsd_lextype(internal), TO SQL WITH FUNCTION int4recv(internal)); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree NOTICE: DDL test: type simple, tag CREATE TRANSFORM DROP TRANSFORM FOR int LANGUAGE SQL; diff -U3 /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/alter_table.out /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/alter_table.out --- /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/alter_table.out 2024-03-27 22:35:14.247488000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/alter_table.out 2024-03-27 22:53:42.806950000 +0000 @@ -1,9 +1,11 @@ CREATE TABLE parent ( a int ); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree NOTICE: DDL test: type simple, tag CREATE TABLE ALTER TABLE parent SET (fillfactor = 50); NOTICE: DDL test: type alter table, tag ALTER TABLE +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree NOTICE: subcommand: type SET RELOPTIONS desc ALTER TABLE parent RESET (fillfactor); NOTICE: DDL test: type alter table, tag ALTER TABLE diff -U3 /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/create_view.out /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/create_view.out --- /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/create_view.out 2024-03-27 22:35:14.248251000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/create_view.out 2024-03-27 22:53:42.826394000 +0000 @@ -3,11 +3,13 @@ -- CREATE VIEW static_view AS SELECT 'foo'::TEXT AS col; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree NOTICE: DDL test: type simple, tag CREATE VIEW CREATE OR REPLACE VIEW static_view AS SELECT 'bar'::TEXT AS col; NOTICE: DDL test: type simple, tag CREATE VIEW NOTICE: DDL test: type alter table, tag CREATE VIEW +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree NOTICE: subcommand: type REPLACE RELOPTIONS desc CREATE VIEW datatype_view AS SELECT * FROM datatype_table; diff -U3 /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/create_trigger.out /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/create_trigger.out --- /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/create_trigger.out 2024-03-27 22:35:14.248152000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/create_trigger.out 2024-03-27 22:53:42.839615000 +0000 @@ -9,6 +9,7 @@ RETURN NEW; END; $$; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree NOTICE: DDL test: type simple, tag CREATE FUNCTION CREATE TRIGGER trigger_1 BEFORE INSERT OR UPDATE diff -U3 /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/create_rule.out /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/create_rule.out --- /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/create_rule.out 2024-03-27 22:35:14.247855000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/create_rule.out 2024-03-27 22:53:42.854315000 +0000 @@ -7,6 +7,7 @@ ON INSERT TO datatype_table DO NOTHING; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree NOTICE: DDL test: type simple, tag CREATE RULE CREATE RULE rule_2 AS ON UPDATE diff -U3 /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/comment_on.out /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/comment_on.out --- /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/comment_on.out 2024-03-27 22:35:14.247644000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/comment_on.out 2024-03-27 22:53:42.868993000 +0000 @@ -2,6 +2,7 @@ -- COMMENT_ON -- COMMENT ON SCHEMA foo IS 'This is schema foo'; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree NOTICE: DDL test: type simple, tag COMMENT COMMENT ON TYPE enum_test IS 'ENUM test'; NOTICE: DDL test: type simple, tag COMMENT diff -U3 /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/alter_function.out /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/alter_function.out --- /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/alter_function.out 2024-03-27 22:35:14.247332000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/alter_function.out 2024-03-27 22:53:42.883747000 +0000 @@ -3,6 +3,7 @@ -- ALTER FUNCTION plpgsql_function_trigger_1 () SET SCHEMA foo; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree NOTICE: DDL test: type simple, tag ALTER FUNCTION ALTER FUNCTION foo.plpgsql_function_trigger_1() COST 10; diff -U3 /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/alter_sequence.out /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/alter_sequence.out --- /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/alter_sequence.out 2024-03-27 22:35:14.247383000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/alter_sequence.out 2024-03-27 22:53:42.906116000 +0000 @@ -6,6 +6,7 @@ START 20 CACHE 1 NO CYCLE; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree NOTICE: DDL test: type simple, tag ALTER SEQUENCE ALTER SEQUENCE fkey_table_seq RENAME TO fkey_table_seq_renamed; diff -U3 /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/alter_ts_config.out /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/alter_ts_config.out --- /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/alter_ts_config.out 2024-03-27 22:35:14.247545000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/alter_ts_config.out 2024-03-27 22:53:42.924090000 +0000 @@ -2,6 +2,7 @@ -- ALTER TEXT SEARCH CONFIGURATION -- CREATE TEXT SEARCH CONFIGURATION en (copy=english); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree NOTICE: DDL test: type simple, tag CREATE TEXT SEARCH CONFIGURATION ALTER TEXT SEARCH CONFIGURATION en ALTER MAPPING FOR host, email, url, sfloat WITH simple; diff -U3 /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/alter_type_enum.out /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/alter_type_enum.out --- /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/alter_type_enum.out 2024-03-27 22:35:14.247583000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/alter_type_enum.out 2024-03-27 22:53:42.938883000 +0000 @@ -2,6 +2,7 @@ --- ALTER_TYPE_ENUM --- ALTER TYPE enum_test ADD VALUE 'zzz' AFTER 'baz'; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree NOTICE: DDL test: type simple, tag ALTER TYPE ALTER TYPE enum_test ADD VALUE 'aaa' BEFORE 'foo'; NOTICE: DDL test: type simple, tag ALTER TYPE diff -U3 /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/opfamily.out /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/opfamily.out --- /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/opfamily.out 2024-03-27 22:35:14.248404000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/opfamily.out 2024-03-27 22:53:42.964441000 +0000 @@ -1,5 +1,6 @@ -- copied from equivclass.sql create type int8alias1; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree NOTICE: DDL test: type simple, tag CREATE TYPE create function int8alias1in(cstring) returns int8alias1 strict immutable language internal as 'int8in'; @@ -49,20 +50,25 @@ restrict = eqsel, join = eqjoinsel, merges ); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree NOTICE: DDL test: type simple, tag CREATE OPERATOR alter operator family integer_ops using btree add operator 3 = (int8alias1, int8alias1); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree NOTICE: DDL test: type alter operator family, tag ALTER OPERATOR FAMILY -- copied from alter_table.sql create type ctype as (f1 int, f2 text); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree NOTICE: DDL test: type simple, tag CREATE TYPE create function same(ctype, ctype) returns boolean language sql as 'select $1.f1 is not distinct from $2.f1 and $1.f2 is not distinct from $2.f2'; NOTICE: DDL test: type simple, tag CREATE FUNCTION create operator =(procedure = same, leftarg = ctype, rightarg = ctype); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree NOTICE: DDL test: type simple, tag CREATE OPERATOR create operator class ctype_hash_ops default for type ctype using hash as operator 1 =(ctype, ctype); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree NOTICE: DDL test: type simple, tag CREATE OPERATOR FAMILY NOTICE: DDL test: type create operator class, tag CREATE OPERATOR CLASS diff -U3 /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/defprivs.out /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/defprivs.out --- /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/defprivs.out 2024-03-27 22:35:14.248295000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/defprivs.out 2024-03-27 22:53:42.977999000 +0000 @@ -3,4 +3,5 @@ -- ALTER DEFAULT PRIVILEGES IN SCHEMA public REVOKE ALL PRIVILEGES ON TABLES FROM public; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree NOTICE: DDL test: type alter default privileges, tag ALTER DEFAULT PRIVILEGES diff -U3 /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/matviews.out /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/matviews.out --- /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/matviews.out 2024-03-27 22:35:14.248337000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/matviews.out 2024-03-27 22:53:43.001622000 +0000 @@ -3,6 +3,7 @@ -- CREATE MATERIALIZED VIEW ddl_deparse_mv AS SELECT * FROM datatype_table LIMIT 1 WITH NO DATA; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree NOTICE: DDL test: type simple, tag CREATE MATERIALIZED VIEW REFRESH MATERIALIZED VIEW ddl_deparse_mv; NOTICE: DDL test: type simple, tag REFRESH MATERIALIZED VIEW