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.