mirror of https://github.com/mongodb/mongo
77 lines
2.4 KiB
JavaScript
77 lines
2.4 KiB
JavaScript
// @tags: [
|
|
// # Cannot implicitly shard accessed collections because of not being able to create unique
|
|
// # index using hashed shard key pattern.
|
|
// cannot_create_unique_index_when_using_hashed_shard_key,
|
|
// requires_fastcount,
|
|
//
|
|
// # Uses index building in background
|
|
// requires_background_index,
|
|
// # Time series collections do not support unique indexes.
|
|
// exclude_from_timeseries_crud_passthrough,
|
|
// ]
|
|
|
|
let res;
|
|
|
|
const collNamePrefix = "jstests_uniqueness_";
|
|
let collCount = 0;
|
|
let t = db.getCollection(collNamePrefix + collCount++);
|
|
t.drop();
|
|
|
|
// test uniqueness of _id
|
|
|
|
res = t.save({_id: 3});
|
|
assert.commandWorked(res);
|
|
|
|
// this should yield an error
|
|
res = t.insert({_id: 3});
|
|
assert.writeError(res);
|
|
assert.eq(1, t.count());
|
|
|
|
res = t.insert({_id: 4, x: 99});
|
|
assert.commandWorked(res);
|
|
|
|
// this should yield an error
|
|
res = t.update({_id: 4}, {_id: 3, x: 99});
|
|
assert.writeError(res);
|
|
assert(t.findOne({_id: 4}));
|
|
|
|
// Check for an error message when we index and there are dups
|
|
t = db.getCollection(collNamePrefix + collCount++);
|
|
t.drop();
|
|
assert.commandWorked(t.insert({_id: 0, a: 3}));
|
|
assert.commandWorked(t.insert({_id: 1, a: 3}));
|
|
assert.eq(2, t.find().itcount());
|
|
res = t.createIndex({a: 1}, true);
|
|
assert.commandFailed(res);
|
|
assert(res.errmsg.match(/E11000/));
|
|
|
|
// Verify that duplicate key errors follow a fixed format, including field information.
|
|
t = db.getCollection(collNamePrefix + collCount++);
|
|
t.drop();
|
|
const key = {
|
|
_id: 1,
|
|
};
|
|
const expectedMessage = "E11000 duplicate key error collection: " + t + " index: _id_ dup key: { _id: 1.0 }";
|
|
assert.commandWorked(t.insert(key));
|
|
res = t.insert(key);
|
|
assert.commandFailedWithCode(res, ErrorCodes.DuplicateKey);
|
|
assert.eq(res.nInserted, 0, tojson(res));
|
|
const writeError = res.getWriteError();
|
|
assert.includes(writeError.errmsg, expectedMessage, tojson(res));
|
|
|
|
/* Check that if we update and remove _id, it gets added back by the DB */
|
|
|
|
/* - test when object grows */
|
|
t = db.getCollection(collNamePrefix + collCount++);
|
|
t.drop();
|
|
assert.commandWorked(t.save({_id: "Z"}));
|
|
assert.commandWorked(t.update({}, {k: 2}));
|
|
assert.eq("Z", t.findOne()._id, "uniqueness.js problem with adding back _id");
|
|
|
|
/* - test when doesn't grow */
|
|
t = db.getCollection(collNamePrefix + collCount++);
|
|
t.drop();
|
|
assert.commandWorked(t.save({_id: "Z", k: 3}));
|
|
assert.commandWorked(t.update({}, {k: 2}));
|
|
assert.eq("Z", t.findOne()._id, "uniqueness.js problem with adding back _id (2)");
|