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

Commite72b6c3

Browse files
committed
Further improve stability of partition_prune regression test.
Commits4ea03f3 et al arranged to filter out row counts in parallelplans, because those are dependent on the number of workers actuallyobtained. Somehow I missed that the 'Rows Removed by Filter' countscan also vary, so fix that too. Per buildfarm.This seems worth a last-minute patch because unreliable regressiontests are a serious pain in the rear for packagers.Like the previous patch, back-patch to v11 where this test wasintroduced.
1 parent5b41fc1 commite72b6c3

File tree

2 files changed

+4
-2
lines changed

2 files changed

+4
-2
lines changed

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

Lines changed: 3 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -2033,6 +2033,7 @@ begin
20332033
loop
20342034
ln := regexp_replace(ln, 'Workers Launched: \d+', 'Workers Launched: N');
20352035
ln := regexp_replace(ln, 'actual rows=\d+ loops=\d+', 'actual rows=N loops=N');
2036+
ln := regexp_replace(ln, 'Rows Removed by Filter: \d+', 'Rows Removed by Filter: N');
20362037
return next ln;
20372038
end loop;
20382039
end;
@@ -2337,7 +2338,7 @@ select explain_parallel_append('select avg(ab.a) from ab inner join lprt_a a on
23372338
-> Nested Loop (actual rows=N loops=N)
23382339
-> Parallel Seq Scan on lprt_a a (actual rows=N loops=N)
23392340
Filter: (a = ANY ('{1,0,0}'::integer[]))
2340-
Rows Removed by Filter:1
2341+
Rows Removed by Filter:N
23412342
-> Append (actual rows=N loops=N)
23422343
-> Index Scan using ab_a1_b1_a_idx on ab_a1_b1 (actual rows=N loops=N)
23432344
Index Cond: (a = a.a)
@@ -2371,7 +2372,7 @@ select explain_parallel_append('select avg(ab.a) from ab inner join lprt_a a on
23712372
-> Nested Loop (actual rows=N loops=N)
23722373
-> Parallel Seq Scan on lprt_a a (actual rows=N loops=N)
23732374
Filter: (a = ANY ('{1,0,0}'::integer[]))
2374-
Rows Removed by Filter:1
2375+
Rows Removed by Filter:N
23752376
-> Append (actual rows=N loops=N)
23762377
-> Index Scan using ab_a1_b1_a_idx on ab_a1_b1 (never executed)
23772378
Index Cond: (a = a.a)

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

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -467,6 +467,7 @@ begin
467467
loop
468468
ln := regexp_replace(ln,'Workers Launched:\d+','Workers Launched: N');
469469
ln := regexp_replace(ln,'actual rows=\d+ loops=\d+','actual rows=N loops=N');
470+
ln := regexp_replace(ln,'Rows Removed by Filter:\d+','Rows Removed by Filter: N');
470471
return next ln;
471472
end loop;
472473
end;

0 commit comments

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