Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-67818

[CQF] NaN $eq NaN should be true

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

            Assignee:
            hana.pearlman@mongodb.com Hana Pearlman
            Reporter:
            david.percy@mongodb.com David Percy
            Votes:
            0 Vote for this issue
            Watchers:
            9 Start watching this issue

              Created:
              Updated:
              Resolved: