Details
-
Bug
-
Resolution: Fixed
-
Major - P3
-
None
-
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
Description
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}})
|
Attachments
Issue Links
- 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
-