]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Fix Memoize to work with partitionwise joining.
authorTom Lane <tgl@sss.pgh.pa.us>
Mon, 5 Dec 2022 17:36:41 +0000 (12:36 -0500)
committerTom Lane <tgl@sss.pgh.pa.us>
Mon, 5 Dec 2022 17:36:41 +0000 (12:36 -0500)
commitdc3648f65bea3d3373b4e0026ae83bd8f436ee40
tree55a1e515fd7f99a033157ba7b24511d448b3bd57
parent1bd84ef6778017f89c2ca80377c3ae02ed3f4861
Fix Memoize to work with partitionwise joining.

A couple of places weren't up to speed for this.  By sheer good
luck, we didn't fail but just selected a non-memoized join plan,
at least in the test case we have.  Nonetheless, it's a bug,
and I'm not quite sure that it couldn't have worse consequences
in other examples.  So back-patch to v14 where Memoize came in.

Richard Guo

Discussion: https://postgr.es/m/CAMbWs48GkNom272sfp0-WeD6_0HSR19BJ4H1c9ZKSfbVnJsvRg@mail.gmail.com
src/backend/optimizer/path/joinpath.c
src/backend/optimizer/util/pathnode.c
src/include/nodes/pathnodes.h
src/test/regress/expected/memoize.out
src/test/regress/sql/memoize.sql