[SERVER-69600] Parse simple $between agg expression to a conjunction of gte/lte operators. Created: 12/Sep/22  Updated: 05/Dec/22  Resolved: 08/Nov/22

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Task Priority: Major - P3
Reporter: Davis Haupt (Inactive) Assignee: Backlog - Query Optimization
Resolution: Won't Do Votes: 0
Labels: neweng
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
depends on SERVER-69598 Rename $encryptedBetween to $between Closed
is depended on by SERVER-69609 Mark $between for encryption in query... Closed
is depended on by SERVER-69879 Parse verbose form of $between agg ex... Closed
Assigned Teams:
Query Optimization
Sprint: QO 2022-10-03, QE 2022-10-17
Participants:

 Description   

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.


Generated at Thu Feb 08 06:13:53 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.