Create MatchExpressions for special cases of index bounds intervals

    • Type: Task
    • Resolution: Unresolved
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Optimization
    • None
    • 3
    • TBD
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      Some special cases of index interval bounds are created from operators, such as $exists. The base transformation of intervals to match expressions in SERVER-104501 in these cases would create comparison expressions. Another special, but probably common case, is the $in operator which creates a disjunction of values from the OIL, not the original $in.

      Check if this transformation is sufficient from the performance and accuracy perspective.

      If not, add specific transformation rules.

      The specific match expressions are:

      • $in -> [v1] U [v2] U ...
      • {$exists : false} -> [null, null]
      • internal comparison expressions

              Assignee:
              Unassigned
              Reporter:
              Milena Ivanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated: