Skip to content
This repository has been archived by the owner on Jan 6, 2023. It is now read-only.

Update unique field creates multiple indexes #578

Closed
lrkwz opened this issue Nov 9, 2018 · 0 comments
Closed

Update unique field creates multiple indexes #578

lrkwz opened this issue Nov 9, 2018 · 0 comments
Labels
bug Something isn't working

Comments

@lrkwz
Copy link

lrkwz commented Nov 9, 2018

Bug Report

Steps to Reproduce

  1. Create a collection named test
  2. Add a unique field named code
  3. execute in mysql SHOW CREATE TABLE test on the collection you created, there is a single UNIQUE KEY index on the field
  4. Update any attribute of the field
  5. repeat SHOW CREATE TABLE test on the updated collection, now there are two UNIQUE KEY indexes

Expected Behavior

A single UNIQUE KEY index per unique field

Actual Behavior

As many UNIQUE KEY indexes as many updates you execute

Technical Details

  • Device: desktop
  • OS: ubuntu 18.04
  • Web Server: docker image 2.0.5
  • PHP Version: docker image 2.0.5
  • Database: docker image 2.0.5
  • Install Method: docker image 2.0.5
@benhaynes benhaynes added the bug Something isn't working label Nov 12, 2018
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants