Join Optimimization: "Encountered unexpected array in NDV computation" in jstests/core/query/release_memory/hash_lookup_unwind.js

XMLWordPrintableJSON

    • 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
      

            Assignee:
            Alexander Ignatyev
            Reporter:
            Philip Stoev
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: