[SERVER-75067] [CQF] Support simplifications related to exists:true/false Created: 20/Mar/23  Updated: 18/Jul/23

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

Type: Improvement Priority: Major - P3
Reporter: Svilen Mihaylov (Inactive) Assignee: Backlog - Query Optimization
Resolution: Unresolved Votes: 0
Labels: plan-quality
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Related
related to SERVER-67506 [CQF] Dotted path equality to null in... Open
related to SERVER-70697 [CQF] Eliminate PathArr, given Traver... In Progress
Assigned Teams:
Query Optimization
Participants:

 Description   

Exists is currently converted to PathDefault which is NOT translated into an interval. The goals of the task are to

  • allow PathDefault to be translated into an interval
  • allow simplifications between the intervals of a non-traversed path (e.g. Get "a" Id) and a traversed path (e.g. Get "a" Traverse Id) in the case the non-traversed path encodes an existence of an array, or just an existence in general.

 

Queries to test with:

{a:{$ne:null, $exists:true}}

{a:{$gt:1, $exists:true}}

{a:{$eq:null, $exists:true{}}

 


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