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

 There's an existing work around - to define the index sizes in `CREATE
 TABLE` as 191 characters, so that MySQL doesn't automatically change their
 size, that's what we've done in core.

 I don't know how people would've used dbDelta to change indexes in the
 past - dbDelta never drops indexes, it only adds them.

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