[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 pento):

 A couple of ideas on how to fix this:

 1. When the character set is `utf8mb4`, 191 becomes a magic number, and is
 treated the same as an empty subpart. Magic numbers are kind of eww.

 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.

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