summaryrefslogtreecommitdiff
path: root/jstests/core/count5.js
blob: b89eb88d494076d8483b0f6660bb0c35ebe65752 (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
// @tags: [requires_fastcount]

t = db.count5;
t.drop();

for (i = 0; i < 100; i++) {
    t.save({x: i});
}

q = {
    x: {$gt: 25, $lte: 75}
};

assert.eq(50, t.find(q).count(), "A");
assert.eq(50, t.find(q).itcount(), "B");

t.ensureIndex({x: 1});

assert.eq(50, t.find(q).count(), "C");
assert.eq(50, t.find(q).itcount(), "D");

assert.eq(50, t.find(q).limit(1).count(), "E");
assert.eq(1, t.find(q).limit(1).itcount(), "F");

assert.eq(5, t.find(q).limit(5).size(), "G");
assert.eq(5, t.find(q).skip(5).limit(5).size(), "H");
assert.eq(2, t.find(q).skip(48).limit(5).size(), "I");

assert.eq(20, t.find().limit(20).size(), "J");

assert.eq(0, t.find().skip(120).size(), "K");
assert.eq(1, db.runCommand({count: "count5"})["ok"], "L");
assert.eq(1, db.runCommand({count: "count5", skip: 120})["ok"], "M");