diff options
Diffstat (limited to 'jstests/core/find8.js')
-rw-r--r-- | jstests/core/find8.js | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/jstests/core/find8.js b/jstests/core/find8.js new file mode 100644 index 00000000000..60f66a500e3 --- /dev/null +++ b/jstests/core/find8.js @@ -0,0 +1,27 @@ +// SERVER-1932 Test unindexed matching of a range that is only valid in a multikey context. + +t = db.jstests_find8; +t.drop(); + +t.save( {a:[1,10]} ); +assert.eq( 1, t.count( { a: { $gt:2,$lt:5} } ) ); + +// Check that we can do a query with 'invalid' range. +assert.eq( 1, t.count( { a: { $gt:5,$lt:2} } ) ); + +t.save( {a:[-1,12]} ); + +// Check that we can do a query with 'invalid' range and sort. +assert.eq( 2, t.find( { a: { $gt:5,$lt:2} } ).sort( {a:1} ).itcount() ); +assert.eq( 2, t.find( { a: { $gt:5,$lt:2} } ).sort( {$natural:-1} ).itcount() ); + +// SERVER-2864 +if( 0 ) { +t.find( { a: { $gt:5,$lt:2} } ).itcount(); +// Check that we can record a plan for an 'invalid' range. +assert( t.find( { a: { $gt:5,$lt:2} } ).explain( true ).oldPlan ); +} + +t.ensureIndex( {b:1} ); +// Check that if we do a table scan of an 'invalid' range in an or clause we don't check subsequent clauses. +assert.eq( "BasicCursor", t.find( { $or:[{ a: { $gt:5,$lt:2} }, {b:1}] } ).explain().cursor ); |