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
|
t = db.distinct_index1
t.drop();
function r( x ){
return Math.floor( Math.sqrt( x * 123123 ) ) % 10;
}
function d( k , q ){
return t.runCommand( "distinct" , { key : k , query : q || {} } )
}
for ( i=0; i<1000; i++ ){
o = { a : r(i*5) , b : r(i) };
t.insert( o );
}
x = d( "a" );
assert.eq( 1000 , x.stats.n , "AA1" )
assert.eq( 1000 , x.stats.nscanned , "AA2" )
assert.eq( 1000 , x.stats.nscannedObjects , "AA3" )
x = d( "a" , { a : { $gt : 5 } } );
assert.eq( 398 , x.stats.n , "AB1" )
assert.eq( 1000 , x.stats.nscanned , "AB2" )
assert.eq( 1000 , x.stats.nscannedObjects , "AB3" )
x = d( "b" , { a : { $gt : 5 } } );
assert.eq( 398 , x.stats.n , "AC1" )
assert.eq( 1000 , x.stats.nscanned , "AC2" )
assert.eq( 1000 , x.stats.nscannedObjects , "AC3" )
t.ensureIndex( { a : 1 } )
x = d( "a" );
assert.eq( 1000 , x.stats.n , "BA1" )
assert.eq( 1000 , x.stats.nscanned , "BA2" )
assert.eq( 0 , x.stats.nscannedObjects , "BA3" )
x = d( "a" , { a : { $gt : 5 } } );
assert.eq( 398 , x.stats.n , "BB1" )
assert.eq( 398 , x.stats.nscanned , "BB2" )
assert.eq( 0 , x.stats.nscannedObjects , "BB3" )
x = d( "b" , { a : { $gt : 5 } } );
assert.eq( 398 , x.stats.n , "BC1" )
assert.eq( 398 , x.stats.nscanned , "BC2" )
assert.eq( 398 , x.stats.nscannedObjects , "BC3" )
// Check proper nscannedObjects count when using a query optimizer cursor.
t.dropIndexes();
t.ensureIndex( { a : 1, b : 1 } );
x = d( "b" , { a : { $gt : 5 }, b : { $gt : 5 } } );
assert.eq( "QueryOptimizerCursor", x.stats.cursor );
assert.eq( 171 , x.stats.n )
assert.eq( 275 , x.stats.nscanned )
// Disable temporarily - exact value doesn't matter.
// assert.eq( 266 , x.stats.nscannedObjects )
|
