[wp-trac] [WordPress Trac] #10404: dbDelta creates duplicate indexes when index definition contains spaces

[WordPress Trac]

#10404: dbDelta creates duplicate indexes when index definition contains spaces
-------------------------------+-----------------------------
 Reporter:  Denis-de-Bernardy  |       Owner:
     Type:  enhancement        |      Status:  new
 Priority:  normal             |   Milestone:  Future Release
Component:  Database           |     Version:  2.8.1
 Severity:  normal             |  Resolution:
 Keywords:  has-patch          |     Focuses:
-------------------------------+-----------------------------

Comment (by charlestonsw):

 file: 10404_case_sensitivity_fix_CORRECT_4_1.diff

 Added a patch based on 4.1 source to address the case sensitivity issue on
 the KEY and index names.   This will prevent the following from creating
 duplicate indices with dbDelta():

 CREATE ... key (A,A);
 CREATE ... KEY (B,B);

 Tested in 4.1 via manual code test.

 Do we need to add phpUnit testing?

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