Operational Defect Database
BugZero found this defect 74 days ago.
Data sources
All data on this page is proprietary to BugZero® or gathered from public sources
MongoDB | 2600852
SBE stage builder fails to generate plan using $mod in an index scan
Last update date:
3/15/2024
Affected products:
MongoDB Server
Affected releases:
No affected releases provided.
Fixed releases:
No fixed releases provided.
Description:
Info
The following query: db.x.find({"a.0": {$mod: [42,0]}}).explain() fails with the error 7097205 "Expected either input expr or top-level field slot to be defined" when an index on "a.0" is defined on the collection, but succeeds if there is no such index
Top User Comments
JIRAUSER1269757 commented on Fri, 15 Mar 2024 14:21:15 +0000: Adding support for numeric paths in SBE unveiled this use case
Steps to Reproduce
