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

Add logic in cascades optimizer to allow eqMember operation to use an index

    • Type: Icon: Task Task
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 6.2.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • Labels:
      None
    • Fully Compatible
    • QO 2022-10-03, QE 2022-10-17

      $in match expressions will in the future be translated into the eqMember op type – for example, $in: [1, 2, 3] becomes the ABT filter:

      PathTraverse []
      PathCompare [EqMember]
      Const [[1, 2, 3]] 

      This breaks this ABT unit test. The old implementation of $in was supported with indexing, as it used to be chain of PathCompares with op type eq and that has index support. However, the new implementation involves a new op type, and thus after passing through the optimizer, the ABT cannot use an index.

            Assignee:
            matt.boros@mongodb.com Matt Boros
            Reporter:
            emily.wang@mongodb.com Emily Wang (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: