[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          |
-------------------------------+-----------------------------

Comment (by charlestonsw):

 Revised patch added.

 There are some phpDoc updates, more comments, and only a couple of lines
 of code changed to call strtoupper() in the appropriate places.

 Still coding and testing a patch to help convert simple index creation
 statements like "KEY (id)" to the meta data generated "KEY id (id)"
 pattern to eliminate the mis-match on simple keys.

--
Ticket URL: <http://core.trac.wordpress.org/ticket/10404#comment:12>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software