fix-reparameterize_path_by_child.patch

commit f74ca5d8611af3306eb96719d5d1910c9b6a8db5
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date:   Thu Dec 1 21:04:49 2022 -0500

    Add missing MaterialPath case in reparameterize_path_by_child.
    
    Surprised we hadn't noticed this already.

diff --git a/src/backend/optimizer/util/pathnode.c b/src/backend/optimizer/util/pathnode.c
index c77399ca92..224ba84107 100644
--- a/src/backend/optimizer/util/pathnode.c
+++ b/src/backend/optimizer/util/pathnode.c
@@ -4209,6 +4209,16 @@ do { \
 			}
 			break;
 
+		case T_MaterialPath:
+			{
+				MaterialPath *mpath;
+
+				FLAT_COPY_PATH(mpath, path, MaterialPath);
+				REPARAMETERIZE_CHILD_PATH(mpath->subpath);
+				new_path = (Path *) mpath;
+			}
+			break;
+
 		case T_MemoizePath:
 			{
 				MemoizePath *mpath;