[wp-trac] [WordPress Trac] #49344: Make tests running with MySQL 8.0

[WordPress Trac]

#49344: Make tests running with MySQL 8.0
-------------------------+-----------------------------
 Reporter:  kaggdesign   |       Owner:  SergeyBiryukov
     Type:  enhancement  |      Status:  closed
 Priority:  normal       |   Milestone:  5.4
Component:  Database     |     Version:  trunk
 Severity:  normal       |  Resolution:  fixed
 Keywords:  has-patch    |     Focuses:
-------------------------+-----------------------------
Changes (by SergeyBiryukov):

 * status:  reviewing => closed
 * resolution:   => fixed


Comment:

 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/49344#comment:6>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform