SERVER-137998ClosedFixed

Join optimization pushes classic-only $match expressions into SBE and hits tassert

A $match that SBE cannot lower ($function, $getField, $convert, $type, $jsonSchema, ...) placed before the first $lookup or inside a $lookup sub-pipeline is pushed into a join node's CanonicalQuery and lowered anyway. Eligibility only rejects $text; createCQForJoinPipeline() marks the CQ SBE-compatible without inspecting the filter. Without join optimization these pipelines run in classic and succeed.

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