[wp-trac] [WordPress Trac] #34959: dbDelta index ASC or DESC creates duplicate

[WordPress Trac]

#34959: dbDelta index ASC or DESC creates duplicate
--------------------------+-----------------------------
 Reporter:  mnelson4      |      Owner:
     Type:  defect (bug)  |     Status:  new
 Priority:  normal        |  Milestone:  Awaiting Review
Component:  Database      |    Version:  4.4
 Severity:  normal        |   Keywords:
  Focuses:                |
--------------------------+-----------------------------
 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.

--
Ticket URL: <https://core.trac.wordpress.org/ticket/34959>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform