Fix reuse of stale hash tables by duplicated hashed SubPlans

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v2, Patch count: 1, First patch: +101−3, All patches: +101−3

Tags

Bugfix

Created

2026-10-02 07:57:28

Last modified

2026-10-02 07:57:29 (2 weeks ago)

Latest email

2026-10-17 12:05:35 (12 hours ago)

Status

PG20-3 (2026-11-01 – 2026-11-30): Needs review

Target version

stable

Authors

Rahul Yadav (rhyadav)

Reviewers

Alexandra Wang (alexandrawang) 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-17 12:05:35 by Rahul <rahul at rhyadav.dev>
Latest attachment (v2-0001-Fix-reuse-of-stale-hash-tables-by-duplicated-hash.patch) at 2026-10-17 12:05:35 from Rahul <rahul at rhyadav.dev>
    Attachment (v2-0001-Fix-reuse-of-stale-hash-tables-by-duplicated-hash.patch) at 2026-10-17 12:05:35 from Rahul <rahul at rhyadav.dev> (Patch: No)
    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-16 23:27:26	Alexandra Wang (alexandrawang)	Added alexandrawang as reviewer
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