[wp-trac] [WordPress Trac] #31869: dbDelta doesn't allow for automatically truncated indexes

[WordPress Trac]

#31869: dbDelta doesn't allow for automatically truncated indexes
-----------------------------+-----------------------
 Reporter:  pento            |       Owner:  pento
     Type:  defect (bug)     |      Status:  assigned
 Priority:  normal           |   Milestone:  4.2
Component:  Upgrade/Install  |     Version:
 Severity:  normal           |  Resolution:
 Keywords:  needs-patch      |     Focuses:
-----------------------------+-----------------------

Comment (by jdgrimes):

 Replying to [comment:2 pento]:
 > 2. Remove the subparts from the both the original CREATE TABLE and the
 generated index definition - we're really only interested in the index
 existing, not the size of it. This may change in the future, though.

 Yeah, I think what needs to happen is the check for whether an index
 exists needs to be split from the check of whether it is the same length.
 If the lengths are different, the index may need to be updated (unless the
 current length is the default for the character set being used, and no
 length is specified). I'm not an expert on how MySQL indexes work,
 however. :-)

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