[COMPASS-3870] Default names for compound indexes are incorrect Created: 04/Sep/19  Updated: 29/Oct/23  Resolved: 27/Sep/19

Status: Closed
Project: Compass
Component/s: Indexes
Affects Version/s: None
Fix Version/s: 1.20.0

Type: Bug Priority: Major - P3
Reporter: Ronan Bohan Assignee: Durran Jordan
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File MongoDB_Compass_-_m30-bfib2_mongodb_net_27017.png    
Sprint: Iteration Newt

 Description   

Playing around with index creation in the latest version of Compass that I've just downloaded (v 1.19.6) I noted that the default name for compound indexes only uses the name of the first field rather than the names of all fields in the index.



 Comments   
Comment by Githook User [ 27/Sep/19 ]

Author:

{'username': 'durran', 'email': 'durran@gmail.com', 'name': 'Durran Jordan'}

Message: COMPASS-3870/3914/3915/3881 backporting
Branch: 1.20-releases
https://github.com/mongodb-js/compass/commit/aeb1957c3e5a097c462928bb68bc82f335359242

Comment by Githook User [ 27/Sep/19 ]

Author:

{'username': 'durran', 'email': 'durran@gmail.com', 'name': 'Durran Jordan'}

Message: COMPASS-3870: Generate correct compound index names
Branch: master
https://github.com/mongodb-js/compass/commit/c7c25a07aea0bd423efc95519c42e6c88aeb183a

Comment by Githook User [ 27/Sep/19 ]

Author:

{'username': 'durran', 'email': 'durran@gmail.com', 'name': 'Durran Jordan'}

Message: COMPASS-3870: Generate correct compound index names
Branch: bug-fixes
https://github.com/mongodb-js/compass/commit/1a036d383053d5e9329f5c6b84572190278a8041

Comment by Githook User [ 27/Sep/19 ]

Author:

{'name': 'Durran Jordan', 'username': 'durran', 'email': 'durran@gmail.com'}

Message: COMPASS-3870: Generate correct compound index names
Branch: bug-fixes
https://github.com/mongodb-js/compass/commit/14062c6806ed6ad8f752609f6a19507611d26dc7

Comment by Ronan Bohan [ 04/Sep/19 ]

See this example:

Specifically the index was created in Compass using fields score and gamertag but the index was named score_1. I only noticed this because I already had a score_1 index (on just the score field) and it wouldn't let me create a second index with the same name. The expected behavior here is that the compound index should be called score_1_gamertag_1

Generated at Wed Feb 07 22:34:31 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.