Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-55878

pushed filter on time-series has redundant predicates

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor - P4
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Query Planning
    • Labels:
      None
    • Operating System:
      ALL

      Description

      for instance:

      > db.point_data.explain().aggregate([{$match: {"time":{$lt:ISODate("2016-01-01T00:00:00Z")}}}]) 

       

      "winningPlan" : 
      {    "stage" : "COLLSCAN",
           "filter" : { "$and" : [     
            { "_id" : {     "$lt" : ObjectId("5685c1800000000000000000") }     }, 
            { "_id" : {     "$lt" : ObjectId("5685c1800000000000000000") }     },  
            { "control.min.time" : {     "$_internalExprLt" : ISODate("2016-01-01T00:00:00Z") }     },     
            { "control.min.time" : {     "$_internalExprLt" : ISODate("2016-01-01T00:00:00Z") }     } ]    },
          "direction" : "forward"},

       

      The pushed filter is still valid, maybe not that performant and it is probably unintended behaviour 

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              hana.pearlman Hana Pearlman
              Reporter:
              ruslan.abdulkhalikov Ruslan Abdulkhalikov
              Participants:
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: