[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:  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


Comment:

 The failure in `test_set_sql_mode()` is caused by `NO_AUTO_CREATE_USER`,
 which is
 [https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-11.html#mysqld-8-0-11
 -deprecation-removal no longer supported as of MySQL 8.0.11]. The query
 results in an error:
 {{{
 SET SESSION sql_mode='IGNORE_SPACE,NO_AUTO_CREATE_USER'

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

 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