[wp-trac] [WordPress Trac] #34692: Unknown system variable storage_engine when running tests in MySQL 5.7

[WordPress Trac]

#34692: Unknown system variable storage_engine when running tests in MySQL 5.7
------------------------------+----------------------------
 Reporter:  jeremyfelt        |      Owner:
     Type:  defect (bug)      |     Status:  new
 Priority:  normal            |  Milestone:  Future Release
Component:  Build/Test Tools  |    Version:
 Severity:  normal            |   Keywords:  has-patch
  Focuses:                    |
------------------------------+----------------------------
 The MySQL system variable `storage_engine` was [http://mysqlserverteam.com
 /removal-and-deprecation-in-mysql-5-7/ removed in 5.7] after being
 deprecated in 5.5. The following error is shown when running our tests
 with MySQL 5.7:

 {{{
 PHPUnit_Framework_Exception: WordPress database error Unknown system
 variable 'storage_engine' for query SET storage_engine = INNODB
 }}}

 It looks like we should be able to convert our use to
 `default_storage_engine` when setting up WordPress for unit tests.

 Related #30462

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