Bugfix. Recursing into subquery we must use subroot instead of root to

danolivo · danolivo · commit 304b443040f9 · 2022-03-23T10:32:58.000+05:00
translate relids in this subtree.
diff --git a/cardinality_hooks.c b/cardinality_hooks.c
@@ -298,7 +298,7 @@ aqo_set_joinrel_size_estimates(PlannerInfo *root, RelOptInfo *rel,
 	List	   *inner_selectivities;
 	List	   *outer_selectivities;
 	List	   *current_selectivities = NULL;
-	int				fss = 0;
+	int			fss = 0;
 
 	if (IsQueryDisabled())
 		/* Fast path */
diff --git a/path_utils.c b/path_utils.c
@@ -314,7 +314,10 @@ get_path_clauses(Path *path, PlannerInfo *root, List **selectivities)
 									selectivities);
 			break;
 		case T_SubqueryScanPath:
-			return get_path_clauses(((SubqueryScanPath *) path)->subpath, root,
+			/* Recursing into Subquery we must use subroot */
+			Assert(path->parent->subroot != NULL);
+			return get_path_clauses(((SubqueryScanPath *) path)->subpath,
+									path->parent->subroot,
 									selectivities);
 			break;
 		case T_ModifyTablePath:
