-
Type: Bug
-
Resolution: Fixed
-
Priority: Major - P3
-
Affects Version/s: 8.0.0-rc0, 7.0.7
-
Component/s: Query Planning
-
Query Execution
-
Fully Compatible
-
ALL
-
v8.0, v7.3, v7.0, v6.0, v5.0
-
QE 2024-04-29
db.test.drop(); for (let i = 0; i < 10; ++i) { db.test.insertOne({a: 1, b: 1}); } db.test.createIndex({a: 1}); db.test.createIndex({b: 1}); // Observe 0 in skipAmount print(db.test.find({a: 1, b: 1}).sort({_id: 1}).limit(5).skip(5).explain().queryPlanner.winningPlan); // Same query with hint (so without multiplanning) will show correct amount print(db.test.find({a: 1, b: 1}).sort({_id: 1}).limit(5).skip(5).hint({_id: 1}).explain().queryPlanner.winningPlan);
- is related to
-
SERVER-89207 Ensure that the fallback mechanism works for '$_requestResumeToken' queries.
- Backlog
-
SERVER-88934 Automatically increase test coverage of multi-planning and replanning
- Closed