-
Type:
Bug
-
Resolution: Fixed
-
Priority:
Major - P3
-
Affects Version/s: None
-
Component/s: None
-
None
-
Fully Compatible
-
ALL
-
QO 2022-10-03, QO 2022-10-17, QO 2022-10-31
The following predicate should generate a Sargable node after optimization:
{"a.histogram.path": {$elemMatch: {$eq: 42}}}
However, this is the generated ABT:
Root [] | | projections: | | scan_0 | RefBlock: | Variable [scan_0] Filter [] | EvalFilter [] | | Variable [scan_0] | PathGet [a] | PathTraverse [1] | PathGet [histogram] | PathTraverse [1] | PathGet [path] | PathComposeM [] | | PathArr [] | PathTraverse [1] | PathCompare [Eq] | Const [42] Scan [test] BindBlock: [scan_0] Source []
- depends on
-
SERVER-69025 [CQF] Performance-only partial schema requirements
-
- Closed
-
- is depended on by
-
SERVER-70511 Estimate PathObj intervals in SargableNode
-
- Closed
-
- is duplicated by
-
-
- Closed
-