id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
10290	grouping with extra_selects produces invalid sql	Erin Kelly		"From [9838] on, I'm getting aggregation_regress test failures in Oracle, apparently because annotations with extra selects are adding the extra select aliases into the group by list.  This produces invalid SQL (at least in Oracle), since you can't use column aliases defined at the same level within a group by clause.

The attached patch uses the extra select expression itself in the group by, rather than the alias.  This passes the tests across all four included backends, and seems to work in general as long as the expression is not a scalar subquery.
"		closed	Database layer (models, ORM)	dev		fixed			Unreviewed	0	0	0	0	0	0