[COMPASS-5830] Do not pass `unique` option with columnstore indexes Created: 16/May/22  Updated: 29/Oct/23  Resolved: 17/May/22

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

Type: Bug Priority: Major - P3
Reporter: Rhys Howell Assignee: Rhys Howell
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Related
is related to COMPASS-5665 Support the management of Columnar In... Closed
Epic Link: COMPASS-5479
Story Points: 3
Documentation Changes: Not Needed
Sprint: Iteration Barnacle

 Description   

Currently we're passing the `unique` option = false when creating columnstore indexes in Compass. This errors with `Index type 'columnstore' does not support the 'unique' option.`

We should remove the unique field instead of passing false. We should also disable the `unique` ui checkbox option when columnstore indexes are in use.



 Comments   
Comment by Githook User [ 19/May/22 ]

Author:

{'name': 'Rhys', 'email': 'Anemy@users.noreply.github.com', 'username': 'Anemy'}

Message: fix(compass-indexes): remove unique option on columnstore index creation COMPASS-5830 (#3098)
Branch: update-compass-crud-to-shared-config
https://github.com/mongodb-js/compass/commit/5f1e7cdbee83ee272b8313dafa58479454dcfcf0

Comment by Githook User [ 18/May/22 ]

Author:

{'name': 'Rhys', 'email': 'Anemy@users.noreply.github.com', 'username': 'Anemy'}

Message: fix(compass-indexes): remove unique option on columnstore index creation COMPASS-5830 (#3098)
Branch: COMPASS-5788-show-explain-results
https://github.com/mongodb-js/compass/commit/5f1e7cdbee83ee272b8313dafa58479454dcfcf0

Comment by Githook User [ 18/May/22 ]

Author:

{'name': 'Rhys', 'email': 'Anemy@users.noreply.github.com', 'username': 'Anemy'}

Message: fix(compass-indexes): remove unique option on columnstore index creation COMPASS-5830 (#3098)
Branch: compass-5831-enable-new-toolbar
https://github.com/mongodb-js/compass/commit/5f1e7cdbee83ee272b8313dafa58479454dcfcf0

Comment by Githook User [ 17/May/22 ]

Author:

{'name': 'Rhys', 'email': 'Anemy@users.noreply.github.com', 'username': 'Anemy'}

Message: fix(compass-indexes): remove unique option on columnstore index creation COMPASS-5830 (#3098)
Branch: main
https://github.com/mongodb-js/compass/commit/5f1e7cdbee83ee272b8313dafa58479454dcfcf0

Comment by Githook User [ 17/May/22 ]

Author:

{'name': 'Rhys', 'email': 'Anemy@users.noreply.github.com', 'username': 'Anemy'}

Message: Merge branch 'main' into COMPASS-5830-fix-columnstore-index-creation
Branch: COMPASS-5830-fix-columnstore-index-creation
https://github.com/mongodb-js/compass/commit/d93e0d0649e9abee64d3b1e143665561c81d624e

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