[SERVER-52814] queryPlanner.winningPlan.inputStage is undefined for a specific query Created: 12/Nov/20 Updated: 29/Oct/23 Resolved: 25/Jan/21 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | Querying |
| Affects Version/s: | 4.9.0 |
| Fix Version/s: | 4.9.0 |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | Tanay Abhra | Assignee: | Ted Tuckman |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||||||
| Backwards Compatibility: | Fully Compatible | ||||||||||||
| Operating System: | ALL | ||||||||||||
| Sprint: | Query 2020-12-28, Query 2021-01-11, Query 2021-01-25, Query 2021-02-08 | ||||||||||||
| Participants: | |||||||||||||
| Description |
|
We are going to run atlas proxy with mongodb 4.9+ version in the future. While trying to run the test harness with a new mongod in dev, I found a breaking change. We have this test in the test suite:
which started failing with this error: `TypeError: db.test5.find(...).explain(...).queryPlanner.winningPlan.inputStage is undefined` We have similar tests that pass without a hitch, for example:
|
| Comments |
| Comment by Githook User [ 25/Jan/21 ] | ||||||||||||||||||||||||||||||||||||||||||||||||||
|
Author: {'name': 'Ted Tuckman', 'email': 'ted.tuckman@mongodb.com', 'username': 'TedTuckman'}Message: | ||||||||||||||||||||||||||||||||||||||||||||||||||
| Comment by Githook User [ 25/Jan/21 ] | ||||||||||||||||||||||||||||||||||||||||||||||||||
|
Author: {'name': 'Ted Tuckman', 'email': 'ted.tuckman@mongodb.com', 'username': 'TedTuckman'}Message: | ||||||||||||||||||||||||||||||||||||||||||||||||||
| Comment by Edwin Zhou [ 20/Nov/20 ] | ||||||||||||||||||||||||||||||||||||||||||||||||||
|
I reproduced the issue for test5 in both 4.4.2 and 4.9+ and noticed a discrepancy in how the indexes were being created.
This is the correct result that I get in 4.4.2:
I used the reproduction provided in the description without the assertion.
Is this adequate information to isolate the the cause? | ||||||||||||||||||||||||||||||||||||||||||||||||||
| Comment by Ana Meza [ 17/Nov/20 ] | ||||||||||||||||||||||||||||||||||||||||||||||||||
|
Query is wondering if someone from Triage team can reproduce this one, please |