-
Type: Bug
-
Resolution: Cannot Reproduce
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
Query Integration
-
ALL
-
We attempt to find the earliest timestamp in a timeseries collection.
In a usual collection, you can write an aggregation with ascending $sort, $limit 1 and $project steps without issues.
After migrating to a timeseries collection on Atlas, this fails with the following error:
PlanExecutor error during aggregation :: caused by :: BoundedSorter input is too out-of-order: with bound 2024-03-28T19:00:00.000+00:00, did not expect input 2024-03-28T18:04:01.000+00:00
Further observations:
- The sort (aggregation) step works when you invert the sorting (descending).