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
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
|
/**
* Basic js tests for the collMod command.
* Test modifying TTL indexes.
*
* @tags: [
* # Cannot implicitly shard accessed collections because of collection existing when none
* # expected.
* assumes_no_implicit_collection_creation_after_drop,
*
* requires_non_retryable_commands,
* requires_ttl_index,
* ]
*/
function debug(x) {
// printjson( x );
}
var coll = "collModTest";
var t = db.getCollection(coll);
t.drop();
var isMongos = ("isdbgrid" == db.runCommand("hello").msg);
db.createCollection(coll);
function findTTL(key, expireAfterSeconds) {
var all = t.getIndexes();
all = all.filter(function(z) {
return z.expireAfterSeconds == expireAfterSeconds && friendlyEqual(z.key, key);
});
return all.length == 1;
}
function findTTLByName(name, expireAfterSeconds) {
var all = t.getIndexes();
all = all.filter(function(z) {
return z.expireAfterSeconds == expireAfterSeconds && z.name == name;
});
return all.length == 1;
}
function findCollectionInfo() {
var all = db.getCollectionInfos();
all = all.filter(function(z) {
return z.name == t.getName();
});
assert.eq(all.length, 1);
return all[0];
}
// ensure we fail with gibberish options
assert.commandFailed(t.runCommand('collmod', {NotARealOption: 1}));
// add a TTL index
t.createIndex({a: 1}, {"name": "index1", "expireAfterSeconds": 50});
assert(findTTL({a: 1}, 50), "TTL index not added");
// try to modify it with a bad key pattern
var res =
db.runCommand({"collMod": coll, "index": {"keyPattern": "bad", "expireAfterSeconds": 100}});
debug(res);
assert.eq(0, res.ok, "mod shouldn't work with bad keypattern");
// Ensure collMod fails with a non-string indexName.
var res = db.runCommand({"collMod": coll, "index": {"indexName": 2, "expireAfterSeconds": 120}});
assert.commandFailed(res);
// try to modify it without expireAfterSeconds field
var res = db.runCommand({"collMod": coll, "index": {"keyPattern": {a: 1}}});
debug(res);
assert.eq(0, res.ok, "TTL mod shouldn't work without expireAfterSeconds");
// try to modify it with a non-numeric expireAfterSeconds field
var res =
db.runCommand({"collMod": coll, "index": {"keyPattern": {a: 1}, "expireAfterSeconds": "100"}});
debug(res);
assert.eq(0, res.ok, "TTL mod shouldn't work with non-numeric expireAfterSeconds");
// this time modifying should finally work
var res =
db.runCommand({"collMod": coll, "index": {"keyPattern": {a: 1}, "expireAfterSeconds": 100}});
debug(res);
assert(findTTL({a: 1}, 100), "TTL index not modified");
// Modify ttl index by name.
var res = db.runCommand({"collMod": coll, "index": {"name": "index1", "expireAfterSeconds": 500}});
assert(findTTL({a: 1}, 500), "TTL index not modified");
// Must specify key pattern or name.
assert.commandFailed(db.runCommand({"collMod": coll, "index": {}}));
// Not allowed to specify key pattern and name.
assert.commandFailed(db.runCommand({
"collMod": coll,
"index": {"keyPattern": {a: 1}, "name": "index1", "expireAfterSeconds": 1000}
}));
// try with new index, this time set expireAfterSeconds
t.dropIndex({a: 1});
t.createIndex({a: 1}, {"expireAfterSeconds": 50});
var res =
db.runCommand({"collMod": coll, "index": {"keyPattern": {a: 1}, "expireAfterSeconds": 100}});
debug(res);
assert(findTTL({a: 1}, 100), "TTL index should be 100 now");
// Tests for collmod over multiple indexes with the same key pattern.
t.drop();
assert.commandWorked(db.createCollection(coll));
t = db.getCollection(coll);
// It's odd to create multiple TTL indexes... but you can.
assert.commandWorked(t.createIndex({a: 1}, {name: "TTL", expireAfterSeconds: 60}));
assert.commandWorked(
t.createIndex({a: 1}, {name: "TTLfr", collation: {locale: "fr"}, expireAfterSeconds: 120}));
// Ensure that coll mod will not accept an ambiguous key pattern.
assert.commandFailed(
db.runCommand({collMod: coll, index: {keyPattern: {a: 1}, expireAfterSeconds: 240}}));
assert(!findTTL({a: 1}, 240), "TTL index modified.");
// Ensure that a single TTL index is modified by name.
assert.commandWorked(db.runCommand({collMod: coll, index: {name: "TTL", expireAfterSeconds: 100}}));
assert(findTTLByName("TTL", 100), "TTL index not modified.");
assert(findTTLByName("TTLfr", 120), "TTL index modified.");
// Fails with an unknown index name.
assert.commandFailed(
db.runCommand({collMod: coll, index: {name: "notaname", expireAfterSeconds: 100}}));
// Fails with an unknown key pattern.
assert.commandFailed(db.runCommand(
{collmod: coll, index: {keyPattern: {doesnotexist: 1}, expireAfterSeconds: 100}}));
|
