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
28553	Querysets: annotate() columns are forced into a certain position which may disrupt union()	David Sanders	David Wobrock	"(Reporting possible issue found by a user on #django)

Using values() to force selection of certain columns in a certain order proved useful unioning querysets with union() for the aforementioned user.  The positioning of columns added with annotate() is not controllable with values() and has the potential to disrupt union() unless this fact is known and the ordering done in a certain way to accommodate it.

I'm reporting this mainly for posterity but also as a highlight that perhaps this should be mentioned in the documentation.  I'm sure there are reasons why the annotations are appended to the select but if someone feels that this is changeable then it would be a bonus outcome."	Bug	closed	Database layer (models, ORM)	1.11	Normal	fixed		Ole Laursen David Wobrock Simon Charette Sylvain Fankhauser	Ready for checkin	1	0	0	0	0	0