-
Type:
New Feature
-
Resolution: Unresolved
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: Aggregation Framework
-
None
-
Query Optimization
-
None
-
3
-
None
-
None
-
None
-
None
-
None
-
None
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.
- is related to
-
SERVER-105057 SQL-style NULL semantics for equijoins are difficult to emulate with $lookup
-
- Backlog
-