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

$inc behaves differently for missing vs null fields

    XMLWordPrintable

Details

    • Improvement
    • Status: Backlog
    • Major - P3
    • Resolution: Unresolved
    • None
    • None
    • Write Ops
    • None

    Description

      We usually try to treat null and missing fields mostly the same, so this seems like surprising behavior.

      MongoDB Enterprise asdf:PRIMARY> db.foo.insert({_id: 1, b: null})
      WriteResult({ "nInserted" : 1 })
      MongoDB Enterprise asdf:PRIMARY> db.foo.update({_id: 1}, {$inc: {a: 1}})
      WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })
      MongoDB Enterprise asdf:PRIMARY> db.foo.update({_id: 1}, {$inc: {b: 1}})
      WriteResult({
              "nMatched" : 0,
              "nUpserted" : 0,
              "nModified" : 0,
              "writeError" : {
                      "code" : 14,
                      "errmsg" : "Cannot apply $inc to a value of non-numeric type. {_id: 1.0} has the field 'b' of non-numeric type null"
              }
      })
      

      Attachments

        Activity

          People

            backlog-query-optimization Backlog - Query Optimization
            mathias@mongodb.com Mathias Stearn
            Votes:
            0 Vote for this issue
            Watchers:
            8 Start watching this issue

            Dates

              Created:
              Updated: