[wp-trac] [WordPress Trac] #54074: Slug index not set as unique in databse

[WordPress Trac]

#54074: Slug index not set as unique in databse
--------------------------+------------------------------
 Reporter:  odjuret       |       Owner:  (none)
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  Taxonomy      |     Version:  5.8
 Severity:  normal        |  Resolution:
 Keywords:  close         |     Focuses:  performance
--------------------------+------------------------------
Changes (by SergeyBiryukov):

 * keywords:   => close
 * component:  General => Taxonomy
 * severity:  critical => normal


Comment:

 Hi there, welcome to WordPress Trac! Thanks for the report.

 The `UNIQUE` constraint was intentionally removed from the `wp_terms`
 table in [30056] / #22023.

 This was the first step in a larger taxonomy overhaul that started in
 WordPress 4.1:
 * [https://make.wordpress.org/core/2013/07/28/potential-roadmap-for-
 taxonomy-meta-and-post-relationships/ Potential roadmap for taxonomy meta
 and post relationships]
 * [https://make.wordpress.org/core/2014/11/12/an-update-on-the-taxonomy-
 roadmap/ WordPress 4.1: An update on the taxonomy roadmap]
 * [https://make.wordpress.org/core/2015/02/16/taxonomy-term-splitting-
 in-4-2-a-developer-guide/ WordPress 4.2: Taxonomy term splitting in 4.2: a
 developer guide]
 * [https://make.wordpress.org/core/2015/06/09/eliminating-shared-taxonomy-
 terms-in-wordpress-4-3/ WordPress 4.3: Eliminating shared taxonomy terms]
 * [https://make.wordpress.org/core/2015/08/27/taxonomy-roadmap-for-4-4
 -and-beyond/ WordPress 4.4: Taxonomy roadmap for 4.4 and beyond]
 * [https://make.wordpress.org/core/2015/09/04/taxonomy-term-metadata-
 proposal/ WordPress 4.4: Taxonomy term metadata proposal]
 * [https://make.wordpress.org/core/2015/10/23/4-4-taxonomy-roundup/
 WordPress 4.4: Taxonomy Roundup]

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