[wp-trac] [WordPress Trac] #51741: Test failures using MySQL 8

[WordPress Trac]

#51741: Test failures using MySQL 8
--------------------------+----------------------------
 Reporter:  desrosj       |      Owner:  (none)
     Type:  defect (bug)  |     Status:  new
 Priority:  normal        |  Milestone:  Future Release
Component:  Database      |    Version:
 Severity:  normal        |   Keywords:  needs-patch
  Focuses:                |
--------------------------+----------------------------
 I was doing some [https://github.com/desrosj/wordpress-
 develop/actions/runs/354906995 experimenting adding multiple MySQL
 versions to the GitHub Action workflow matrix], and noticed that there are
 4 test failures in the local Docker environment when running MySQL 8.

 {{{

 1)
 Tests_dbDelta::test_wp_get_db_schema_does_no_alter_queries_on_existing_install
 Failed asserting that an array is empty.

 /var/www/tests/phpunit/tests/dbdelta.php:711

 2) Tests_Meta_Query::test_meta_type_key_should_be_passed_to_meta_query
 Failed asserting that two arrays are identical.
 --- Expected
 +++ Actual
 @@ @@
 -Array &0 (
 -    0 => 1424
 -)
 +Array &0 ()

 /var/www/tests/phpunit/includes/abstract-testcase.php:704
 /var/www/tests/phpunit/tests/meta/query.php:775

 3) Tests_Query_MetaQuery::test_compare_key_regexp_rlike
 Failed asserting that two arrays are identical.
 --- Expected
 +++ Actual
 @@ @@
 -Array &0 (
 -    0 => 36059
 -)
 +Array &0 ()

 /var/www/tests/phpunit/includes/abstract-testcase.php:704
 /var/www/tests/phpunit/tests/query/metaQuery.php:2126

 4) Tests_Query_MetaQuery::test_compare_key_not_regexp
 Failed asserting that two arrays are identical.
 --- Expected
 +++ Actual
 @@ @@
 -Array &0 (
 -    0 => 36063
 -    1 => 36064
 -)
 +Array &0 ()

 /var/www/tests/phpunit/includes/abstract-testcase.php:704
 /var/www/tests/phpunit/tests/query/metaQuery.php:2169
 }}}

 I haven't looked into the failures yet, but [https://github.com/desrosj
 /wordpress-develop/runs/1377073675?check_suite_focus=true I added some]
 `var_dumps()` to help debugging.

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