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

Compare Date vs timestamp errors out, timestamp vs Date doesn't

    • Type: Icon: Bug Bug
    • Resolution: Duplicate
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: 2.2.2, 2.3.2
    • Component/s: Querying
    • ALL
    • Hide
      > db.a.drop()
      > db.a.insert({d:new Date(), ts: new Timestamp()})
      > db.a.find({ts:Date()})
      > db.a.find({d:Timestamp()})
      error: { "$err" : "wrong type for field (d) 17 != 9", "code" : 13111 }
      
      Show
      > db.a.drop() > db.a.insert({d: new Date(), ts: new Timestamp()}) > db.a.find({ts:Date()}) > db.a.find({d:Timestamp()}) error: { "$err" : "wrong type for field (d) 17 != 9" , "code" : 13111 }

      Comparing Date to timestamp causes an error to appear in the shell, comparing timestamp to date does not. Also the error is not very descriptive in the shell.

      > db.a.drop()
      > db.a.insert({d:new Date(), ts: new Timestamp()})
      > db.a.find({ts:Date()})
      > db.a.find({d:Timestamp()})
      error: { "$err" : "wrong type for field (d) 17 != 9", "code" : 13111 }
      

      Sorting on such a collection is also broken:

      > db.a.drop()
      > db.a.insert({a:Timestamp()})
      > db.a.insert({a:ISODate()})
      > db.a.find().sort({a:1})
      error: { "$err" : "wrong type for field () 17 != 9", "code" : 13111 }
      

            Assignee:
            alerner Alberto Lerner
            Reporter:
            andre.defrere@mongodb.com Andre de Frere
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: