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-19 00:05:10.415933000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/create_extension.out 2024-03-19 00:23:06.437979000 +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-19 00:05:10.415960000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/create_schema.out 2024-03-19 00:23:06.456734000 +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-19 00:05:10.416015000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/create_type.out 2024-03-19 00:23:06.474781000 +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-19 00:05:10.415917000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/create_conversion.out 2024-03-19 00:23:06.488185000 +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-19 00:05:10.415925000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/create_domain.out 2024-03-19 00:23:06.503111000 +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-19 00:05:10.415968000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/create_sequence_1.out 2024-03-19 00:23:06.515194000 +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-19 00:05:10.415977000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/create_table.out 2024-03-19 00:23:06.571361000 +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-19 00:05:10.415997000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/create_transform.out 2024-03-19 00:23:06.585224000 +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-19 00:05:10.415885000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/alter_table.out 2024-03-19 00:23:06.659082000 +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-19 00:05:10.416024000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/create_view.out 2024-03-19 00:23:06.677521000 +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-19 00:05:10.416006000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/create_trigger.out 2024-03-19 00:23:06.691337000 +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-19 00:05:10.415952000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/create_rule.out 2024-03-19 00:23:06.705828000 +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-19 00:05:10.415909000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/comment_on.out 2024-03-19 00:23:06.720307000 +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-19 00:05:10.415868000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/alter_function.out 2024-03-19 00:23:06.734946000 +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-19 00:05:10.415876000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/alter_sequence.out 2024-03-19 00:23:06.747037000 +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-19 00:05:10.415893000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/alter_ts_config.out 2024-03-19 00:23:06.758229000 +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-19 00:05:10.415901000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/alter_type_enum.out 2024-03-19 00:23:06.769698000 +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-19 00:05:10.416050000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/opfamily.out 2024-03-19 00:23:06.792392000 +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-19 00:05:10.416033000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/defprivs.out 2024-03-19 00:23:06.802468000 +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-19 00:05:10.416041000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_ddl_deparse/regress/results/matviews.out 2024-03-19 00:23:06.822970000 +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