Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit22864f6

Browse files
committed
Put back regression test case in a more robust form.
This undoes my hurried commit776a2c8, restoring the removed test casein a form that passes with or without force_parallel_mode = regress.It turns out that force_parallel_mode = regress simply fails to maskthe Worker lines that will be produced by EXPLAIN (ANALYZE, VERBOSE).I'd say that's a bug in that feature, as its entire alleged reasonfor existence is to make the EXPLAIN output the same. It's certainlynot a bug in the plan node pruning logic. Fortunately, this test casedoesn't really need to use ANALYZE, so just drop that.Discussion:https://postgr.es/m/18891.1576109690@sss.pgh.pa.us
1 parent1a3efa1 commit22864f6

File tree

2 files changed

+20
-0
lines changed

2 files changed

+20
-0
lines changed

‎src/test/regress/expected/partition_prune.out

Lines changed: 13 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -3161,6 +3161,19 @@ execute mt_q1(35);
31613161
(0 rows)
31623162

31633163
deallocate mt_q1;
3164+
prepare mt_q2 (int) as select * from ma_test where a >= $1 order by b limit 1;
3165+
-- Ensure output list looks sane when the MergeAppend has no subplans.
3166+
explain (verbose, costs off) execute mt_q2 (35);
3167+
QUERY PLAN
3168+
--------------------------------
3169+
Limit
3170+
Output: ma_test.a, ma_test.b
3171+
-> Merge Append
3172+
Sort Key: ma_test.b
3173+
Subplans Removed: 3
3174+
(5 rows)
3175+
3176+
deallocate mt_q2;
31643177
-- ensure initplan params properly prune partitions
31653178
explain (analyze, costs off, summary off, timing off) select * from ma_test where a >= (select min(b) from ma_test_p2) order by b;
31663179
QUERY PLAN

‎src/test/regress/sql/partition_prune.sql

Lines changed: 7 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -838,6 +838,13 @@ execute mt_q1(35);
838838

839839
deallocate mt_q1;
840840

841+
prepare mt_q2 (int)asselect*from ma_testwhere a>= $1order by blimit1;
842+
843+
-- Ensure output list looks sane when the MergeAppend has no subplans.
844+
explain (verbose, costs off) execute mt_q2 (35);
845+
846+
deallocate mt_q2;
847+
841848
-- ensure initplan params properly prune partitions
842849
explain (analyze, costs off, summary off, timing off)select*from ma_testwhere a>= (selectmin(b)from ma_test_p2)order by b;
843850

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp