$avg of Infinity and null is NaN on debug builds

XMLWordPrintableJSON

    • Query Optimization
    • Fully Compatible
    • ALL
    • Hide
      MongoDB Enterprise > db.test.find()
      { "_id" : 1, "a" : Infinity }
      { "_id" : 2, "a" : null }
      MongoDB Enterprise > db.test.aggregate([{$group:{_id: null, num:{$avg:"$a"}}}])
      { "_id" : null, "num" : NaN } // debug build
      { "_id" : null, "num" : Infinity } // non-debug build, correct behavior.
      
      Show
      MongoDB Enterprise > db.test.find() { "_id" : 1, "a" : Infinity } { "_id" : 2, "a" : null } MongoDB Enterprise > db.test.aggregate([{$group:{_id: null, num:{$avg:"$a"}}}]) { "_id" : null, "num" : NaN } // debug build { "_id" : null, "num" : Infinity } // non-debug build, correct behavior.
    • 200
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None
    • None

            Assignee:
            Carlos Alonso Pérez
            Reporter:
            Robert Guo (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            8 Start watching this issue

              Created:
              Updated:
              Resolved: