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

[WordPress Trac]

#51740: Test failures using MySQL 8
--------------------------+-----------------------------
 Reporter:  desrosj       |       Owner:  (none)
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Future Release
Component:  Database      |     Version:
 Severity:  normal        |  Resolution:
 Keywords:  needs-patch   |     Focuses:
--------------------------+-----------------------------

Comment (by SergeyBiryukov):

 Seems to be related to [https://bugs.mysql.com/bug.php?id=104387 Bug
 #104387 CHARACTER_SET_MISMATCH issue with regex comparisons].

 From the [https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-22.html
 MySQL 8.0.22 changelog]:
 > Regular expression functions such as `REGEXP_LIKE()` yielded
 inconsistent results with binary string arguments. These functions now
 reject binary strings with an error.
 ([https://bugs.mysql.com/bug.php?id=98951 Bug #98951],
 [https://bugs.mysql.com/bug.php?id=98950 Bug #98950])

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