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

Edit
ID 5078
Title Fix right-anti-joins when the inner relation is proven unique
Topic Bug Fixes
Created 2024-06-26 07:40:21
Last modified 2024-07-08 03:16:51 (3 months, 1 week ago)
Latest email 2024-07-08 02:33:39 (3 months, 1 week ago)
Status
2024-07: Committed
Target version stable
Authors Richard Guo (richardguo)
Reviewers Tom Lane (tgl)Become reviewer
Committer Richard Guo (richardguo)
Links CFbot results (CirrusCI) CFbot GitHub
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
Edit