blob: e1f717a5f5a5d214837f44f6f0703ac5f123465b (
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
|
/**
* Tests that a sharded query targeted to a single shard will use passed-in skip.
*/
var st = new ShardingTest({shards: 2, mongos: 1});
var mongos = st.s0;
var admin = mongos.getDB("admin");
var collSharded = mongos.getCollection("testdb.collSharded");
var collUnSharded = mongos.getCollection("testdb.collUnSharded");
// Set up a sharded and unsharded collection
assert(admin.runCommand({enableSharding: collSharded.getDB() + ""}).ok);
printjson(admin.runCommand({movePrimary: collSharded.getDB() + "", to: st.shard0.shardName}));
assert(admin.runCommand({shardCollection: collSharded + "", key: {_id: 1}}).ok);
assert(admin.runCommand({split: collSharded + "", middle: {_id: 0}}).ok);
assert(admin.runCommand({moveChunk: collSharded + "", find: {_id: 0}, to: st.shard1.shardName}).ok);
function testSelectWithSkip(coll) {
for (var i = -100; i < 100; i++) {
assert.writeOK(coll.insert({_id: i}));
}
// Run a query which only requires 5 results from a single shard
var explain =
coll.find({_id: {$gt: 1}}).sort({_id: 1}).skip(90).limit(5).explain("executionStats");
assert.lt(explain.executionStats.nReturned, 90);
}
testSelectWithSkip(collSharded);
testSelectWithSkip(collUnSharded);
jsTest.log("DONE!");
st.stop();
|
