[wp-trac] [WordPress Trac] #41716: Check for utf8mb4 incorrectly assumes auto-truncating indexes

[WordPress Trac]

#41716: Check for utf8mb4 incorrectly assumes auto-truncating indexes
--------------------------+-----------------------
 Reporter:  straussd      |       Owner:  pento
     Type:  defect (bug)  |      Status:  assigned
 Priority:  normal        |   Milestone:  4.9
Component:  Database      |     Version:  4.2
 Severity:  normal        |  Resolution:
 Keywords:  has-patch     |     Focuses:
--------------------------+-----------------------
Changes (by pento):

 * keywords:   => has-patch
 * owner:   => pento
 * version:  trunk => 4.2
 * status:  new => assigned
 * milestone:  Awaiting Review => 4.9


Comment:

 Well, this was interesting. I was getting all kinds of weirdness due to it
 the unit tests transforming it into a temporary table, so I've explicitly
 disable that for this test.

 Because the point of this test is to ensure that `dbDelta()` ignores if an
 index has been silently truncated, [attachment:41716.diff] forces the
 `ROW_FORMAT` to `COMPACT`, which should truncate the index under every
 version of MySQL and MariaDB, regardless of server config.

 @straussd, @danielbachhuber: Does this fix the problems you're running
 into?

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