BUG #17545: Incorrect selectivity for IS NOT DISTINCT FROM and NULLs

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v2, Patch count: 2, First patch: +100−3, All patches: +191−3

Tags

Bugfix

Created

2026-10-05 18:37:55

Last modified

2026-10-05 18:50:37 (7 hours ago)

Latest email

2026-10-05 18:38:05 (7 hours ago)

Status

PG20-3 (2026-11-01 – 2026-11-30): Ready for Committer

Target version

Authors

shihao zhong (zhong950419)

Reviewers

Become reviewer

Committer

Links

Emails

BUG #17545: Incorrect selectivity for IS NOT DISTINCT FROM and NULLs: First at 2022-07-11 14:18:44 by PG Bug reporting form <noreply at postgresql.org>
Latest at 2026-10-05 18:38:05 by shihao zhong <zhong950419 at gmail.com>
Latest attachment (v2-0001-Count-NULL-pairs-in-IS-NOT-DISTINCT-FROM-selectiv.patch) at 2026-10-05 15:10:53 from shihao zhong <zhong950419 at gmail.com>
    Attachment (v2-0001-Count-NULL-pairs-in-IS-NOT-DISTINCT-FROM-selectiv.patch) at 2026-10-05 15:10:53 from shihao zhong <zhong950419 at gmail.com> (Patch: No)
    Attachment (semijoin-null-matches-on-v1.txt) at 2026-10-05 07:19:12 from Rahul <rahul at rhyadav.dev> (Patch: No)
    Attachment (v1-0001-Count-NULL-pairs-in-IS-NOT-DISTINCT-FROM-selectiv.patch) at 2026-10-05 04:14:24 from shihao zhong <zhong950419 at gmail.com> (Patch: No)

History

When	Who	What
2026-10-05 18:50:37	Rahul Yadav (slowrah)	New status: Ready for Committer
2026-10-05 18:37:55	shihao zhong (zhong950419)	Attached mail thread 17545-a0ca4de888953169@postgresql.org
2026-10-05 18:37:55	shihao zhong (zhong950419)	Created patch record