Re-allow SRFs and window functions within sub-selects within aggregates.

tglsfdc · tglsfdc · commit dc777f9db3e9 · 2017-06-27T17:51:11.000-04:00
check_agg_arguments_walker threw an error upon seeing a SRF or window function, but that is too aggressive: if the function is within a sub-select then it's perfectly fine. I broke the SRF case in commit 0436f6b by copying the logic for window functions ... but that was broken too, and had been since commit eaccfde. Repair both cases in HEAD, and the window function case back to 9.3. 9.2 gets this right.
diff --git a/src/backend/parser/parse_agg.c b/src/backend/parser/parse_agg.c
@@ -508,7 +508,7 @@ check_agg_arguments_walker(Node *node,
 		return false;
 	}
 	/* We can throw error on sight for a window function */
-	if (IsA(node, WindowFunc))
+	if (IsA(node, WindowFunc) && context->sublevels_up == 0)
 		ereport(ERROR,
 				(errcode(ERRCODE_GROUPING_ERROR),
 				 errmsg("aggregate function calls cannot contain window function calls"),

Original file line number	Diff line number	Diff line change
`@@ -508,7 +508,7 @@ check_agg_arguments_walker(Node *node,`
`508`	`508`	`return false;`
`509`	`509`	`}`
`510`	`510`	`/* We can throw error on sight for a window function */`
`511`		`- if (IsA(node, WindowFunc))`
	`511`	`+ if (IsA(node, WindowFunc) && context->sublevels_up == 0)`
`512`	`512`	`ereport(ERROR,`
`513`	`513`	`(errcode(ERRCODE_GROUPING_ERROR),`
`514`	`514`	`errmsg("aggregate function calls cannot contain window function calls"),`