This is an automated email from the ASF dual-hosted git repository. reshke pushed a commit to branch jdejii in repository https://gitbox.apache.org/repos/asf/cloudberry.git
commit c9706052a54bd016abe0b81f072af59051c33276 Author: reshke <[email protected]> AuthorDate: Mon Aug 17 09:09:20 2026 +0000 Fix JOIN motion type selection for join quals containing outer refs --- src/backend/optimizer/plan/initsplan.c | 9 +++++++++ 1 file changed, 9 insertions(+) diff --git a/src/backend/optimizer/plan/initsplan.c b/src/backend/optimizer/plan/initsplan.c index b65897043ca..381d0da47e1 100644 --- a/src/backend/optimizer/plan/initsplan.c +++ b/src/backend/optimizer/plan/initsplan.c @@ -2761,6 +2761,10 @@ distribute_qual_to_rels(PlannerInfo *root, Node *clause, */ check_mergejoinable(restrictinfo); + /* Update infobut we may use in join motion planning */ + if (contains_outer_params((Node *) restrictinfo->clause, root)) + restrictinfo->contain_outer_query_references = true; + /* * If it is a true equivalence clause, send it to the EquivalenceClass * machinery. We do *not* attach it directly to any restriction or join @@ -3254,6 +3258,11 @@ build_implied_join_equality(PlannerInfo *root, check_hashjoinable(restrictinfo); check_memoizable(restrictinfo); + + /* Update infobut we may use in join motion planning */ + if (contains_outer_params((Node *) restrictinfo->clause, root)) + restrictinfo->contain_outer_query_references = true; + return restrictinfo; } --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
