[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:  task (blessed)     |      Status:  new           
 Priority:  normal             |   Milestone:  Future Release
Component:  General            |     Version:  2.8.1         
 Severity:  normal             |    Keywords:                
-------------------------------+--------------------------------------------
Changes (by nacin):

  * keywords:  needs-testing =>
  * type:  defect (bug) => task (blessed)
  * milestone:  2.9 => Future Release


Comment:

 Patch does nothing, I jumped the gun there. The big problem here is that
 dbDelta wants exacting whitespace standards. The two spaces after
 "PRIMARY" is documented in the codex, but it also expects exactly one
 space elsewhere, and as you can see here, exactly no spaces separating
 field names in an index.

 I'm setting this to Future Release and a blessed task to see if someone
 will pick it up, document dbDelta, and make it less fussy over whitespace.

 See also #11322. At the very least, $wp_queries should lead by example.

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