Flush Memoize cache when non-key parameters change, take 2

David Rowley <drowley@postgresql.org>

Commit: c2dc7b9e15039ce90c0a631ff291feb81d2c8051
Author: David Rowley <drowley@postgresql.org>
Date: 2021-11-24T10:29:56Z
Releases: 14.2
Flush Memoize cache when non-key parameters change, take 2

It's possible that a subplan below a Memoize node contains a parameter
from above the Memoize node.  If this parameter changes then cache entries
may become out-dated due to the new parameter value.

Previously Memoize was mistakenly not aware of this.  We fix this here by
flushing the cache whenever a parameter that's not part of the cache
key changes.

Bug: #17213
Reported by: Elvis Pranskevichus
Author: David Rowley
Discussion: https://postgr.es/m/17213-988ed34b225a2862@postgresql.org
Backpatch-through: 14, where Memoize was added

Files

Discussion