Time-series $meta operator has inconsistent behavior as regular collections

XMLWordPrintableJSON

    • Type: Bug
    • Resolution: Unresolved
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Integration
    • ALL
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      > db.test.find()
      { "_id" : ObjectId("65a83c879039a5ecd4ae9512"), "time" : ISODate("2024-01-17T20:45:59.439Z") }
      > db.test.find({}, {b: {$meta: "sortKey"}}).sort({time: 1})
      { "_id" : ObjectId("65a83c879039a5ecd4ae9512"), "time" : ISODate("2024-01-17T20:45:59.439Z"), "b" : [ ISODate("2024-01-17T20:45:59.439Z") ] }
      > db.ts.find()
      { "time" : ISODate("2024-01-17T19:58:09.141Z"), "_id" : ObjectId("65a831518c8d365be92fc88c") }
      > db.ts.find({}, {b: {$meta: "sortKey"}}).sort({time: 1})
      { "_id" : ObjectId("65a831518c8d365be92fc88c") } 

            Assignee:
            Unassigned
            Reporter:
            Yuhong Zhang
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated: