-
Type:
Bug
-
Resolution: Unresolved
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
Labels:None
-
Query Execution
-
ALL
-
11
Script to reproduce:
db.coll.drop();
db.coll.insert({
str: null,
obj: {}
});
const project = {
$project: {"str": "a", "obj.str": "b"}
};
const classicResult = db.coll.aggregate([{$_internalInhibitOptimization: {}}, project]).toArray();
jsTestLog(classicResult);
const sbeResult = db.coll.aggregate([project]).toArray();
jsTestLog(sbeResult);
Result:
[jsTest] ----
[jsTest] [
[jsTest] {
[jsTest] "_id" : ObjectId("65eb888b167f6208ab3a8e68"),
[jsTest] "obj" : {
[jsTest] "str" : "b"
[jsTest] },
[jsTest] "str" : "a"
[jsTest] }
[jsTest] ]
[jsTest] ----
[jsTest] ----
[jsTest] [
[jsTest] {
[jsTest] "_id" : ObjectId("65eb888b167f6208ab3a8e68"),
[jsTest] "str" : "a",
[jsTest] "obj" : {
[jsTest] "str" : "b"
[jsTest] }
[jsTest] }
[jsTest] ]
[jsTest] ----
- depends on
-
SERVER-82868 [SBE] Use the same order as classic for computed fields in inclusions
-
- In Code Review
-