[SERVER-67818] [CQF] NaN $eq NaN should be true Created: 06/Jul/22  Updated: 29/Oct/23  Resolved: 12/Oct/23

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: 7.2.0-rc0

Type: Bug Priority: Major - P3
Reporter: David Percy Assignee: Hana Pearlman
Resolution: Fixed Votes: 0
Labels: bonsai-semantic-difference
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Related
related to SERVER-13767 $lt and $lte queries using 'NaN' trig... Closed
is related to SERVER-79219 [CQF] $lt, $lte should not match NaN Closed
Assigned Teams:
Query Optimization
Backwards Compatibility: Fully Compatible
Operating System: ALL
Sprint: QO 2022-08-08, QO 2022-08-22, QO 2023-09-18, QO 2023-10-02, QO 2023-10-16
Participants:

 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}})



 Comments   
Comment by Githook User [ 12/Oct/23 ]

Author:

{'name': 'Hana Pearlman', 'email': 'hana.pearlman@mongodb.com', 'username': 'HanaPearlman'}

Message: SERVER-67818: Add special case for NaN in CQF type bracketing
Branch: master
https://github.com/mongodb/mongo/commit/6675405636319284cbc8da1641894334ae755845

Generated at Thu Feb 08 06:09:08 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.