-
Type:
Bug
-
Resolution: Fixed
-
Priority:
Minor - P4
-
Affects Version/s: None
-
Component/s: None
-
Query Optimization
-
Fully Compatible
-
200
-
None
-
None
-
None
-
None
-
None
-
None
-
None
> db.foo.drop()
> db.foo2.drop()
> db.foo.createIndex({a:1})
> db.foo.insert({a:1})
> db.foo2.insert({b:1})
> db.adminCommand({setParameter: 1, notablescan: 1})
// In SBE, the following succeeds (uses a hash join)
> db.foo.aggregate([{$match: {a: 1}}, {$lookup: {from: "foo2", as: "res", localField: "a", foreignField: "b"}}])
// In classic, it fails
> db.adminCommand({setParameter: 1, internalQueryFrameworkControl: 'forceClassicEngine'})
> db.foo.aggregate([{$match: {a: 1}}, {$lookup: {from: "foo2", as: "res", localField: "a", foreignField: "b"}}])
"Executor error during aggregate command on namespace: test.foo :: caused by :: No indexed plans available, and running with 'notablescan' 2",
- is related to
-
SERVER-112200 Robustly cleanup environment in notablescan_sbe_consistency.js
-
- Backlog
-
- related to
-
SERVER-111324 Tag out SBE notablescan tests affect by SERVER-110058
-
- Closed
-
-
SERVER-110051 Allow $natural hint to override "notablescan"
-
- Needs Scheduling
-