[wp-trac] [WordPress Trac] #34870: dbDelta Not Specifying Key Length Duplicate Indexes

[WordPress Trac]

#34870: dbDelta Not Specifying Key Length Duplicate Indexes
--------------------------+-----------------------------
 Reporter:  charlestonsw  |      Owner:
     Type:  defect (bug)  |     Status:  new
 Priority:  normal        |  Milestone:  Awaiting Review
Component:  Database      |    Version:  2.8.1
 Severity:  normal        |   Keywords:
  Focuses:  performance   |
--------------------------+-----------------------------
 Reference ticket #10404.

 This is to decompose the original ticket into components. May be fixed in
 4.4. Needs testing.

 ----

 Does not match index definition.  Creates duplicate indexes each time
 dbDelta is run:
 {{{
 KEY movie_type_idx (movie_type),
 }}}

 Does NOT create duplicate indexes:
 {{{
 KEY movie_type_idx (movie_type(255)),
 }}}

 ----

 Reported by: @sebet

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