Planner : anti-join on left joins

Edit
ID 6375
Title Planner : anti-join on left joins
CI (CFBot) Summary
Stats (from CFBot) Patch version: v6, Patch count: 1, First patch: +256−31, All patches: +256−31
Topic Server Features
Tags
Created 2026-01-05 10:53:57
Last modified 2026-01-05 10:53:57 (2 days ago)
Latest email 2026-01-06 08:23:55 (yesterday)
Status
PG19-Final (2026-03-01 – 2026-03-31): Needs review
Target version 19
Authors Tender Wang (tndrwang)
Reviewers Become reviewer
Committer
Links
Emails
Planner : anti-join on left joins
First at 2025-12-31 09:59:26 by Nicolas Adenis-Lamarre <nicolas.adenis.lamarre at gmail.com>
Latest at 2026-01-06 08:23:55 by Richard Guo <guofenglinux at gmail.com>
Latest attachment (v6-0001-Reduce-LEFT-JOIN-to-ANTI-JOIN-using-NOT-NULL-cons.patch) at 2026-01-06 08:23:55 from Richard Guo <guofenglinux at gmail.com>
    Attachment (v6-0001-Reduce-LEFT-JOIN-to-ANTI-JOIN-using-NOT-NULL-cons.patch) at 2026-01-06 08:23:55 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Reduce-LEFT-JOIN-to-ANTI-JOIN-using-NOT-NULL-cons.patch) at 2026-01-05 13:25:57 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Reduce-JOIN_LEFT-TO-JOIN_ANTI.patch) at 2026-01-05 10:59:12 from Tender Wang <tndrwang at gmail.com> (Patch: Yes)
    Attachment (0001-Reduce-JOIN_LEFT-TO-JOIN_ANTI.patch) at 2026-01-02 09:19:01 from Nicolas Adenis-Lamarre <nicolas.adenis.lamarre at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Reduce-JOIN_LEFT-TO-JOIN_ANTI.patch) at 2026-01-02 06:53:54 from Tender Wang <tndrwang at gmail.com> (Patch: Yes)
    Attachment (0001-Reduce-JOIN_LEFT-TO-JOIN_ANTI-regression-tests.patch) at 2026-01-01 22:28:01 from Nicolas Adenis-Lamarre <nicolas.adenis.lamarre at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Reduce-JOIN_LEFT-TO-JOIN_ANTI.patch) at 2026-01-01 06:23:22 from Tender Wang <tndrwang at gmail.com> (Patch: Yes)
    Attachment (0001-planner-anti-join-on-left-joins.patch) at 2025-12-31 09:59:26 from Nicolas Adenis-Lamarre <nicolas.adenis.lamarre at gmail.com> (Patch: Yes)
History
When Who What
2026-01-05 10:53:57 Tender Wang (tndrwang) Attached mail thread CACPGbctKMDP50PpRH09in+oWbHtZdahWSroRstLPOoSDKwoFsw@mail.gmail.com
2026-01-05 10:53:57 Tender Wang (tndrwang) Created patch record
Edit