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

$in count query with null array does not yield error on empty collection

    • ALL

      A count on a collection that exists yields an error on an invalid query. All is good.

      > db.foos.insert(

      { bars: [ 1, 2 ]}

      )
      > db.foos.find({ bars : { $in : [ 1 ]}}).count()
      1
      > db.foos.find({ bars : { $in : null }}).count()
      Mon Feb 11 16:45:53 uncaught exception: count failed:

      { "errmsg" : "exception: invalid query", "code" : 12580, "ok" : 0 }

      A count on a collection that doesn't exist yields 0, which is, IMHO, incorrect.

      > db.invalid.find({ bars : { $in : null }}).count()
      0

      This is an odd optimization, I would expect them to fail the same way.

            Assignee:
            Unassigned Unassigned
            Reporter:
            dblock Daniel Doubrovkine
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: