postgres.git / summary / log / commit / refs

commit    bc2ebf3acfd287247cd9ee286c44e969af1c81de
Author:   Fujii Masao <fujii@postgresql.org>
Date:     Fri Aug 21 16:22:55 2020 +0000
First released in: 14.0, 13.0

    Fix explain regression test failure.
    
    Commit 9d701e624f caused the regression test for EXPLAIN to fail on
    the buildfarm member prion. This happened because of instability of
    test output, i.e., in text format, whether "Planning:" line is output
    varies depending on the system state.
    
    This commit updated the regression test so that it ignores that
    "Planning:" line to produce more stable test output and get rid of
    the test failure.
    
    Back-patch to v13.
    
    Author: Fujii Masao
    Discussion: https://postgr.es/m/1803897.1598021621@sss.pgh.pa.us


 src/test/regress/expected/explain.out | 3 +++
 src/test/regress/sql/explain.sql      | 3 +++
 2 files changed, 6 insertions(+)

diff --git a/src/test/regress/expected/explain.out b/src/test/regress/expected/explain.out
index a1ee6c67925..dc7ab2ce8bf 100644
--- a/src/test/regress/expected/explain.out
+++ b/src/test/regress/expected/explain.out
@@ -23,6 +23,9 @@ begin
         -- Ignore text-mode buffers output because it varies depending
         -- on the system state
         CONTINUE WHEN (ln ~ ' +Buffers: .*');
+        -- Ignore text-mode "Planning:" line because whether it's output
+        -- varies depending on the system state
+        CONTINUE WHEN (ln = 'Planning:');
         return next ln;
     end loop;
 end;
diff --git a/src/test/regress/sql/explain.sql b/src/test/regress/sql/explain.sql
index 01783c607aa..c79116c927b 100644
--- a/src/test/regress/sql/explain.sql
+++ b/src/test/regress/sql/explain.sql
@@ -25,6 +25,9 @@ begin
         -- Ignore text-mode buffers output because it varies depending
         -- on the system state
         CONTINUE WHEN (ln ~ ' +Buffers: .*');
+        -- Ignore text-mode "Planning:" line because whether it's output
+        -- varies depending on the system state
+        CONTINUE WHEN (ln = 'Planning:');
         return next ln;
     end loop;
 end;


[parent: 674899ae02c3]