-
Type: Bug
-
Resolution: Fixed
-
Priority: Major - P3
-
Affects Version/s: None
-
Component/s: None
-
Query Integration
-
Fully Compatible
-
ALL
-
v8.0, v7.0, v6.0, v5.0
The following repro demonstrates the issue. The explain shows an EOF plan being generated. Spoke to gil.alon@mongodb.com about this and we believe the _id predicates or other additional bucket-level predicates that are generated conflict in a way where the optimizer believes no document can be returned.
const tsColl = db.ts; const coll = db.c; tsColl.drop(); coll.drop(); assert.commandWorked(db.createCollection(tsColl.getName(), { timeseries: {timeField: 't', metaField: 'm'}, })); const docs = [ { "t" : ISODate("1969-12-31T23:59:59.415Z"), "_id" : 0 } ] assert.commandWorked(coll.insert(docs)) assert.commandWorked(tsColl.insert(docs)) query = [ { "$match" : { "t" : ISODate("1969-12-31T23:59:59.415Z") } } ] const expected = coll.aggregate(query).toArray(); const actual = tsColl.aggregate(query).toArray(); jsTestLog(expected) // Finds the document jsTestLog(actual) // Empty results const exp = tsColl.explain().aggregate(query); jsTestLog(exp) // EOF plan
- fixes
-
SERVER-94017 Bounded sorter can incorrectly uassert for pre-1970 dates
- Closed
- is related to
-
SERVER-94723 More accurately find extended range dates for 'always' predicate generation
- Backlog