pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Richard Guo <rguo@postgresql.org>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: Improve the test case from 5668a857d
Date: Thu, 12 Dec 2024 02:22:41 +0000
Message-ID: <E1tLYqe-002HU7-In@gemulon.postgresql.org> (raw)

Improve the test case from 5668a857d

In commit 5668a857d, we fixed an issue with incorrect results in right
semi joins and introduced a test case to verify the fix.  The test
case involves SubPlans and InitPlans, which may not be immediately
apparent in relation to the issue we addressed.

This patch simplifies the test case with a more straightforward query.

Per discussion with Melanie Plageman.

Author: Richard Guo
Discussion: https://postgr.es/m/CAAKRu_a-Cip2XCXp13fmxq+T9BhLAVApHTyjr94awL2mbXHC-Q@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/d8f335156c57f0df6ae3b1ec31e55979838eb882

Modified Files
--------------
src/test/regress/expected/join.out | 84 ++++++++++++++------------------------
src/test/regress/sql/join.sql      | 29 +++++--------
2 files changed, 40 insertions(+), 73 deletions(-)



Message-ID: <E1tLYqe-002HU7-In@gemulon.postgresql.org>
Permalink:  ../E1tLYqe-002HU7-In@gemulon.postgresql.org/
Also on:    postgresql.org/message-id/E1tLYqe-002HU7-In@gemulon.postgresql.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-committers@postgresql.org
  Cc: rguo@postgresql.org, pgsql-committers@lists.postgresql.org
  Subject: Re: pgsql: Improve the test case from 5668a857d
  In-Reply-To: <E1tLYqe-002HU7-In@gemulon.postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox