-
Type: Bug
-
Resolution: Fixed
-
Priority: Major - P3
-
Affects Version/s: None
-
Component/s: None
-
Query Execution
-
Fully Compatible
-
ALL
-
v8.0
-
QE 2022-09-19
Consider the following example running the classic engine:
> db.c.insert({b: 1}) > db.c.find({a: {$gt: MinKey()}}) {b: 1}
Because the `a` field is missing in the document, it is implicitly `null` for the purposes of evaluating `a > MinKey()`. Because of BSON ordering semantics, `null` is greater than `MinKey()`, and results in the document being matched.
When SBE (featureFlagSbeFull) is enabled, the server incorrectly omits this document.
- is duplicated by
-
SERVER-96016 Find predicate {$gte: MinKey} is inconsistent in SBE
- Closed