[SERVER-58268] [SBE] $in match expression fails to match a document when NaN value types differ - MongoDB Jira

XML

Word

Printable

JSON

Operating System:
ALL
Steps To Reproduce:
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.
Sprint:
Query Execution 2021-07-12, Query Execution 2021-07-26
Linked BF Score:
33

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

duplicates

SERVER-57751 Hash of Decimal NaN and double NaN values can be different in SBE

is depended on by

SERVER-58193 Add test coverage for $in matching against +/-NaN