pgsql: Fix the unstable output of tests added by commit 8fccf75834.

From: Amit Kapila <akapila(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Fix the unstable output of tests added by commit 8fccf75834.
Date: 2020-10-13 07:26:47
Message-ID: E1kSEhr-0007Ya-7J@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Fix the unstable output of tests added by commit 8fccf75834.

The test cases added by that commit were trying to test the exact number of
times a particular transaction has spilled. However, that number can vary if
any background transaction (say by autovacuum) happens in parallel to the main
transaction. So let's not try to verify the exact count.

Author: Amit Kapila
Reviewed-by: Sawada Masahiko
Discussion: https://postgr.es/m/CA+fd4k5_pPAYRTDrO2PbtTOe0eHQpBvuqmCr8ic39uTNmR49Eg@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/2050832d0d637358a376a99514071941aa93ed31

Modified Files
--------------
contrib/test_decoding/expected/stats.out | 20 +++++++++++---------
contrib/test_decoding/sql/stats.sql | 12 +++++++-----
2 files changed, 18 insertions(+), 14 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Heikki Linnakangas 2020-10-13 10:08:27 pgsql: Create ResultRelInfos later in InitPlan, index them by RT index.
Previous Message Peter Eisentraut 2020-10-13 05:02:26 pgsql: doc: Expand recursive query documentation