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

WordPress Trac noreply at wordpress.org
Tue Feb 4 02:13:23 UTC 2020

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

 * owner:  (none) => SergeyBiryukov
 * status:  new => reviewing
 * milestone:  Future Release => 5.4


 The failure in `test_set_sql_mode()` is caused by `NO_AUTO_CREATE_USER`,
 which is
 -deprecation-removal no longer supported as of MySQL 8.0.11]. The query
 results in an error:

 #1231 - Variable 'sql_mode' can't be set to the value of

 Replacing it with `NO_AUTO_VALUE_ON_ZERO`, which is available on both
 MySQL 5.7 and 8.0, works as expected.

 See comment:3:ticket:49344 and the patch on #49344 for more details.

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

More information about the wp-trac mailing list