-
Type: Bug
-
Resolution: Fixed
-
Priority: Major - P3
-
Affects Version/s: None
-
Component/s: None
-
Query Optimization
-
Fully Compatible
-
ALL
-
QO 2022-08-08, QO 2022-08-22, QO 2023-09-18, QO 2023-10-02, QO 2023-10-16
The expected behavior, according to both classic and featureFlagSbeFull:
> db.c.insert({x:NaN}) WriteResult({ "nInserted" : 1 }) > db.c.find({x: {$eq: NaN}}) { "_id" : ObjectId("62c5ca859fc1b77153f70bc0"), "x" : NaN }
The actual behavior, in Bonsai:
> db.c.insert({x:NaN})
WriteResult({ "nInserted" : 1 })
> db.c.find({x: {$eq: NaN}})
- is related to
-
SERVER-79219 [CQF] $lt, $lte should not match NaN
- Closed
- related to
-
SERVER-13767 $lt and $lte queries using 'NaN' trigger invalid bounds asserts
- Closed