WordPress.org

Make WordPress Core

Opened 18 months ago

Last modified 4 weeks ago

#44586 new defect (bug)

SQL mode test results broken in MySQL 8.0.11

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

Description

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.

Change History (2)

#1 @afragen
4 weeks ago

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

#2 @afragen
4 weeks ago

Related #44384

Note: See TracTickets for help on using tickets.