-
Type: Question
-
Resolution: Done
-
Priority: Major - P3
-
None
-
Affects Version/s: 3.2.1
-
Component/s: Index Maintenance
-
None
I have this index setup:
{ "_fts" : "text", "_ftsx" : 1, "SiteId" : 1 }
unique.
I could only create it if I dont have _fts field with values like: archive-collections-2
When I try to:
> db.post.update({FriendlyUrl:'archivecollections2'},{$set:{FriendlyUrl:'archive-collections-2'}})
I get:
WriteResult({ "nMatched" : 0, "nUpserted" : 0, "nModified" : 0, "writeError" : { "code" : 11000, "errmsg" : "E11000 duplicate key error collection: BlackAndWhite _ROC.post index: FriendlyUrl_text_SiteId_1 dup key: { : \"2\", : 0.6666666666666 666, : 20 }" } })
Notice it's using only \"2\" and thus it violates the unique constraint.
Is this supposed to happen?
Why is it not using the full archive-collections-2 ?
Thank you!
- is related to
-
SERVER-23619 Allow the delimiter set recognized by text search tokenizer to be configurable
- Backlog