WordPress.org

Make WordPress Core

Opened 17 months 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 (0)

Note: See TracTickets for help on using tickets.