NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commitcdcaec5

committed

Avoid reversing user-given order of WHERE clauses while attaching clauses

to specific base or join RelOptInfo nodes during planning. This preservesthe more-intuitive behavior of 7.0.* --- if you write an expensive clause(such as a sub-select) last, it should get evaluated last. Someday weought to try to have some intelligence about the order of evaluation ofWHERE clauses, but for now we should not override what the user wrote.

1 parent722f7ef commitcdcaec5Copy full SHA for cdcaec5

File tree

1 file changed

-5

lines changed

src/backend/optimizer/plan
- initsplan.c

1 file changed

-5

lines changed

`‎src/backend/optimizer/plan/initsplan.c`

Lines changed: 5 additions & 5 deletions

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/initsplan.c,v 1.58 2001/03/22 03:59:36 momjian Exp $`
	`11`	`+ * $Header: /cvsroot/pgsql/src/backend/optimizer/plan/initsplan.c,v 1.59 2001/04/16 19:44:10 tgl Exp $`
`12`	`12`	`*`
`13`	`13`	`*-------------------------------------------------------------------------`
`14`	`14`	`*/`
`@@ -444,8 +444,8 @@ distribute_qual_to_rels(Query root, Node clause,`
`444`	`444`	`*/`
`445`	`445`	`RelOptInfo*rel=get_base_rel(root,lfirsti(relids));`
`446`	`446`
`447`		`-rel->baserestrictinfo=lcons(restrictinfo,`
`448`		`-rel->baserestrictinfo);`
	`447`	`+rel->baserestrictinfo=lappend(rel->baserestrictinfo,`
	`448`	`+restrictinfo);`
`449`	`449`
`450`	`450`	`/*`
`451`	`451`	`* Check for a "mergejoinable" clause even though it's not a join`
`@@ -549,8 +549,8 @@ add_join_info_to_rels(Query root, RestrictInfo restrictinfo,`
`549`	`549`	`*/`
`550`	`550`	`joininfo=find_joininfo_node(get_base_rel(root,cur_relid),`
`551`	`551`	`unjoined_relids);`
`552`		`-joininfo->jinfo_restrictinfo=lcons(restrictinfo,`
`553`		`-joininfo->jinfo_restrictinfo);`
	`552`	`+joininfo->jinfo_restrictinfo=lappend(joininfo->jinfo_restrictinfo,`
	`553`	`+restrictinfo);`
`554`	`554`	`}`
`555`	`555`	`}`
`556`	`556`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commitcdcaec5

File tree

1 file changed

1 file changed

`‎src/backend/optimizer/plan/initsplan.c`

0 commit comments