select push(colors),max(city),addtoset(colors),min(valuation +4) from baseball group by valuation

go

--push(colors) max(city)  addtoset(colors)  min(valuation + 4)

------------------  -------------    -------------            ---------------

--[  ]              (null)         [  ]                     14

 

Program sends next aggregate command which does not include fields for aggregation functions into the $project:

[ { "$project" : { "valuation + 4" : { "$add" : [ "$valuation", 4 ] } } }, { "$group" : { "_id" : "$valuation", "push(colors)" : { "$push" : "$colors" }, "max(city)" : { "$max" : "$city" }, "addtoset(colors)" : { "$addToSet" : "$colors" }, "min(valuation + 4)" : { "$min" : "$valuation + 4" } } }, { "$project" : { "_id" : 0, "valuation" : "$_id", "push(colors)" : 1, "max(city)" : 1, "addtoset(colors)" : 1, "min(valuation + 4)" : 1 } } ]

 

Correct command should be:

 

db.baseball.aggregate( { "$project" : {valuation:1,city:1,colors:1,"valuation + 4" : { "$add" : [ "$valuation", 4 ] } } }, { "$group" : { "_id" : "$valuation", "push(colors)" : { "$push" : "$colors" }, "max(city)" : { "$max" : "$city" }, "addtoset(colors)" : { "$addToSet" : "$colors" }, "min(valuation + 4)" : { "$min" : "$valuation + 4" } } }, { "$project" : { "_id" : 0, "valuation" : "$_id", "push(colors)" : 1, "max(city)" : 1, "addtoset(colors)" : 1, "min(valuation + 4)" : 1 } } )

 

Such solution also helps to resolve ticket 9644. I link these tickets.