-
Type: Bug
-
Resolution: Fixed
-
Priority: Major - P3
-
Affects Version/s: 5.3.0-rc0
-
Component/s: None
-
None
-
Fully Compatible
-
ALL
-
-
QO 2022-04-04, QO 2022-04-18
Hinting $natural on a Timeseries collection no longer works. It appears a recent commit may have broke this functionality. Hinting $natural should always correspond to the clustered index which is built at collection create for a Timeseries collection and all the versions tested below show the clustered index as true in listCollections which is expected, yet the error observed in 5.3 rc0 and latest, 6.0.0-alpha-8-gaba3de6 refers to no index being created
Testing the above steps on 5.2 correctly work as expected and do not produce an error. However, testing on the latest and 5.3 rc0 produces the error. The offending commit seems to have been introduced sometime between 5.2 and 5.3 rc0
Once we correct the issue we should add a test for this case
- causes
-
SERVER-65393 tassert in createBucketsSpecFromTimeseriesSpec
- Closed
-
SERVER-67648 [v6.0] Tag timeseries_delete_hint.js and timeseries_update_hint.js with requires_fcv_60
- Closed
- is caused by
-
SERVER-58716 Allow finds with hints using index spec on time-series collections
- Closed