diff options
Diffstat (limited to 'jstests/distinct_index1.js')
-rw-r--r-- | jstests/distinct_index1.js | 50 |
1 files changed, 50 insertions, 0 deletions
diff --git a/jstests/distinct_index1.js b/jstests/distinct_index1.js new file mode 100644 index 0000000..8677457 --- /dev/null +++ b/jstests/distinct_index1.js @@ -0,0 +1,50 @@ + +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" ) |