From: | Richard Guo <rguo(at)postgresql(dot)org> |
---|---|
To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
Subject: | pgsql: Fix unstable test in select_parallel.sql |
Date: | 2024-07-22 02:30:29 |
Message-ID: | E1sVion-000div-U2@gemulon.postgresql.org |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Fix unstable test in select_parallel.sql
One test case added in 22d946b0f verifies the plan of a non-parallel
nestloop join. The planner's choice of join order is arbitrary, and
slight variations in underlying statistics could result in a different
displayed plan. To stabilize the test result, here we enforce the
join order using a lateral join.
While here, modify the test case to verify that parallel nestloop join
is not generated if the inner path is not parallel-safe, which is what
we wanted to test in 22d946b0f.
Reported-by: Alexander Lakhin as per buildfarm
Author: Richard Guo
Discussion: https://postgr.es/m/7c09a439-e48d-5460-cfa0-a371b1a57066@gmail.com
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/7e187a7386cc922c8f770c0460bfc43f4806bd15
Modified Files
--------------
src/test/regress/expected/select_parallel.out | 17 +++++++++++------
src/test/regress/sql/select_parallel.sql | 11 ++++++++---
2 files changed, 19 insertions(+), 9 deletions(-)
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2024-07-22 07:58:01 | pgsql: Add port/ replacement for strsep() |
Previous Message | Michael Paquier | 2024-07-22 00:32:10 | pgsql: Add new error code for "file name too long" |