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

XMLWordPrintableJSON

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

      $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
            Reporter:
            Emily Wang (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: