SERVER-137997Backlog

Join optimization $expr equijoin treats BSON undefined as not equal to a missing field

*Minor* because undefined is a deprecated BSON type. Aggregation $eq considers undefined equal to a missing field, and classic/SBE $lookup return the row. The JOO hash join buckets fillEmpty(path, null), so undefined never meets the null produced for missing; the index probe seeks undefined while the index stores missing as null.

Affected Versions
Versions known to exhibit this issue

No affected versions recorded.

Fixed Versions
Versions that include the fix

No fix available yet.

Components
Server components related to this issue

No components specified.

Labels
Tags and classification
found-by-ai