NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commite243bd7

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 parentfbbd150 commite243bd7Copy full SHA for e243bd7

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

Commite243bd7

File tree

1 file changed

1 file changed

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

0 commit comments