Fix right-anti-joins when the inner relation is proven unique

Title

Topic

Bug Fixes

Created

2024-06-26 07:40:21

Last modified

2024-07-08 03:16:51 (4 months, 1 week ago)

Latest email

2024-07-08 02:33:39 (4 months, 1 week ago)

Status

2024-07: Committed

Target version

stable

Authors

Richard Guo (richardguo)

Reviewers

Committer

Richard Guo (richardguo)

Links

Checkout latest CFbot patchset

Go to your local checkout of the PostgreSQL repository and run:

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/5078
git checkout commitfest/cf/5078

Emails

BUG #18522: Wrong results with Merge Right Anti Join, inconsistent with Merge Anti Join: First at 2024-06-24 18:16:38 by PG Bug reporting form <noreply at postgresql.org>
Latest at 2024-07-08 02:33:39 by Richard Guo <guofenglinux at gmail.com>
Latest attachment (v3-0001-Fix-right-anti-joins-when-the-inner-relation-is-proven-unique.patch) at 2024-07-02 10:22:26 from Richard Guo <guofenglinux at gmail.com>
    Attachment (v3-0001-Fix-right-anti-joins-when-the-inner-relation-is-proven-unique.patch) at 2024-07-02 10:22:26 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Fix-right-anti-joins-when-the-inner-relation-is-proven-unique.patch) at 2024-06-26 07:31:51 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Fix-right-anti-joins-when-the-inner-relation-is-proven-unique.patch) at 2024-06-25 14:45:59 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)

History

When	Who	What
2024-07-08 03:16:51	Richard Guo (richardguo)	Closed in commitfest 2024-07 with status: Committed
2024-07-08 03:16:51	Richard Guo (richardguo)	Changed committer to richardguo
2024-06-28 19:19:17	Tom Lane (tgl)	Added tgl as reviewer
2024-06-26 07:40:45	Richard Guo (richardguo)	Changed authors to Richard Guo (richardguo)
2024-06-26 07:40:45	Richard Guo (richardguo)	Changed targetversion to stable
2024-06-26 07:40:21	Richard Guo (richardguo)	Attached mail thread 18522-c7a8956126afdfd0@postgresql.org
2024-06-26 07:40:21	Richard Guo (richardguo)	Created patch record