Details
-
Bug
-
Resolution: Unresolved
-
Major - P3
-
None
-
None
-
Query Optimization
-
ALL
-
Description
Aggregation output:
4.0:
|
[
|
{
|
"_id" : 293,
|
"obj" : {
|
|
|
},
|
"arrayAs" : [
|
{
|
"_id" : 293,
|
"obj" : {
|
|
|
}
|
}
|
]
|
},
|
{
|
"_id" : 322,
|
"obj" : {
|
"str" : undefined
|
},
|
"arrayAs" : [
|
{
|
"_id" : 293,
|
"obj" : {
|
|
|
}
|
}
|
]
|
}
|
]
|
|
|
master:
|
[
|
{
|
"_id" : 293,
|
"obj" : {
|
|
|
},
|
"arrayAs" : [
|
{
|
"_id" : 293,
|
"obj" : {
|
|
|
}
|
},
|
{
|
"_id" : 322,
|
"obj" : {
|
"str" : undefined
|
}
|
}
|
]
|
},
|
{
|
"_id" : 322,
|
"obj" : {
|
"str" : undefined
|
},
|
"arrayAs" : [
|
{
|
"_id" : 293,
|
"obj" : {
|
|
|
}
|
},
|
{
|
"_id" : 322,
|
"obj" : {
|
"str" : undefined
|
}
|
}
|
]
|
}
|
]
|
The query plan shows different index bounds in 4.0 and master:
4.0:
[js_test:ReproAgg] 2018-09-28T17:50:43.152-0500 d20021| ---------bounds = field #0['obj.str']: [null, null]
|
master:
[js_test:ReproAgg] 2018-09-28T17:50:43.147-0500 d20020| ---------bounds = field #0['obj.str']: [undefined, undefined], [null, null]
|