From: | Michael Paquier <michael(at)paquier(dot)xyz> |
---|---|
To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
Subject: | pgsql: Fix random regression failure in test case "temp" |
Date: | 2019-08-13 01:57:19 |
Message-ID: | E1hxM3r-000854-KO@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Fix random regression failure in test case "temp"
This test case could fail because of an incorrect result ordering when
looking up at pg_class entries. This commit adds an ORDER BY to the
culprit query. The cause of the failure was likely caused by a plan
switch. By default, the planner would likely choose an index-only scan
or an index scan, but even a small change in the startup cost could have
caused a bitmap heap scan to be chosen, causing the failure.
While on it, switch some filtering quals to a regular expression as per
an idea of Tom Lane. As previously shaped, the quals would have
selected any relations whose name begins with "temp". And that could
cause failures if another test running in parallel began to use similar
relation names.
Per report from buildfarm member anole, though the failure was very
rare. This test has been introduced by 319a810, so backpatch down to
v10.
Discussion: https://postgr.es/m/20190807132422.GC15695@paquier.xyz
Backpatch-through: 10
Branch
------
REL_12_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/4c0b9cf9e073ca2dc95a75fe983d90fd518864fb
Modified Files
--------------
src/test/regress/expected/temp.out | 9 +++++----
src/test/regress/sql/temp.sql | 9 +++++----
2 files changed, 10 insertions(+), 8 deletions(-)
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2019-08-13 04:54:58 | pgsql: Fix inconsistencies and typos in the tree, take 10 |
Previous Message | Peter Geoghegan | 2019-08-12 22:21:47 | pgsql: amcheck: Skip unlogged relations during recovery. |