SERVER-137996ClosedDone

Join optimization lowers $match on a numeric path component to SBE and returns no rows

'\{"arr.0": 1}'  before the first $lookup, in a $lookup sub-pipeline, or absorbed from after $unwind, is pushed into a join-node CanonicalQuery and executed in SBE, where getField(array, "0") does not index the array. Outside join optimization the parser caps SbeCompatibility for such paths (SERVER-49852) and classic runs the filter; createCQForJoinPipeline() calls setSbeCompatible(true) unconditionally.

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