Details
-
Task
-
Resolution: Fixed
-
Major - P3
-
None
-
None
-
None
-
Fully Compatible
-
135
Description
SERVER-82570 changed the query planner to remove some InternalExpr predicates in residual filters, and changed the SBE stage builders to unconditionally compile them (rather than to an always true predicate).
It turns out there are some common cases where InternalExpr expressions remain in the tree and get compiled, slowing down some filtering operations. We should make the rewrite more aggressive, to remove the imprecise predicates in more situations.