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

Comment (by pento):

 Okay, now we might be getting somewhere!

 Testing against MariaDB 10.1, with the MySQL config described in the
 original ticket:

 {{{
 innodb_file_per_table=true
 innodb_file_format=Barracuda
 innodb_large_prefix=true
 }}}

 I was able to reproduce the error when creating the table. So, in
 [attachment:41716.2.diff], I'm setting `ROW_FORMAT=DYNAMIC` on the `CREATE
 TABLE`, which causes the following behaviour:

 * On servers with `innodb_file_format=Antelope`, the `ROW_FORMAT` is
 ignored, and defaults to `COMPACT`.
 * On MariaDB 10.1 (and presumably MySQL 5.6, we'll find out when Travis
 runs it), with the above config, the test is skipped, because it uses
 `DYNAMIC`, so doesn't truncate the index.
 * On MariaDB 10.2, the test is skipped.

 Could you try this patch out, and see where we're at?

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