Fix reuse of stale hash tables by duplicated hashed SubPlans

Edit
ID 7384
Title Fix reuse of stale hash tables by duplicated hashed SubPlans
CI (CFBot) Not processed
Stats (from CFBot) Unknown
Tags Bugfix
Created 2026-10-02 07:57:28
Last modified 2026-10-02 07:57:29 (55 minutes ago)
Latest email 2026-10-02 07:47:18 (1 hour ago)
Status
PG20-3 (2026-11-01 – 2026-11-30): Needs review
Target version stable
Authors Rahul Yadav (rhyadav)
Reviewers Become reviewer
Committer
Links
Emails
Wrong results: hashed SubPlan referenced twice after OR-qual extraction reuses a stale hash table (13 to 19beta4)
First at 2026-10-01 18:29:22 by Samuel Olaoye <dapsalmy at gmail.com>
Latest at 2026-10-02 07:47:18 by rahul at rhyadav.dev
Latest attachment (v1-0001-Fix-reuse-of-stale-hash-tables-by-duplicated-hash.patch) at 2026-10-02 07:47:18 from rahul at rhyadav.dev
    Attachment (v1-0001-Fix-reuse-of-stale-hash-tables-by-duplicated-hash.patch) at 2026-10-02 07:47:18 from rahul at rhyadav.dev (Patch: No)
    Attachment (pg_hashed_subplan_repro.sql) at 2026-10-01 18:29:22 from Samuel Olaoye <dapsalmy at gmail.com> (Patch: No)
History
When Who What
2026-10-02 07:57:29 Rahul Yadav (rhyadav) Attached mail thread 179087936257.78721.1170374394656748858@mail.gmail.com
2026-10-02 07:57:28 Rahul Yadav (rhyadav) Created patch record
Edit