-
Type: New Feature
-
Resolution: Unresolved
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: Aggregation Framework
-
None
-
Query Optimization
In SQL NULL is not a value, which means that any comparison to NULL is false, even if both sides are NULL. In MongoDB, however, null is considered a value. It would be helpful to have an aggregation option to set SQL null semantics, where fields that are either NULL, undefined, or missing return false when compared to NULL.