pg_stat_monitor icon indicating copy to clipboard operation
pg_stat_monitor copied to clipboard

partition_prune testcase fails in pgcheck while running installcheck-world with PGSM loaded into server.

Open Naeem-Akhter opened this issue 1 year ago • 0 comments

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`

Naeem-Akhter avatar Sep 12 '23 16:09 Naeem-Akhter