[wp-trac] [WordPress Trac] #34874: dbDelta Case Sensitive Key Names Duplicates Indexes

[WordPress Trac]

#34874: dbDelta Case Sensitive Key Names Duplicates Indexes
--------------------------+------------------------------
 Reporter:  charlestonsw  |       Owner:
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  Database      |     Version:  3.5.1
 Severity:  normal        |  Resolution:
 Keywords:                |     Focuses:  performance
--------------------------+------------------------------

Comment (by jdgrimes):

 I can confirm that this bug is still present in trunk.

 From the [https://dev.mysql.com/doc/refman/5.6/en/identifier-case-
 sensitivity.html MySQL reference]:

 > Column, index, stored routine, and event names are not case sensitive on
 any platform, nor are column aliases.

 So this ticket is correct that we shouldn't be treating indexes as if they
 are case sensitive.

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