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
37278	QuerySet.totally_ordered property doesn't fathom aliases of pure fields	Jacob Walls	Jacob Walls	"In #36857 we added a public `totally_ordered` property on `QuerySet` by porting some logic from the admin.

We didn't check whether `F()` objects might refer to annotations.

{{{#!py
class PhotoOfTheDay(models.Model):
    day = models.DateField(unique=True)

>>> PhotoOfTheDay.objects.order_by(""day"").totally_ordered
True
>>> PhotoOfTheDay.objects.annotate(día=models.F(""day"")).order_by(""día"").totally_ordered
False  # expected True
}}}

I'm cooking up a solution 🍲"	Cleanup/optimization	assigned	Database layer (models, ORM)	6.1	Normal			VIZZARD-X	Accepted	1	0	0	0	0	0