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

[SBE] $in match expression fails to match a document when NaN value types differ

XMLWordPrintableJSON

    • Type: Icon: Bug Bug
    • Resolution: Duplicate
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • ALL
    • Hide

       

       db.coll.insert({a: {b: NaN}})
 db.coll.aggregate([{$match: {"a.b": {$in: [NumberDecimal("-NaN"), ["deposit", {str: "overriding"}]]}}}])

      Expected: to match the document.
      Actual: document does not match.

      Show
         db.coll.insert({a: {b: NaN}})  db.coll.aggregate([{$match: { "a.b" : {$in: [NumberDecimal( "-NaN" ), [ "deposit" , {str: "overriding" }]]}}}]) Expected : to match the document. Actual : document does not match.
    • Query Execution 2021-07-12, Query Execution 2021-07-26
    • 33
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None

      $in match expression fails to match a document when NaN value types differ, that is when one type is double and another Decimal128.

       

       

            Assignee:
            mindaugas.malinauskas@mongodb.com Mindaugas Malinauskas
            Reporter:
            mindaugas.malinauskas@mongodb.com Mindaugas Malinauskas
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: