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

Edit
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 (1 week ago)
Latest email 2024-07-08 02:33:39 (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
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