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