Allow defining order of column for indexes
|Reported by:||anonymous||Owned by:||Akshesh Doshi|
|Component:||Database layer (models, ORM)||Version:||master|
|Severity:||Normal||Keywords:||index, order, db-indexes|
|Has patch:||yes||Needs documentation:||no|
|Needs tests:||no||Patch needs improvement:||no|
Description (last modified by )
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:
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?
Change History (15)
comment:1 Changed 3 years ago by
|Patch needs improvement:||unset|
comment:5 Changed 3 years ago by
|Owner:||Daniel Boeve deleted|
|Status:||assigned → new|
comment:12 Changed 8 weeks ago by
|Summary:||Index ordering in index_together and unique_together → Index ordering in index_together|