Index ordering in index_together and unique_together
|Reported by:||anonymous||Owned by:|
|Component:||Database layer (models, ORM)||Version:||1.5|
|Has patch:||no||Needs documentation:||no|
|Needs tests:||no||Patch needs improvement:||no|
Currently the index_together tuples do not support index ordering using + / -.
If I have the following table:
['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 (6)
comment:1 Changed 2 years ago by wim@…
- Needs documentation unset
- Needs tests unset
- Patch needs improvement unset
comment:3 Changed 23 months ago by animan1
- Owner changed from nobody to animan1
- Status changed from new to assigned
comment:5 Changed 23 months ago by anonymous
- Easy pickings set
- Owner animan1 deleted
- Status changed from assigned to new