Re: BUG #17213: Wrong result from a query involving Merge Semi Join and Memoize

Elvis Pranskevichus <elprans@gmail.com>

From: Elvis Pranskevichus <elprans@gmail.com>
To: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>, David Rowley <dgrowleyml@gmail.com>
Date: 2021-11-24T19:48:37Z
Lists: pgsql-bugs
On Tuesday, November 23, 2021 5:58:30 PM PST David Rowley wrote:
> On Mon, 22 Nov 2021 at 23:36, David Rowley <dgrowleyml@gmail.com> 
> > I'm planning on giving the patch I submitted another look with the
> > intention of pushing it tomorrow.
> 
> Pushed with the addition of a test to exercise the cache flushing
> code.
> 
> Thanks for reporting this.

Excellent!  Thank you for tackling the bug, David!


                          Elvis






Commits

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

  2. Flush Memoize cache when non-key parameters change