Details
-
Bug
-
Resolution: Fixed
-
Major - P3
-
None
-
None
-
None
-
Fully Compatible
-
ALL
-
QO 2022-10-03, QO 2022-10-17, QO 2022-10-31
Description
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 []
|
Attachments
Issue Links
- 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
-
SERVER-69024 [CQF] Handling of traverse with more than one partial schema requirement
-
- Closed
-