[SERVER-36521] Prevent allPaths indexes from generating self-intersecting plans Created: 08/Aug/18 Updated: 29/Oct/23 Resolved: 11/Sep/18 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | Index Maintenance, Querying |
| Affects Version/s: | None |
| Fix Version/s: | 4.1.3 |
| Type: | Task | Priority: | Major - P3 |
| Reporter: | Bernard Gorman | Assignee: | Bernard Gorman |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||
| Backwards Compatibility: | Fully Compatible | ||||||||
| Sprint: | Query 2018-08-27, Query 2018-09-10, Query 2018-09-24 | ||||||||
| Participants: | |||||||||
| Description |
|
Because allPaths indexes are effectively a collection of single-field indexes on each field of the document, the planner generates a number of AND_SORTED plans for queries involving two or more of the indexed fields. While this is consistent with the planner's behaviour in the case where each individual field was indexed separately, we should consider banning the planner from generating these plans for an allPaths index. |
| Comments |
| Comment by Githook User [ 11/Sep/18 ] |
|
Author: {'name': 'Bernard Gorman', 'email': 'bernard.gorman@gmail.com', 'username': 'gormanb'}Message: |