[wp-trac] [WordPress Trac] #44586: SQL mode test results broken in MySQL 8.0.11

[WordPress Trac]

#44586: SQL mode test results broken in MySQL 8.0.11
--------------------------+-----------------------------
 Reporter:  jeremyfelt    |       Owner:  SergeyBiryukov
     Type:  defect (bug)  |      Status:  closed
 Priority:  normal        |   Milestone:  5.4
Component:  Database      |     Version:
 Severity:  normal        |  Resolution:  fixed
 Keywords:  needs-patch   |     Focuses:
--------------------------+-----------------------------
Changes (by SergeyBiryukov):

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


Comment:

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