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

WordPress Trac noreply at wordpress.org
Wed Feb 5 03:28:46 UTC 2020

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

Comment (by SergeyBiryukov):

 In [changeset:"47183" 47183]:
 #!CommitTicketReference repository="" revision="47183"
 Tests: Allow `wpdb::set_sql_mode()` tests to run on MySQL 8.0.11+.

 MySQL 8.0.11 removed support for the `NO_AUTO_CREATE_USER` SQL mode, which
 was used in as an example of a mode compatible with WordPress.

 `NO_AUTO_VALUE_ON_ZERO` is now used in the affected tests instead, which
 is supported on both MySQL 5.7.x and 8.0.x.

 Props kaggdesign, jeremyfelt, afragen.
 Fixes #44586. See #49344.

Ticket URL: <https://core.trac.wordpress.org/ticket/49344#comment:4>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform

More information about the wp-trac mailing list