summaryrefslogtreecommitdiff
path: root/jstests/core/useindexonobjgtlt.js
blob: e407ad7cf0aa78f53f54a097b0f31dffd845b4a3 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
t = db.factories
t.drop()
t.insert( { name: "xyz", metro: { city: "New York", state: "NY" } } )
t.ensureIndex( { metro : 1 } )

assert( db.factories.find().count() )

assert.eq( 1, db.factories.find( { metro: { city: "New York", state: "NY" } } )
                          .hint({metro: 1})
                          .count() )

assert.eq( 1, db.factories.find( { metro: { $gte : { city: "New York" } } } )
                          .hint({metro: 1})
                          .count() )