summaryrefslogtreecommitdiff
path: root/jstests/core/index_id_options.js
blob: 9bbf3a2d31170db1862021aef5859dd76072435f (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
// Cannot implicitly shard accessed collections because of collection existing when none
// expected.
// @tags: [assumes_no_implicit_collection_creation_after_drop]

// Test creation of the _id index with various options:
// - _id indexes must have key pattern {_id: 1}.
// - The name of an _id index gets corrected to "_id_".
// - _id indexes cannot have any options other than "key", "name", "ns", "v", and "collation".
// - _id indexes must have the collection default collation.
// - Non-_id indexes cannot have the name "_id_".

(function() {
    "use strict";

    load("jstests/libs/get_index_helpers.js");

    var coll = db.index_id_options;

    // _id indexes must have key pattern {_id: 1}.
    coll.drop();
    assert.commandWorked(coll.runCommand("create", {autoIndexId: false}));
    assert.commandFailed(coll.ensureIndex({_id: -1}, {name: "_id_"}));

    // The name of an _id index gets corrected to "_id_".
    coll.drop();
    assert.commandWorked(coll.runCommand("create", {autoIndexId: false}));
    assert.commandWorked(coll.ensureIndex({_id: 1}, {name: "bad"}));
    var spec = GetIndexHelpers.findByKeyPattern(coll.getIndexes(), {_id: 1});
    assert.neq(null, spec, "_id index spec not found");
    assert.eq("_id_", spec.name, tojson(spec));

    // _id indexes cannot have any options other than "key", "name", "ns", "v", and "collation."
    coll.drop();
    assert.commandWorked(coll.runCommand("create", {autoIndexId: false}));
    assert.commandFailed(coll.ensureIndex({_id: 1}, {name: "_id_", unique: true}));
    assert.commandFailed(coll.ensureIndex({_id: 1}, {name: "_id_", sparse: false}));
    assert.commandFailed(
        coll.ensureIndex({_id: 1}, {name: "_id_", partialFilterExpression: {a: 1}}));
    assert.commandFailed(coll.ensureIndex({_id: 1}, {name: "_id_", expireAfterSeconds: 3600}));
    assert.commandFailed(coll.ensureIndex({_id: 1}, {name: "_id_", background: false}));
    assert.commandFailed(coll.ensureIndex({_id: 1}, {name: "_id_", unknown: true}));
    assert.commandWorked(coll.ensureIndex(
        {_id: 1}, {name: "_id_", ns: coll.getFullName(), v: 2, collation: {locale: "simple"}}));

    // _id indexes must have the collection default collation.
    coll.drop();
    assert.commandWorked(coll.runCommand("create", {autoIndexId: false}));
    assert.commandFailed(coll.ensureIndex({_id: 1}, {name: "_id_", collation: {locale: "en_US"}}));
    assert.commandWorked(coll.ensureIndex({_id: 1}, {name: "_id_", collation: {locale: "simple"}}));

    coll.drop();
    assert.commandWorked(coll.runCommand("create", {autoIndexId: false}));
    assert.commandWorked(coll.ensureIndex({_id: 1}, {name: "_id_"}));

    coll.drop();
    assert.commandWorked(
        coll.runCommand("create", {autoIndexId: false, collation: {locale: "en_US"}}));
    assert.commandFailed(coll.ensureIndex({_id: 1}, {name: "_id_", collation: {locale: "simple"}}));
    assert.commandFailed(coll.ensureIndex({_id: 1}, {name: "_id_", collation: {locale: "fr_CA"}}));
    assert.commandWorked(
        coll.ensureIndex({_id: 1}, {name: "_id_", collation: {locale: "en_US", strength: 3}}));

    coll.drop();
    assert.commandWorked(
        coll.runCommand("create", {autoIndexId: false, collation: {locale: "en_US"}}));
    assert.commandWorked(coll.ensureIndex({_id: 1}, {name: "_id_"}));
    spec = GetIndexHelpers.findByName(coll.getIndexes(), "_id_");
    assert.neq(null, spec, "_id index spec not found");
    assert.eq("en_US", spec.collation.locale, tojson(spec));

    // Non-_id indexes cannot have the name "_id_".
    coll.drop();
    assert.commandWorked(coll.runCommand("create", {autoIndexId: false}));
    assert.commandFailed(coll.ensureIndex({_id: "hashed"}, {name: "_id_"}));
    assert.commandFailed(coll.ensureIndex({a: 1}, {name: "_id_"}));
})();