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

[CQF] Equality to null does not match undefined

    XMLWordPrintableJSON

Details

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Major - P3 Major - P3
    • None
    • None
    • None
    • Query Optimization
    • ALL

    Description

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

      Attachments

        Activity

          People

            backlog-query-optimization Backlog - Query Optimization
            nicholas.zolnierz@mongodb.com Nicholas Zolnierz
            Votes:
            0 Vote for this issue
            Watchers:
            8 Start watching this issue

            Dates

              Created:
              Updated: