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

Commit064e029

Browse files
committed
Fix test case instability introduced in085b6b6.
I forgot that the WAL directory might hold other files besides WALsegments, notably including new segments still being filled.That means a blind test for the first file's size being 16MB canfail. Restrict based on file name length to make it more robust.Per buildfarm.
1 parentd04e342 commit064e029

File tree

2 files changed

+4
-2
lines changed

2 files changed

+4
-2
lines changed

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

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -170,7 +170,8 @@ select count(*) > 0 as ok from (select * from pg_ls_waldir() limit 1) ss;
170170
t
171171
(1 row)
172172

173-
select (pg_ls_waldir()).size = :segbsize * :bsize as ok limit 1;
173+
select (w).size = :segbsize * :bsize as ok
174+
from (select pg_ls_waldir() w) ss where length((w).name) = 24 limit 1;
174175
ok
175176
----
176177
t

‎src/test/regress/sql/misc_functions.sql

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -49,4 +49,5 @@ select count(*) > 0 as ok from (select pg_ls_waldir()) ss;
4949
-- Test not-run-to-completion cases.
5050
select*from pg_ls_waldir()limit0;
5151
selectcount(*)>0as okfrom (select*from pg_ls_waldir()limit1) ss;
52-
select (pg_ls_waldir()).size= :segbsize* :bsizeas oklimit1;
52+
select (w).size= :segbsize* :bsizeas ok
53+
from (select pg_ls_waldir() w) sswhere length((w).name)=24limit1;

0 commit comments

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