diff -U3 /tmp/cirrus-ci-build/contrib/tsm_system_time/expected/tsm_system_time.out /tmp/cirrus-ci-build/build/testrun/tsm_system_time/regress/results/tsm_system_time.out --- /tmp/cirrus-ci-build/contrib/tsm_system_time/expected/tsm_system_time.out 2024-03-19 15:41:20.194690000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/tsm_system_time/regress/results/tsm_system_time.out 2024-03-19 15:59:40.833309000 +0000 @@ -2,6 +2,7 @@ CREATE TABLE test_tablesample (id int, name text); INSERT INTO test_tablesample SELECT i, repeat(i::text, 1000) FROM generate_series(0, 30) s(i); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ANALYZE test_tablesample; -- It's a bit tricky to test SYSTEM_TIME in a platform-independent way. -- We can test the zero-time corner case ... @@ -40,6 +41,7 @@ (VALUES (0),(100000)) v(time), LATERAL (SELECT COUNT(*) FROM test_tablesample TABLESAMPLE system_time (100000)) ss; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree QUERY PLAN ------------------------------------------------------------------------ Nested Loop @@ -54,6 +56,7 @@ (VALUES (0),(100000)) v(time), LATERAL (SELECT COUNT(*) FROM test_tablesample TABLESAMPLE system_time (100000)) ss; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree time | count --------+------- 0 | 31 @@ -65,6 +68,7 @@ (VALUES (0),(100000)) v(time), LATERAL (SELECT COUNT(*) FROM test_tablesample TABLESAMPLE system_time (time)) ss; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree QUERY PLAN ---------------------------------------------------------------- Nested Loop @@ -79,6 +83,7 @@ (VALUES (0),(100000)) v(time), LATERAL (SELECT COUNT(*) FROM test_tablesample TABLESAMPLE system_time (time)) ss; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree time | count --------+------- 0 | 0