Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Closed
Naeem-Akhter opened this issue Sep 12, 2023 · 0 comments · Fixed by #440
Assignees

Comments

@Naeem-Akhter
Copy link
Contributor

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`

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

4 participants