Make WHERE conditions pulled up from subqueries be executed before outer

tglsfdc · tglsfdc · commit f67a931aa42a · 2002-06-13T15:10:25.000Z
WHERE conditions, if there is no reason to do it differently.
diff --git a/src/backend/optimizer/plan/planner.c b/src/backend/optimizer/plan/planner.c
@@ -8,7 +8,7 @@
  *
  *
  * IDENTIFICATION
- *	  $Header: /cvsroot/pgsql/src/backend/optimizer/plan/planner.c,v 1.119 2002/05/18 18:49:41 tgl Exp $
+ *	  $Header: /cvsroot/pgsql/src/backend/optimizer/plan/planner.c,v 1.120 2002/06/13 15:10:25 tgl Exp $
  *
  *-------------------------------------------------------------------------
  */
@@ -656,7 +656,7 @@ preprocess_jointree(Query *parse, Node *jtnode)
 				if (childlen <= 1 || (childlen + myothers) <= geqo_rels / 2)
 				{
 					newlist = nconc(newlist, subf->fromlist);
-					f->quals = make_and_qual(f->quals, subf->quals);
+					f->quals = make_and_qual(subf->quals, f->quals);
 				}
 				else
 					newlist = lappend(newlist, child);

Original file line number	Diff line number	Diff line change
`@@ -8,7 +8,7 @@`
`8`	`8`	`*`
`9`	`9`	`*`
`10`	`10`	`* IDENTIFICATION`
`11`		`- * $Header: /cvsroot/pgsql/src/backend/optimizer/plan/planner.c,v 1.119 2002/05/18 18:49:41 tgl Exp $`
	`11`	`+ * $Header: /cvsroot/pgsql/src/backend/optimizer/plan/planner.c,v 1.120 2002/06/13 15:10:25 tgl Exp $`
`12`	`12`	`*`
`13`	`13`	`*-------------------------------------------------------------------------`
`14`	`14`	`*/`
`@@ -656,7 +656,7 @@ preprocess_jointree(Query parse, Node jtnode)`
`656`	`656`	`if (childlen <= 1 \|\| (childlen + myothers) <= geqo_rels / 2)`
`657`	`657`	`{`
`658`	`658`	`newlist = nconc(newlist, subf->fromlist);`
`659`		`- f->quals = make_and_qual(f->quals, subf->quals);`
	`659`	`+ f->quals = make_and_qual(subf->quals, f->quals);`
`660`	`660`	`}`
`661`	`661`	`else`
`662`	`662`	`newlist = lappend(newlist, child);`