Operational Defect Database
BugZero found this defect 72 days ago.
Data sources
All data on this page is proprietary to BugZero® or gathered from public sources
MongoDB | 2603516
Different field order after $project returned by SBE and classic engine
Last update date:
3/15/2024
Affected products:
MongoDB Server
Affected releases:
No affected releases provided.
Fixed releases:
No fixed releases provided.
Description:
Info
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] ----
Top User Comments
Steps to Reproduce
