Operational Defect Database
BugZero found this defect 86 days ago.
Data sources
All data on this page is proprietary to BugZero® or gathered from public sources
MongoDB | 2586104
Disallow the use of sparse indexes with $facet + $lookup
Last update date:
3/12/2024
Affected products:
MongoDB Server
Affected releases:
No affected releases provided.
Fixed releases:
No fixed releases provided.
Description:
Info
SERVER-64082 discussed the usage of wildcard index/sparse index in $lookup and decided not to use any sparse indexes in $lookup. The banning logic was introduced by SERVER-65665 but $lookup in a $facet seems to still use a wildcard index on the foreign collection.
Top User Comments
Steps to Reproduce
