Info
Trying to call setQuerySettings on the following aggregate query
// Test that $bucket accepts a default value that falls outside the boundaries according to the
// collation.
results = coll.aggregate([{
$bucket: {
groupBy: "$num",
boundaries: ["100", "999"],
default: "2" // Would fall between 100 and 999 if using the simple collation.
}
}])
.toArray();
will result in the following error
{
"ok" : 0,
"errmsg" : "The $bucket 'default' field must be less than the lowest boundary or greater than or equal to the highest boundary.",
"code" : 40199,
"codeName" : "Location40199",
"$clusterTime" : {
"clusterTime" : Timestamp(1712858859, 25),
"signature" : {
"hash" : BinData(0,"AAAAAAAAAAAAAAAAAAAAAAAAAAA="),
"keyId" : NumberLong(0)
}
},
"operationTime" : Timestamp(1712858859, 25)
}
[Parsley logs
Top User Comments
JIRAUSER1269657 commented on Fri, 12 Apr 2024 12:43:42 +0000:
As pointed out by denis.grebennicov@mongodb.com, this is another case of failing validation due to missing collection information (design decision due to mongos lacking collator information).
