Parse simple $between agg expression to a conjunction of gte/lte operators.

XMLWordPrintableJSON

    • Type: Task
    • Resolution: Won't Do
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • Query Optimization
    • QO 2022-10-03, QE 2022-10-17
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      Parse $between in these forms:

      Input BSON Materialized sub-Expression
      {$between: [<fieldpath>, 
          {$binData: <>}] }      		 {$between: [<fieldpath>, 
          {$binData: <>}] }
      {$between: {input: <expression>, bounds: [<lowerBound>, <upperBound>] }

      }

      		 {$and: [
          {$gte: [expression, lowerBoundExpr]},
          {$lte: [expression, upperBoundExpr]}
      ]}

       
      BinData with subtype other than 6 should be rejected at this stage with a uassert.

            Assignee:
            [DO NOT USE] Backlog - Query Optimization
            Reporter:
            Davis Haupt (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: