pg_stat_monitor
pg_stat_monitor copied to clipboard
partition_prune testcase fails in pgcheck while running installcheck-world with PGSM loaded into server.
With 'compute_query_id=off' and PGSM library loaded into the server, if one runs the installcheck-world on the server following server (pgcheck) test case fails. This is reproducible on PG-14, 15 & 16 while using PGSM main branch todate.
`diff -U3 /home/runner/work/pg_stat_monitor/pg_stat_monitor/src/test/regress/expected/partition_prune.out /home/runner/work/pg_stat_monitor/pg_stat_monitor/src/test/regress/results/partition_prune.out --- /home/runner/work/pg_stat_monitor/pg_stat_monitor/src/test/regress/expected/partition_prune.out 2023-09-12 09:38:07.134813167 +0000 +++ /home/runner/work/pg_stat_monitor/pg_stat_monitor/src/test/regress/results/partition_prune.out 2023-09-12 09:54:02.387744909 +0000 @@ -3358,7 +3358,8 @@ -> Merge Append (actual rows=0 loops=1) Sort Key: ma_test.b Subplans Removed: 3 -(5 rows)
- Query Identifier: 1 +(6 rows)
deallocate mt_q2; -- ensure initplan params properly prune partitions`