Fix const-simplification for index expressions and predicate

Edit
ID 6092
Title Fix const-simplification for index expressions and predicate
CI (CFBot) Summary
Stats (from CFBot) Patch version: v4, Patch count: 1, First patch: +102−10, All patches: +102−10
Topic Bug Fixes
Tags Bugfix
Created 2025-10-01 07:16:41
Last modified 2025-10-01 07:16:41 (yesterday)
Latest email 2025-09-26 09:20:45 (6 days ago)
Status
PG19-3 (2025-11-01 – 2025-11-30): Needs review
Target version 19
Authors Richard Guo (richardguo)
Reviewers Become reviewer
Committer
Links
Emails
BUG #19007: Planner fails to choose partial index with spurious 'not null'
First at 2025-08-03 16:15:10 by PG Bug reporting form <noreply at postgresql.org>
Latest at 2025-09-26 09:20:45 by Richard Guo <guofenglinux at gmail.com>
Latest attachment (v4-0001-Fix-const-simplification-for-index-expressions-an.patch) at 2025-09-26 09:20:45 from Richard Guo <guofenglinux at gmail.com>
    Attachment (v4-0001-Fix-const-simplification-for-index-expressions-an.patch) at 2025-09-26 09:20:45 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Fix-const-simplification-for-index-expressions-an.patch) at 2025-09-01 06:00:03 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Fix-const-simplification-for-constraints-and-stat.patch) at 2025-08-22 07:25:25 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Fix-const-simplification-of-expressions-loaded-fr.patch) at 2025-08-20 09:37:14 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (further_eval_const_expressions_processing_on_partial_indexes.patch) at 2025-08-04 04:28:33 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
History
When Who What
2025-10-01 07:16:41 Richard Guo (richardguo) Attached mail thread 19007-4cc6e252ed8aa54a@postgresql.org
2025-10-01 07:16:41 Richard Guo (richardguo) Created patch record
Edit