[wp-trac] [WordPress Trac] #38032: dbDelta() unit tests lock on MySQL 8.0

[WordPress Trac]

#38032: dbDelta() unit tests lock on MySQL 8.0
------------------------------+----------------------------
 Reporter:  pento             |      Owner:
     Type:  defect (bug)      |     Status:  new
 Priority:  normal            |  Milestone:  Future Release
Component:  Build/Test Tools  |    Version:
 Severity:  normal            |   Keywords:
  Focuses:                    |
------------------------------+----------------------------
 `Tests_dbDelta` fails when running against MySQL 8.0.

 {{{
 WordPress database error Lock wait timeout exceeded; try restarting
 transaction for query
                         CREATE TABLE wptests_dbdelta_test (
                                 id bigint(20) NOT NULL AUTO_INCREMENT,
                                 column_1 varchar(255) NOT NULL,
                                 column_2 text,
                                 column_3 blob,
                                 PRIMARY KEY  (id),
                                 KEY key_1 (column_1),
                                 KEY compound_key (id,column_1),
                                 FULLTEXT KEY fulltext_key (column_1)
                         ) ENGINE=MyISAM
                          made by PHPUnit_TextUI_Command::main,
 PHPUnit_TextUI_Command->run, PHPUnit_TextUI_TestRunner->doRun,
 PHPUnit_Framework_TestSuite->run, PHPUnit_Framework_TestSuite->run,
 PHPUnit_Framework_TestCase->run, PHPUnit_Framework_TestResult->run,
 PHPUnit_Framework_TestCase->runBare, Tests_dbDelta->setUp
 }}}

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