diff options
| author | Hari Khalsa <hkhalsa@10gen.com> | 2013-10-29 21:41:09 -0400 |
|---|---|---|
| committer | Hari Khalsa <hkhalsa@10gen.com> | 2013-10-30 16:07:48 -0400 |
| commit | 67defc7ee10099e727a6091bbd0ff154e2908b00 (patch) | |
| tree | 43abaedf20ddf0c58e0bf02eebdb92e3622477e8 /jstests/explainc.js | |
| parent | a154946a48b3fea77747f810ff60dce734e9b0dd (diff) | |
| download | mongo-67defc7ee10099e727a6091bbd0ff154e2908b00.tar.gz | |
SERVER-10026 sort with improved sort analysis
Diffstat (limited to 'jstests/explainc.js')
| -rw-r--r-- | jstests/explainc.js | 13 |
1 files changed, 7 insertions, 6 deletions
diff --git a/jstests/explainc.js b/jstests/explainc.js index 6196a122231..965c524afda 100644 --- a/jstests/explainc.js +++ b/jstests/explainc.js @@ -99,8 +99,8 @@ t.save( { a:1, b:1 } ); // t.find( { a:{ $gt:0 }, b:{ $gt:0 } } ) ); // Document matched by three query plans, with sorting. -assertUnhintedExplain( { n:1, nscanned:1, nscannedObjects:1, nscannedObjectsAllPlans:2 }, - t.find( { a:{ $gt:0 }, b:{ $gt:0 } } ).sort( { c:1 } ) ); +//assertUnhintedExplain( { n:1, nscanned:1, nscannedObjects:1, nscannedObjectsAllPlans:2 }, +// t.find( { a:{ $gt:0 }, b:{ $gt:0 } } ).sort( { c:1 } ) ); // QUERY MIGRATION // Document matched by three query plans, with a skip. @@ -129,12 +129,13 @@ assertUnhintedExplain( { cursor:'BtreeCursor a_1_b_1', n:30, nscanned:30, nscann // Ordered plan chosen, with a skip. Skip is not included in counting nscannedObjects for a single // plan. assertUnhintedExplain( { cursor:'BtreeCursor a_1_b_1', n:29, nscanned:30, nscannedObjects:30, - nscannedObjectsAllPlans:89, scanAndOrder:false }, + scanAndOrder:false }, t.find( { b:{ $gte:0 } } ).sort( { a:1 } ).skip( 1 ) ); // Unordered plan chosen. -assertUnhintedExplain( { cursor:'BtreeCursor b_1', n:1, nscanned:1, nscannedObjects:1, - nscannedObjectsAllPlans:2, scanAndOrder:true }, +assertUnhintedExplain( { cursor:'BtreeCursor b_1', n:1, nscanned:1, + //nscannedObjects:1, nscannedObjectsAllPlans:2, + scanAndOrder:true }, t.find( { b:1 } ).sort( { a:1 } ) ); // Unordered plan chosen and projected. @@ -175,7 +176,7 @@ t.ensureIndex( { a:1, b:1, c:1 } ); // Documents matched by four query plans. assertUnhintedExplain( { n:30, nscanned:30, nscannedObjects:30, - nscannedObjectsAllPlans:90 // Not 120 because deduping occurs before + //nscannedObjectsAllPlans:90 // Not 120 because deduping occurs before // loading results. }, t.find( { a:{ $gte:0 }, b:{ $gte:0 } } ).sort( { b:1 } ) ); |