Loading...

XML

Word

Printable

JSON

Operating System:
ALL
Steps To Reproduce:
Hide

A minimal repro for $bucket:

> db.t.insert({a: 1, b: 2}) > db.t.aggregate([{$bucket: {"groupBy": {$and: ["$a", 2]}, boundaries: [0, 1], default: 1}}])

Notice that $bucket without an $and for the groupBy does not produce the error and group can be pushed down and executes correctly,

db.t.aggregate([{$bucket: {"groupBy": "$a", boundaries: [false, true], default: 1}}])

A minimal repro for $sortByCount:

> db.t.aggregate([{$sortByCount: {$and: ["$a", 1]}}])
Show
A minimal repro for $bucket: > db.t.insert({a: 1, b: 2}) > db.t.aggregate([{$bucket: {"groupBy": {$and: ["$a", 2]}, boundaries: [0, 1], default: 1}}]) Notice that $bucket without an $and for the groupBy does not produce the error and group can be pushed down and executes correctly, db.t.aggregate([{$bucket: {"groupBy": "$a", boundaries: [false, true], default: 1}}]) A minimal repro for $sortByCount: > db.t.aggregate([{$sortByCount: {$and: ["$a", 1]}}])
Sprint:
QE 2021-10-04
Confidence Status:
None
Work Order:
3
CAR Domain/s:
None

The aggregation wildcard fuzzer has exposed a MONGO_UNREACHABLE bug when translating $bucket, $bucketAuto, $sortByGroup's groupBy expression.

The failures for $bucket was a result of these pipelines:

The failures for $bucketAuto are a result of these pipelines:

is duplicated by

SERVER-60239 $group with $and expression fails

is related to

SERVER-60226 Ban sugared $group stages from being pushed down to SBE

related to

SERVER-60261 Update comments on $coerceToBool-related issues

SERVER-58954 Refactor and unify the code to optimize expressions in projections