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
26815	Addition of Trunc may have altered the ordering of dates() queries	Luke Benstead	nobody	"We're looking into supporting Django 1.10 in Djangae, and while fixing up some breakages I noticed a change in the way that dates() queries are ordered. I'm not 100% sure this is a real bug as I'm looking at the code in a fairly abnormal situation, but it definitely seems like a bug...

This line was recently added as part of the datetime expression changes:

https://github.com/django/django/commit/2a4af0ea43512370764303d35bc5309f8abce666#diff-5b0dda5eb9a242c15879dc9cd2121379R743

It seems to me that now, instead of ordering by the full date, this change will make dates queries order by just the component that they are selecting (e.g. year, month, day etc.) - although I might be wrong about this!"	Bug	closed	Database layer (models, ORM)	1.10	Normal	invalid	dates, queryset	Josh Smeaton	Unreviewed	0	0	0	0	0	0