[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        |  Resolution:
 Keywords:  needs-patch   |     Focuses:
--------------------------+-----------------------------

Comment (by afragen):

 I can replicate this as well as an additional DB test failure. I am using
 MySQL 8.0.16 locally.

 {{{
 There were 3 failures:

 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/abstract-testcase.php:682
 .../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:343

 3) Tests_dbDelta::test_spatial_indices
 Failed asserting that an array is empty.

 .../tests/phpunit/tests/dbdelta.php:576
 }}}

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