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

Commit95a8394

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 parentc1646c8 commit95a8394

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
@@ -1992,6 +1992,7 @@ begin
19921992
loop
19931993
ln := regexp_replace(ln, 'Workers Launched: \d+', 'Workers Launched: N');
19941994
ln := regexp_replace(ln, 'actual rows=\d+ loops=\d+', 'actual rows=N loops=N');
1995+
ln := regexp_replace(ln, 'Rows Removed by Filter: \d+', 'Rows Removed by Filter: N');
19951996
return next ln;
19961997
end loop;
19971998
end;
@@ -2296,7 +2297,7 @@ select explain_parallel_append('select avg(ab.a) from ab inner join lprt_a a on
22962297
-> Nested Loop (actual rows=N loops=N)
22972298
-> Parallel Seq Scan on lprt_a a (actual rows=N loops=N)
22982299
Filter: (a = ANY ('{1,0,0}'::integer[]))
2299-
Rows Removed by Filter:1
2300+
Rows Removed by Filter:N
23002301
-> Append (actual rows=N loops=N)
23012302
-> Index Scan using ab_a1_b1_a_idx on ab_a1_b1 (actual rows=N loops=N)
23022303
Index Cond: (a = a.a)
@@ -2330,7 +2331,7 @@ select explain_parallel_append('select avg(ab.a) from ab inner join lprt_a a on
23302331
-> Nested Loop (actual rows=N loops=N)
23312332
-> Parallel Seq Scan on lprt_a a (actual rows=N loops=N)
23322333
Filter: (a = ANY ('{1,0,0}'::integer[]))
2333-
Rows Removed by Filter:1
2334+
Rows Removed by Filter:N
23342335
-> Append (actual rows=N loops=N)
23352336
-> Index Scan using ab_a1_b1_a_idx on ab_a1_b1 (never executed)
23362337
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