diff -U3 /tmp/cirrus-ci-build/contrib/pg_walinspect/expected/pg_walinspect.out /tmp/cirrus-ci-build/build/testrun/pg_walinspect/regress/results/pg_walinspect.out --- /tmp/cirrus-ci-build/contrib/pg_walinspect/expected/pg_walinspect.out 2024-03-26 23:35:26.174554000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_walinspect/regress/results/pg_walinspect.out 2024-03-26 23:53:41.335703000 +0000 @@ -3,6 +3,7 @@ \set VERBOSITY terse -- Make sure checkpoints don't interfere with the test. SELECT 'init' FROM pg_create_physical_replication_slot('regress_pg_walinspect_slot', true, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ?column? ---------- init @@ -12,45 +13,58 @@ -- Save some LSNs for comparisons. SELECT pg_current_wal_lsn() AS wal_lsn1 \gset INSERT INTO sample_tbl SELECT * FROM generate_series(1, 2); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree SELECT pg_current_wal_lsn() AS wal_lsn2 \gset INSERT INTO sample_tbl SELECT * FROM generate_series(3, 4); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree -- =================================================================== -- Tests for input validation -- =================================================================== -- Invalid input LSN. SELECT * FROM pg_get_wal_record_info('0/0'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ERROR: could not read WAL at LSN 0/0 -- Invalid start LSN. SELECT * FROM pg_get_wal_records_info('0/0', :'wal_lsn1'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ERROR: could not read WAL at LSN 0/0 SELECT * FROM pg_get_wal_stats('0/0', :'wal_lsn1'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ERROR: could not read WAL at LSN 0/0 SELECT * FROM pg_get_wal_block_info('0/0', :'wal_lsn1'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ERROR: could not read WAL at LSN 0/0 -- Start LSN > End LSN. SELECT * FROM pg_get_wal_records_info(:'wal_lsn2', :'wal_lsn1'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ERROR: WAL start LSN must be less than end LSN SELECT * FROM pg_get_wal_stats(:'wal_lsn2', :'wal_lsn1'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ERROR: WAL start LSN must be less than end LSN SELECT * FROM pg_get_wal_block_info(:'wal_lsn2', :'wal_lsn1'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ERROR: WAL start LSN must be less than end LSN -- LSNs with the highest value possible. SELECT * FROM pg_get_wal_record_info('FFFFFFFF/FFFFFFFF'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ERROR: WAL input LSN must be less than current LSN -- Success with end LSNs. SELECT COUNT(*) >= 1 AS ok FROM pg_get_wal_records_info(:'wal_lsn1', 'FFFFFFFF/FFFFFFFF'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ok ---- t (1 row) SELECT COUNT(*) >= 1 AS ok FROM pg_get_wal_stats(:'wal_lsn1', 'FFFFFFFF/FFFFFFFF'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ok ---- t (1 row) SELECT COUNT(*) >= 1 AS ok FROM pg_get_wal_block_info(:'wal_lsn1', 'FFFFFFFF/FFFFFFFF'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ok ---- t @@ -58,33 +72,40 @@ -- Failures with start LSNs. SELECT * FROM pg_get_wal_records_info('FFFFFFFF/FFFFFFFE', 'FFFFFFFF/FFFFFFFF'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ERROR: WAL start LSN must be less than current LSN SELECT * FROM pg_get_wal_stats('FFFFFFFF/FFFFFFFE', 'FFFFFFFF/FFFFFFFF'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ERROR: WAL start LSN must be less than current LSN SELECT * FROM pg_get_wal_block_info('FFFFFFFF/FFFFFFFE', 'FFFFFFFF/FFFFFFFF'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ERROR: WAL start LSN must be less than current LSN -- =================================================================== -- Tests for all function executions -- =================================================================== SELECT COUNT(*) >= 1 AS ok FROM pg_get_wal_record_info(:'wal_lsn1'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ok ---- t (1 row) SELECT COUNT(*) >= 1 AS ok FROM pg_get_wal_records_info(:'wal_lsn1', :'wal_lsn2'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ok ---- t (1 row) SELECT COUNT(*) >= 1 AS ok FROM pg_get_wal_stats(:'wal_lsn1', :'wal_lsn2'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ok ---- t (1 row) SELECT COUNT(*) >= 1 AS ok FROM pg_get_wal_block_info(:'wal_lsn1', :'wal_lsn2'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ok ---- t @@ -96,6 +117,7 @@ SELECT oid AS sample_tbl_oid FROM pg_class WHERE relname = 'sample_tbl' \gset SELECT COUNT(*) >= 1 AS ok FROM pg_get_wal_records_info(:'wal_lsn1', :'wal_lsn2') WHERE block_ref LIKE concat('%', :'sample_tbl_oid', '%') AND resource_manager = 'Heap'; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ok ---- t @@ -107,6 +129,7 @@ -- =================================================================== SELECT COUNT(*) >= 1 AS ok FROM pg_get_wal_records_info(:'wal_lsn1', :'wal_lsn2') WHERE resource_manager = 'Heap' AND record_type = 'INSERT'; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ok ---- t @@ -122,6 +145,7 @@ -- Check if we get block data from WAL record. SELECT COUNT(*) >= 1 AS ok FROM pg_get_wal_block_info(:'wal_lsn3', :'wal_lsn4') WHERE relfilenode = :'sample_tbl_oid' AND block_data IS NOT NULL; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ok ---- t @@ -133,8 +157,10 @@ -- Verify that an XLOG_CHECKPOINT_REDO record begins at precisely the redo LSN -- of the checkpoint we just performed. SELECT redo_lsn FROM pg_control_checkpoint() \gset +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree SELECT start_lsn = :'redo_lsn'::pg_lsn AS same_lsn, resource_manager, record_type FROM pg_get_wal_record_info(:'redo_lsn'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree same_lsn | resource_manager | record_type ----------+------------------+----------------- t | XLOG | CHECKPOINT_REDO @@ -146,6 +172,7 @@ -- Check if we get FPI from WAL record. SELECT COUNT(*) >= 1 AS ok FROM pg_get_wal_block_info(:'wal_lsn5', :'wal_lsn6') WHERE relfilenode = :'sample_tbl_oid' AND block_fpi_data IS NOT NULL; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ok ---- t diff -U3 /tmp/cirrus-ci-build/contrib/pg_walinspect/expected/oldextversions.out /tmp/cirrus-ci-build/build/testrun/pg_walinspect/regress/results/oldextversions.out --- /tmp/cirrus-ci-build/contrib/pg_walinspect/expected/oldextversions.out 2024-03-26 23:35:26.174435000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_walinspect/regress/results/oldextversions.out 2024-03-26 23:53:41.366191000 +0000 @@ -20,6 +20,7 @@ -- Make sure checkpoints don't interfere with the test. SELECT 'init' FROM pg_create_physical_replication_slot('regress_pg_walinspect_slot', true, false); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ?column? ---------- init @@ -28,14 +29,17 @@ CREATE TABLE sample_tbl(col1 int, col2 int); SELECT pg_current_wal_lsn() AS wal_lsn1 \gset INSERT INTO sample_tbl SELECT * FROM generate_series(1, 2); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree -- Tests for the past functions. SELECT COUNT(*) >= 1 AS ok FROM pg_get_wal_records_info_till_end_of_wal(:'wal_lsn1'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ok ---- t (1 row) SELECT COUNT(*) >= 1 AS ok FROM pg_get_wal_stats_till_end_of_wal(:'wal_lsn1'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ok ---- t @@ -43,8 +47,10 @@ -- Failures with start LSNs. SELECT * FROM pg_get_wal_records_info_till_end_of_wal('FFFFFFFF/FFFFFFFF'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ERROR: WAL start LSN must be less than current LSN SELECT * FROM pg_get_wal_stats_till_end_of_wal('FFFFFFFF/FFFFFFFF'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ERROR: WAL start LSN must be less than current LSN -- Move to new version 1.1. ALTER EXTENSION pg_walinspect UPDATE TO '1.1';