Details
-
Bug
-
Resolution: Gone away
-
Major - P3
-
None
-
None
-
None
-
None
-
Query Optimization
-
ALL
-
-
QO 2023-04-03
Description
I have pipelines that previously worked but no longer do since upgrading to 6.2.0. They all specifically have a GROUP_BY stage that is no longer working as expected. e.g.
[{
|
$match: {
|
'metadata.testId': 'foo' |
}
|
}, {
|
$group: {
|
_id: {
|
difficulty: '$metadata.publicFacetLabels.difficulty' |
},
|
responseCount: {
|
$count: {}
|
},
|
sumScore: {
|
$sum: '$metadata.score' |
}
|
}
|
}, {
|
$project: {
|
_id: 0, |
sumScore: 1, |
responseCount: 1, |
difficulty: '$_id.difficulty' |
}
|
}]
|
In the above example I was previously getting the following result
{
|
responseCount:166, |
sumScore: 150, |
difficulty: "Hard" |
}
|
Since updating to version 6.2.0 I am getting:
{
|
sumScore: 150, |
}
|
Note: these pipelines are being run against a timeseries collection