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

David Rowley <drowley@postgresql.org>

Commit: 411137a429210e432f923264a8e313a9872910ca
Author: David Rowley <drowley@postgresql.org>
Date: 2021-11-24T10:29:14Z
Releases: 15.0
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