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
20888	Allow defining order of column for indexes	anonymous	Akshesh Doshi	"Hi, 

Currently the index_together tuples do not support index ordering using + / -.

If I have the following table:
{{{
class Messages:
   user_id,
   rating,
   last_update,

   index_together=[
     ['user_id', 'rating',  'last_update',] # sorted ASC by default
  ]
}}}
So for MySQL, the following query cannot make use of the index:

Messages.objects.filter(user_id=xxx).order_by('+rating','-last_update') 

Pardon me if it actually can make use of the index.

I know there are workarounds, such as negating values to make a DESC ordering become ASC ordering.
But it is just nice to have such a feature.
Btw, what is the reason for not having this feature?
"	New feature	closed	Database layer (models, ORM)	dev	Normal	fixed	index, order, db-indexes 1.11	aksheshdoshi@…	Ready for checkin	1	0	0	0	0	0