Info
Duplicate key error message reports the key value in unreadable form. This occurs if an index created with collation.
Top User Comments
asya commented on Fri, 18 May 2018 20:17:27 +0000:
This seems to be a duplicate of SERVER-26050
Steps to Reproduce
db.createCollection('people')
db.people.insert({userName: 'Bob'})
db.people.insert({userName: 'Sally'})
db.people.createIndex({userName: 1}, {unique: true, collation: { locale: 'en', strength: 2}})
db.people.insert({userName: 'BOB'})
The last method throws the error:
WriteResult({WriteResult({ "nInserted" : 0, "writeError" : { "code" : 11000, "errmsg" : "E11000 duplicate key error collection: members.people index: userName_1 dup key: { : \"E\u0001\u0007\" }" }})
Expected:
WriteResult({WriteResult({ "nInserted" : 0, "writeError" : { "code" : 11000, "errmsg" : "E11000 duplicate key error collection: members.people index: userName_1 dup key: { : \"BOB\" }" }})
