[SERVER-9548] Support $min/max in count command Created: 03/May/13  Updated: 10/Dec/14  Resolved: 08/Nov/13

Status: Closed
Project: Core Server
Component/s: Querying
Affects Version/s: None
Fix Version/s: None

Type: Improvement Priority: Minor - P4
Reporter: Thomas Rueckstiess Assignee: Unassigned
Resolution: Duplicate Votes: 1
Labels: query_triage
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate
is duplicated by SERVER-675 count() broken with $min and $max Closed
Participants:

 Description   

> db.docs.drop()
> for (var i=0; i<10; i++) { db.docs.insert({number: i}) }
> db.docs.find()
{ "_id" : ObjectId("51834d678d284e5c5e3ea7e3"), "number" : 0 }
{ "_id" : ObjectId("51834d678d284e5c5e3ea7e4"), "number" : 1 }
{ "_id" : ObjectId("51834d678d284e5c5e3ea7e5"), "number" : 2 }
{ "_id" : ObjectId("51834d678d284e5c5e3ea7e6"), "number" : 3 }
{ "_id" : ObjectId("51834d678d284e5c5e3ea7e7"), "number" : 4 }
{ "_id" : ObjectId("51834d678d284e5c5e3ea7e8"), "number" : 5 }
{ "_id" : ObjectId("51834d678d284e5c5e3ea7e9"), "number" : 6 }
{ "_id" : ObjectId("51834d678d284e5c5e3ea7ea"), "number" : 7 }
{ "_id" : ObjectId("51834d678d284e5c5e3ea7eb"), "number" : 8 }
{ "_id" : ObjectId("51834d678d284e5c5e3ea7ec"), "number" : 9 }
> db.docs.count()
10

> db.docs.find().max({number: 4})
{ "_id" : ObjectId("51834d678d284e5c5e3ea7e3"), "number" : 0 }
{ "_id" : ObjectId("51834d678d284e5c5e3ea7e4"), "number" : 1 }
{ "_id" : ObjectId("51834d678d284e5c5e3ea7e5"), "number" : 2 }
{ "_id" : ObjectId("51834d678d284e5c5e3ea7e6"), "number" : 3 }

So far so good.

> db.docs.find().max({number: 4}).count()
10

I would like this count to return 4. Instead it returns 10.



 Comments   
Comment by Benety Goh [ 08/Nov/13 ]

Marking as duplicate and migrating description to SERVER-675.

Generated at Thu Feb 08 03:20:45 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.