> db.createCollection("mycoll", {capped: true, size: 100000, max: 1000})
|
{ "ok" : 1 }
|
|
> for(var i = 0; i < 100; ++i) { db.mycoll.insert({x: i}); }
|
WriteResult({ "nInserted" : 1 })
|
|
> db.mycoll.ensureIndex({x: 1})
|
{
|
"createdCollectionAutomatically" : false,
|
"numIndexesBefore" : 1,
|
"numIndexesAfter" : 2,
|
"ok" : 1
|
}
|
|
So far so good:
|
|
> db.mycoll.find({x:{$gt:95}}).sort({$natural: 1})
|
{ "_id" : ObjectId("5390738c8f5c62869f0775ad"), "x" : 96 }
|
{ "_id" : ObjectId("5390738c8f5c62869f0775ae"), "x" : 97 }
|
{ "_id" : ObjectId("5390738c8f5c62869f0775af"), "x" : 98 }
|
{ "_id" : ObjectId("5390738c8f5c62869f0775b0"), "x" : 99 }
|
|
Oops:
|
|
> db.mycoll.find({x:{$gt:95}}).sort({$natural: -1})
|
{ "_id" : ObjectId("5390738c8f5c62869f0775ad"), "x" : 96 }
|
{ "_id" : ObjectId("5390738c8f5c62869f0775ae"), "x" : 97 }
|
{ "_id" : ObjectId("5390738c8f5c62869f0775af"), "x" : 98 }
|
{ "_id" : ObjectId("5390738c8f5c62869f0775b0"), "x" : 99 }
|
>
|