NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commitebefbb5

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 parent0b7e660 commitebefbb5Copy full SHA for ebefbb5

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
`@@ -4505,6 +4505,12 @@ examine_simple_variable(PlannerInfo root, Var var,`
`4505`	`4505`	`RelOptInfo*rel;`
`4506`	`4506`	`TargetEntry*ste;`
`4507`	`4507`
	`4508`	`+/*`
	`4509`	`+ * Punt if it's a whole-row var rather than a plain column reference.`
	`4510`	`+ */`
	`4511`	`+if (var->varattno==InvalidAttrNumber)`
	`4512`	`+return;`
	`4513`	`+`
`4508`	`4514`	`/*`
`4509`	`4515`	`* Punt if subquery uses set operations or GROUP BY, as these will`
`4510`	`4516`	`* 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!

Commitebefbb5

File tree

1 file changed

1 file changed

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

0 commit comments