[wp-trac] [WordPress Trac] #34871: dbDelta Lowercase KEY Keyword Duplicates Indexes

[WordPress Trac]

#34871: dbDelta Lowercase KEY Keyword Duplicates Indexes
--------------------------+--------------------------
 Reporter:  charlestonsw  |       Owner:  ocean90
     Type:  defect (bug)  |      Status:  closed
 Priority:  normal        |   Milestone:  4.6
Component:  Database      |     Version:  3.5.1
 Severity:  normal        |  Resolution:  fixed
 Keywords:                |     Focuses:  performance
--------------------------+--------------------------
Changes (by ocean90):

 * owner:   => ocean90
 * status:  new => closed
 * resolution:   => fixed


Comment:

 In [changeset:"37583"]:
 {{{
 #!CommitTicketReference repository="" revision="37583"
 Database: Normalize index definitions in `dbDelta()`.

 `dbDelta()` compares the index definitions against the result of `SHOW
 INDEX FROM $table_name`. This requires a specific format so indices are
 not unnecessarily re-created. This format wasn't ensured, until now.

 * Parse the raw index definition to extract the type, name and columns so
 a normalized definition can be built (#20263, #34873).
 * Standardize on uppercase types (#34871) and on 'KEY'. 'INDEX' is only a
 synonym for 'KEY'.
 * Escape index names with backticks (#20263).
 * Normalize columns: Ignore ASC and DESC definitions (#34959), remove
 whitespaces (#34869) and escape column names with backticks (#20263).
 * Add backticks to all index change queries (#20263).

 Props ocean90, pento, kurtpayne.
 Fixes #20263, #34869, #34871, #34873, #34959.
 }}}

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