WordPress.org

Make WordPress Core

Opened 5 months ago

Last modified 7 weeks ago

#51740 new defect (bug)

Test failures using MySQL 8

Reported by: desrosj Owned by:
Milestone: Future Release Priority: normal
Severity: normal Version:
Component: Database Keywords: needs-patch
Focuses: Cc:

Description

I was doing some 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 I added some var_dumps() to help debugging.

Change History (2)

#1 @SergeyBiryukov
5 months ago

Related to the first failure: #49364.

Previously: #44384, #49344.

Note: See TracTickets for help on using tickets.