NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commit449d5ac

committed

Fix failure with whole-row reference to a subquery.

Simple oversight in commit1cb108e ---recursively examining a subquery output column is only sane if theoriginal Var refers to a single output column. Found by Kevin Grittner.

1 parentc6ec879 commit449d5acCopy full SHA for 449d5ac

File tree

1 file changed

-0

lines changed

src/backend/utils/adt
- selfuncs.c

1 file changed

-0

lines changed

`‎src/backend/utils/adt/selfuncs.c‎`

Lines changed: 6 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -4502,6 +4502,12 @@ examine_simple_variable(PlannerInfo root, Var var,`
`4502`	`4502`	`RelOptInfo*rel;`
`4503`	`4503`	`TargetEntry*ste;`
`4504`	`4504`
	`4505`	`+/*`
	`4506`	`+ * Punt if it's a whole-row var rather than a plain column reference.`
	`4507`	`+ */`
	`4508`	`+if (var->varattno==InvalidAttrNumber)`
	`4509`	`+return;`
	`4510`	`+`
`4505`	`4511`	`/*`
`4506`	`4512`	`* Punt if subquery uses set operations or GROUP BY, as these will`
`4507`	`4513`	`* mash underlying columns' stats beyond recognition. (Set ops are`

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!

Commit449d5ac

File tree

1 file changed

1 file changed

`‎src/backend/utils/adt/selfuncs.c‎`

0 commit comments