-
Type:
Improvement
-
Resolution: Unresolved
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
None
-
Query Optimization
-
None
-
None
-
None
-
None
-
None
-
None
-
None
When running jstests/aggregation/sources/lookup/lookup_absorb_match.js with JOO enabled, the test fails in a manner that indicates that the includeArrayIndex argument to $unwind is disregarded – the result set does not include the array index.
[js_test:lookup_absorb_match] 2025-11-28T09:04:56.929Z assert: [[[js_test:lookup_absorb_match] {[js_test:lookup_absorb_match] "_id" : "bull",[js_test:lookup_absorb_match] "location" : {[js_test:lookup_absorb_match] "_id" : "bullpen"[js_test:lookup_absorb_match] }[js_test:lookup_absorb_match] },[js_test:lookup_absorb_match] {[js_test:lookup_absorb_match] "_id" : "dog",[js_test:lookup_absorb_match] "location" : {[js_test:lookup_absorb_match] "_id" : "doghouse"[js_test:lookup_absorb_match] }[js_test:lookup_absorb_match] }[js_test:lookup_absorb_match] ]] and [[[js_test:lookup_absorb_match] {[js_test:lookup_absorb_match] "_id" : "bull",[js_test:lookup_absorb_match] "location" : {[js_test:lookup_absorb_match] "_id" : "bullpen"[js_test:lookup_absorb_match] },[js_test:lookup_absorb_match] "arrIdx" : NumberLong(0)[js_test:lookup_absorb_match] },[js_test:lookup_absorb_match] {[js_test:lookup_absorb_match] "_id" : "dog",[js_test:lookup_absorb_match] "location" : {[js_test:lookup_absorb_match] "_id" : "doghouse"[js_test:lookup_absorb_match] },[js_test:lookup_absorb_match] "arrIdx" : NumberLong(0)[js_test:lookup_absorb_match] }[js_test:lookup_absorb_match] ]] are not equal[js_test:lookup_absorb_match] doassert@src/mongo/shell/assert.js:48:14[js_test:lookup_absorb_match] _doassert@src/mongo/shell/assert.js:160:13[js_test:lookup_absorb_match] assert.eq@src/mongo/shell/assert.js:270:14[js_test:lookup_absorb_match] @jstests/aggregation/sources/lookup/lookup_absorb_match.js:131:8
- related to
-
SERVER-114566 Fall back from join order optimization on unwind with preserveNullAndEmptyArrays = true
-
- Open
-