[wp-trac] [WordPress Trac] #49364: dbDelta() should not change display width for integer data types on MySQL 8.0.17+

[WordPress Trac]

#49364: dbDelta() should not change display width for integer data types on MySQL
8.0.17+
----------------------------+-----------------------------
 Reporter:  SergeyBiryukov  |       Owner:  (none)
     Type:  defect (bug)    |      Status:  new
 Priority:  normal          |   Milestone:  Future Release
Component:  Database        |     Version:
 Severity:  normal          |  Resolution:
 Keywords:                  |     Focuses:
----------------------------+-----------------------------

Comment (by SergeyBiryukov):

 In [changeset:"47184" 47184]:
 {{{
 #!CommitTicketReference repository="" revision="47184"
 Tests: Allow `dbDelta()` tests to (mostly) run on MySQL 8.0.11+.

 * MySQL 8.0.11 changed the `GeometryCollection` data type name to
 `GeomCollection`, with the latter being the preferred name.
 * MySQL 8.0.17 removed support for the display width attribute for integer
 data types. Previously, default display width of 20 digits was used:
 `BIGINT(20)`.

 The affected tests now check the MySQL server version and use the
 appropriate data types.

 This leaves one unresolved failure on MySQL 8.0.17+ to be addressed in the
 future, caused by the same `BIGINT` display width discrepancy coming from
 `wp_get_db_schema()`.

 Props kaggdesign, ottok, jeremyfelt, SergeyBiryukov.
 Fixes #44384, #49344. See #49364.
 }}}

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