[SERVER-72428] filter/$match not working on 1970-01-01 for timeseries collection Created: 29/Dec/22 Updated: 01/Mar/23 Resolved: 01/Mar/23 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | 5.0.14, 6.0.2, 6.0.3 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | Thomas MERLE | Assignee: | David Percy |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | query-director-triage | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Attachments: |
|
||||||||||||||||||||
| Issue Links: |
|
||||||||||||||||||||
| Assigned Teams: |
Query Optimization
|
||||||||||||||||||||
| Operating System: | ALL | ||||||||||||||||||||
| Steps To Reproduce: | Filter on january first a timeseries collection on timestamp field |
||||||||||||||||||||
| Sprint: | QO 2023-02-06, QO 2023-02-20, QO 2023-03-06 | ||||||||||||||||||||
| Participants: | |||||||||||||||||||||
| Description |
|
When filtering a timestamp on january 1 1970 no document is returned. Minimal reproduction collection: Filter
$match:
|
| Comments |
| Comment by David Percy [ 01/Mar/23 ] | |||||||||||||||
|
Yes, this looks like a duplicate of | |||||||||||||||
| Comment by Joe Kanaan [ 11/Jan/23 ] | |||||||||||||||
|
misha.tyulenev@mongodb.com, can you please help assign this to someone please? Thanks! | |||||||||||||||
| Comment by Rushan Chen [ 03/Jan/23 ] | |||||||||||||||
|
Thanks for reproducing the issues. chris.kelly@mongodb.com The problem is the same as the one you referred to. Part of the fix went in 6.2 but another part is still to be completed (linked to by this ticket). Assigning now to the responsible team (QO). | |||||||||||||||
| Comment by Chris Kelly [ 29/Dec/22 ] | |||||||||||||||
|
I ran the following tests on 5.0.14 and 6.0.2 through the mongo shell:
I'll pass this to the relevant team take a look. Thanks for your report! Christopher |