-
Type:
Bug
-
Resolution: Fixed
-
Priority:
Major - P3
-
Affects Version/s: 4.0.6
-
Component/s: Aggregation Framework
-
Fully Compatible
-
ALL
-
Query 2020-06-29, Query 2020-07-13
-
44
-
None
-
3
-
None
-
None
-
None
-
None
-
None
-
None
-
None
db.foo.aggregate({$addFields:{x:{$substr:[{$literal:"xxxxxxxx"}, 0, NumberDecimal("5")]}}})
2018-09-10T14:40:15.878-0400 E QUERY [js] Error: command failed: {
"ok" : 0,
"errmsg" : "$substrBytes: length must be a numeric type (is BSON type decimal)",
"code" : 16035,
"codeName" : "Location16035"
} : aggregate failed
// same for other string functions
[js] Error: command failed: {
"ok" : 0,
"errmsg" : "$substrBytes: length must be a numeric type (is BSON type decimal)",
"code" : 16035,
"codeName" : "Location16035"
} : aggregate failed :
Decimal should be treated like other numeric types and be valid.