Notably the null equality semantics are different when the predicate is expressed using $expr vs localField/foreignField. SERVER-112608 tracks the QO side of this work and will be required for compound join predicates.
- related to
-
SERVER-112608 Distinguish semantics of equality operator in JoinPredicate
-
- Closed
-
-
SERVER-113172 Support compound join predicate in join optimizer represented as $expr in sub-pipeline
-
- Closed
-