Loading...

XML

Word

Printable

JSON

Operating System:
ALL
Steps To Reproduce:

Hide

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\" }" }})

Show
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\" }" }})

Duplicate key error message reports the key value in unreadable form. This occurs if an index created with collation.

duplicates

SERVER-26050 Unique key violation for index with a non-simple collation has unclear error message