diff options
Diffstat (limited to 'jstests/core/hint1.js')
| -rw-r--r-- | jstests/core/hint1.js | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/jstests/core/hint1.js b/jstests/core/hint1.js new file mode 100644 index 00000000000..b5a580f2b93 --- /dev/null +++ b/jstests/core/hint1.js @@ -0,0 +1,16 @@ + +p = db.jstests_hint1; +p.drop(); + +p.save( { ts: new Date( 1 ), cls: "entry", verticals: "alleyinsider", live: true } ); +p.ensureIndex( { ts: 1 } ); + +e = p.find( { live: true, ts: { $lt: new Date( 1234119308272 ) }, cls: "entry", verticals: "alleyinsider" } ).sort( { ts: -1 } ).hint( { ts: 1 } ).explain(); +assert.eq(e.indexBounds.ts[0][0].getTime(), new Date(1234119308272).getTime(), "A"); + +//printjson(e); + +assert.eq( /*just below min date is bool true*/true, e.indexBounds.ts[0][1], "B"); + +assert.eq(1, p.find({ live: true, ts: { $lt: new Date(1234119308272) }, cls: "entry", verticals: "alleyinsider" }).sort({ ts: -1 }).hint({ ts: 1 }).count()); + |