Loading...

XML

Word

Printable

JSON

Assigned Teams:

Query Execution
Operating System:
ALL
Steps To Reproduce:
Hide

Enterprise test> db.test.find() [ { _id: 1, a: [ 1, 2, 3, 4, 5 ] } ] Enterprise test> db.test.find({}, { a : { $slice : [0, 3] } }) [ { _id: 1, a: [ 1, 2, 3 ] } ] Enterprise test> db.test.aggregate([{ $project : { a : { $slice : [0, 5 ] } } }]) MongoServerError: Failed to optimize pipeline :: caused by :: First argument to $slice must be an array, but is of type: int Enterprise test>
Show
Enterprise test> db.test.find() [ { _id: 1, a: [ 1, 2, 3, 4, 5 ] } ] Enterprise test> db.test.find({}, { a : { $slice : [0, 3] } }) [ { _id: 1, a: [ 1, 2, 3 ] } ] Enterprise test> db.test.aggregate([{ $project : { a : { $slice : [0, 5 ] } } }]) MongoServerError: Failed to optimize pipeline :: caused by :: First argument to $slice must be an array, but is of type: int Enterprise test>

The projection form of $slice:

only works with find, not with $project.

I understand there is another form of $slice:

But the issue here is why the first form doesn't work with $project.

related to

CSHARP-4804 Slice projection must be rendered differently for Find and Aggregate