[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        |  Resolution:
 Keywords:                |     Focuses:  performance
--------------------------+------------------------------

Comment (by charlestonsw):

 Per @sebet on ticket #10404 entry 9... quote from his post:

 ----

 Example:

 The comparison for this index will not match and will cause a duplicate
 index because the length was not specified


 {{{
 KEY movie_type_idx (movie_type),
 }}}


 The comparison for this index will match and the index will not be
 duplicated because the length was included


 {{{
 KEY movie_type_idx (movie_type(255)),
 }}}


 ----


 I've not yet tested nor verified these items.  Per guidance at WCUS this
 past weekend I simply split the #10404 "beast of a dbDelta ticket" into
 separate bite-sized chunks that can be tackled one-by-one.

 Someone needs to double-check that I've captured the main reports attached
 to #10404 in the list of new tickets and then close #10404.

 Many of the new "child tickets" were fixed from what I could tell but I've
 not yet finished the phpUnit scripting to verify.

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