Details
-
New Feature
-
Resolution: Unresolved
-
Major - P3
-
None
-
None
-
None
-
Query Optimization
Description
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.