Loading...

XML

Word

Printable

JSON

Assigned Teams:

Server Triage
Operating System:
ALL
Steps To Reproduce:
Hide

Used the mongo shell on powershell.

> use test switched to db test > db.testCol.createIndex( { "name": "text" } , { unique: true } ); { "createdCollectionAutomatically" : true, "numIndexesBefore" : 1, "numIndexesAfter" : 2, "ok" : 1 } > db.testCol.insert( {"name": "test co"} ) WriteResult( { "nInserted" : 1 }) > db.testCol.insert( {"name": "test2 co"}) WriteResult({ "nInserted" : 0, "writeError" : { "code" : 11000, "errmsg" : "E11000 duplicate key error collection: test.testCol index: name_text dup key: { : \"co\", : 0.75 }" } })
Show
Used the mongo shell on powershell. > use test switched to db test > db.testCol.createIndex( { "name": "text" } , { unique: true } ); { "createdCollectionAutomatically" : true, "numIndexesBefore" : 1, "numIndexesAfter" : 2, "ok" : 1 } > db.testCol.insert( {"name": "test co"} ) WriteResult( { "nInserted" : 1 }) > db.testCol.insert( {"name": "test2 co"}) WriteResult({ "nInserted" : 0, "writeError" : { "code" : 11000, "errmsg" : "E11000 duplicate key error collection: test.testCol index: name_text dup key: { : \"co\", : 0.75 }" } })

Applying a unique index to a single text field has unexpected behavior with spaces.

OS: Windows 10

For example:

Inserting "test co" and "test2 co" fail uniqueness.

Inserting " co" and " co" fail uniqueness.

Participants:: [HELP ONLY] Backlog - Triage Team, Andy Schwerin, Mathew Cabutage [X]