SERVER-137979ClosedFixed

Join optimization propagates strict $expr semantics across localField/foreignField edge

{$expr: \{$eq: ["$x", null]}} on one side of a loose (null == missing) join is inferred onto the other node as \{$expr: {$eq: ["$y", null]}} by predicate_inferer.cpp. The inferred predicate rejects documents with a missing field that the loose join would have matched.

Affected Versions
Versions known to exhibit this issue

No affected versions recorded.

Fixed Versions
Versions that include the fix
9.1.0-rc09.1.0-rc1025
Components
Server components related to this issue

No components specified.

Labels
Tags and classification
found-by-ai