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
31331	GROUP BY optimization doesn't work properly when ONLY_FULL_GROUP_BY mode is enabled on MySQL.	Mariusz Felisiak	Simon Charette	"`GROUP BY` optimization doesn't work properly when `ONLY_FULL_GROUP_BY` mode is enabled on MySQL/MariaDB ([https://dev.mysql.com/doc/refman/5.7/en/group-by-handling.html default on MySQL 5.7+]) and can cause:
{{{
(1055, ""Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'TABLE.COLUMN' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by"")
}}}

See `tests.aggregation.tests.AggregateTestCase.test_aggregation_subquery_annotation_multivalued()`."	Bug	closed	Database layer (models, ORM)	dev	Normal	fixed	ONLY_FULL_GROUP_BY MySQL MariaDB	Simon Charette Adam Johnson Charlie Denton	Ready for checkin	1	0	0	0	0	0