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

[CQF] Equality to null does not match undefined

XMLWordPrintableJSON

    • Type: Icon: Bug Bug
    • Resolution: Unresolved
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • Query Optimization
    • ALL

      This is specific to bonsai, the classic optimizer does not have this issue. Equality to null correctly matches null and missing, however it misses values which are explicitly undefined. Simplest repro:

      db.test.insert({_id: "a_undefined", a: undefined});
assert.eq(db.test.find({a: null}).toArray(), [{_id: "a_undefined", a: undefined}]);

            Assignee:
            backlog-query-optimization [DO NOT USE] Backlog - Query Optimization
            Reporter:
            nicholas.zolnierz@mongodb.com Nicholas Zolnierz
            Votes:
            0 Vote for this issue
            Watchers:
            10 Start watching this issue

              Created:
              Updated: