Loading...

XML

Word

Printable

JSON

Type: Improvement
Resolution: Unresolved
Priority: Major - P3
Fix Version/s: 8.3.0-rc0
Affects Version/s: None
Component/s: None
Labels:
- M4

Assigned Teams:

Query Optimization
Linked BF Score:
200
CAR Domain/s:
None

Aha! Reference:
None
Tracking Level:
None
Risk Status:
None
Exec Notes:
None
Goal Name(s):
None
Goal Link:
None

This would be represented in MQL by a $lookup sub-pipeline with $expr along with localField/foreignField

is related to

SERVER-112608 Distinguish semantics of equality operator in JoinPredicate

Open

SERVER-113276 Stage builder/SBE support for join predicates using $expr

Needs Scheduling

related to

SERVER-115982 Join Optimization: 'Location11336908', 'errmsg': 'Expected bestPlanIndex < plans.size()'

In Code Review

SERVER-115652 Join Optimization: Support single table predicates referencing constant variables

Needs Scheduling

SERVER-115856 Join optimization: Write e2e test cases for join predicates involving let variables that require path resolution

Needs Scheduling

Assignee:: Ben Shteinfeld
Reporter:: Nicholas Zolnierz
Participants:: Ben Shteinfeld, Githook User, Nicholas Zolnierz
Votes:: 0 Vote for this issue
Watchers:: 4 Start watching this issue

Created:: Oct 29 2025 03:52:42 PM UTC
Updated:: Dec 30 2025 12:44:41 PM UTC