[wp-trac] [WordPress Trac] #35958: Failing dbDelta tests due to MySQL error

[WordPress Trac]

#35958: Failing dbDelta tests due to MySQL error
--------------------------+-----------------------------
 Reporter:  johnbillion   |      Owner:
     Type:  defect (bug)  |     Status:  new
 Priority:  normal        |  Milestone:  Awaiting Review
Component:  Database      |    Version:
 Severity:  normal        |   Keywords:
  Focuses:                |
--------------------------+-----------------------------
 The `Tests_dbDelta` tests are failing on my local test setup (they have
 been for a while now, and I had been ignoring them due to assuming I'd
 messed something up).

 The culprit for the failures is this MySQL error when creating the test
 table in `Tests_dbDelta::setUp()`:

 {{{
 #1071 - Specified key was too long; max key length is 1000 bytes
 }}}

 The query looks like this:

 {{{
 CREATE TABLE wptests_dbdelta_test (
         id bigint(20) NOT NULL AUTO_INCREMENT,
         column_1 varchar(255) NOT NULL,
         PRIMARY KEY  (id),
         KEY key_1 (column_1),
         KEY compound_key (id,column_1),
         FULLTEXT KEY fulltext_key (column_1)
 ) ENGINE=MyISAM
 }}}

 Is this an environment problem or is there a bug in the tests which
 doesn't take into account this key length limit?

 '''Environment:'''

  * MySQL server: 5.5.44
  * MySQL client: 50624 (5.6.24)
  * PHP: 5.6.99-hhvm
  * Web server: Nginx 1.9.5
  * OS: OS X 10.10.3

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