[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:  (none)
     Type:  defect (bug)  |     Status:  new
 Priority:  normal        |  Milestone:  Future Release
Component:  Database      |    Version:
 Severity:  normal        |   Keywords:  needs-patch
  Focuses:                |
--------------------------+----------------------------
 I have 2 failing tests related to SQL modes when using MySQL 8.0.11
 locally:

 {{{
 1) Tests_DB::test_set_sql_mode
 Failed asserting that two arrays are equal.
 --- Expected
 +++ Actual
 @@ @@
  Array (
 -    0 => 'IGNORE_SPACE'
 -    1 => 'NO_AUTO_CREATE_USER'
 +    0 => 'ERROR_FOR_DIVISION_BY_ZERO'
 +    1 => 'NO_ENGINE_SUBSTITUTION'
 +    2 => 'NO_ZERO_IN_DATE'

 /tests/phpunit/includes/testcase.php:533
 /tests/phpunit/tests/db.php:303

 2) Tests_DB::test_set_allowed_incompatible_sql_mode
 Failed asserting that an array contains 'ONLY_FULL_GROUP_BY'.

 /tests/phpunit/tests/db.php:345
 }}}

 A 3rd test failure is documented as part of #44384.

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