From 64a32f9df82ea23ad0b2adea161f18702f378fac Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Wed, 27 Aug 2003 12:44:12 +0000 Subject: [PATCH] Department of second thoughts: can't reorder merge-join clauses. --- src/backend/optimizer/plan/createplan.c | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/src/backend/optimizer/plan/createplan.c b/src/backend/optimizer/plan/createplan.c index fb5040c94c..e3ad5bc655 100644 --- a/src/backend/optimizer/plan/createplan.c +++ b/src/backend/optimizer/plan/createplan.c @@ -10,7 +10,7 @@ * * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/optimizer/plan/createplan.c,v 1.156 2003/08/26 22:56:51 tgl Exp $ + * $Header: /cvsroot/pgsql/src/backend/optimizer/plan/createplan.c,v 1.157 2003/08/27 12:44:12 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -1000,9 +1000,9 @@ create_mergejoin_plan(Query *root, best_path->jpath.outerjoinpath->parent->relids); /* Sort clauses into best execution order */ + /* NB: do NOT reorder the mergeclauses */ joinclauses = order_qual_clauses(root, joinclauses); otherclauses = order_qual_clauses(root, otherclauses); - mergeclauses = order_qual_clauses(root, mergeclauses); /* * Create explicit sort nodes for the outer and inner join paths if -- 2.40.0