-
Type:
Bug
-
Resolution: Duplicate
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
None
-
Query Optimization
-
ALL
-
None
-
None
-
None
-
None
-
None
-
None
-
None
Running jstests/core/query/release_memory/hash_lookup_unwind.js with JOO enabled results in:
[js_test:hash_lookup_unwind] 2025-12-18T08:35:45.881Z assert: command failed: { [js_test:hash_lookup_unwind] "ok" : 0, [js_test:hash_lookup_unwind] "errmsg" : "Encountered unexpected array in NDV computation", [js_test:hash_lookup_unwind] "code" : 11158502, [js_test:hash_lookup_unwind] "codeName" : "Location11158502" [js_test:hash_lookup_unwind] } with original command request: { [js_test:hash_lookup_unwind] "aggregate" : "hash_lookup_unwind_animals", [js_test:hash_lookup_unwind] "pipeline" : [ [js_test:hash_lookup_unwind] { [js_test:hash_lookup_unwind] "$lookup" : { [js_test:hash_lookup_unwind] "from" : "hash_lookup_unwind_locations", [js_test:hash_lookup_unwind] "localField" : "locationName", [js_test:hash_lookup_unwind] "foreignField" : "name", [js_test:hash_lookup_unwind] "as" : "location" [js_test:hash_lookup_unwind] } [js_test:hash_lookup_unwind] }, [js_test:hash_lookup_unwind] { [js_test:hash_lookup_unwind] "$unwind" : "$location" [js_test:hash_lookup_unwind] }, [js_test:hash_lookup_unwind] { [js_test:hash_lookup_unwind] "$project" : { [js_test:hash_lookup_unwind] "locationName" : false, [js_test:hash_lookup_unwind] "location.extra" : false, [js_test:hash_lookup_unwind] "location.coordinates" : false, [js_test:hash_lookup_unwind] "colors" : false [js_test:hash_lookup_unwind] } [js_test:hash_lookup_unwind] } [js_test:hash_lookup_unwind] ], [js_test:hash_lookup_unwind] "explain" : true, [js_test:hash_lookup_unwind] "cursor" : { [js_test:hash_lookup_unwind] [js_test:hash_lookup_unwind] }, [js_test:hash_lookup_unwind] "lsid" : { [js_test:hash_lookup_unwind] "id" : UUID("de7bfd28-d3d4-47f1-bce3-da4e4b96e977") [js_test:hash_lookup_unwind] }, [js_test:hash_lookup_unwind] "$traceCtx" : { [js_test:hash_lookup_unwind] "traceparent" : "00-c4a42894695efa9a5452ef3f3bb5122b-e312b14847f37018-01" [js_test:hash_lookup_unwind] } [js_test:hash_lookup_unwind] } on connection: connection to localhost:20750 with errmsg: Encountered unexpected array in NDV computation : aggregate failed [js_test:hash_lookup_unwind] _getErrorWithCode@src/mongo/shell/utils.js:21:13 [js_test:hash_lookup_unwind] doassert@src/mongo/shell/assert.js:46:14 [js_test:hash_lookup_unwind] _doassert@src/mongo/shell/assert.js:160:13 [js_test:hash_lookup_unwind] _assertCommandWorked@src/mongo/shell/assert.js:1185:22 [js_test:hash_lookup_unwind] assert.commandWorked@src/mongo/shell/assert.js:1349:12 [js_test:hash_lookup_unwind] DB.prototype._runAggregate@src/mongo/shell/db.js:302:12 [js_test:hash_lookup_unwind] DBCollection.prototype.aggregate@src/mongo/shell/collection.js:1140:21 [js_test:hash_lookup_unwind] Explainable/this.aggregate@src/mongo/shell/explainable.js:119:37 [js_test:hash_lookup_unwind] @jstests/core/query/release_memory/hash_lookup_unwind.js:99:35
- duplicates
-
SERVER-113718 Do not use join optimizer path if join predicates/fields operate over arrays
-
- Needs Scheduling
-
- related to
-
SERVER-115887 Complete TODO listed in SERVER-115709
-
- Needs Scheduling
-