Opened 9 years ago
Closed 9 years ago
#34959 closed defect (bug) (fixed)
dbDelta index ASC or DESC creates duplicate
Reported by: | mnelson4 | Owned by: | ocean90 |
---|---|---|---|
Milestone: | 4.6 | Priority: | normal |
Severity: | normal | Version: | 4.4 |
Component: | Database | Keywords: | |
Focuses: | Cc: |
Description
Similar to #10404,
using
KEY movie_type_idx (movie_type ASC),
creates duplicate indexes, whereas using
KEY movie_type_idx (movie_type),
does not.
Although specifying the order of the index apparently doesn't affect anything according to http://dev.mysql.com/doc/refman/5.7/en/create-index.html. Specifically it states
An index_col_name specification can end with ASC or DESC. These keywords are permitted for future extensions for specifying ascending or descending index value storage. Currently, they are parsed but ignored; index values are always stored in ascending order.
Change History (2)
Note: See
TracTickets for help on using
tickets.
In 37583: