Uploaded image for project: 'MongoDB Shell'
  1. MongoDB Shell
  2. MONGOSH-1263

$jsonSchema reported error on double data type

    • Type: Icon: Bug Bug
    • Resolution: Done
    • Priority: Icon: Major - P3 Major - P3
    • No version
    • Affects Version/s: None
    • Component/s: Embedded Shell
    • None
    • Environment:
      MongoDB Enterprise v4.4.15 and mongosh v1.1.9.
    • Not Needed

      Problem Statement/Rationale

      $jsonSchema report error on double data type.  It is reported by a customer where provided value 2.0 is not recognized as a double value.

      Please be sure to attach relevant logs with any sensitive data redacted.

      Steps to Reproduce

      use rlr

      val = { $jsonSchema: { bsonType: 'object', properties: { shippingServiceId:

      Unknown macro: { bsonType}

      , customerPostalCode: { bsonType: 'string', description: 'must be a string' }, depotId: { bsonType: 'int', description: 'must be an int' }, transitDays: { bsonType: 'int', description: 'must be a int' }, cost: { bsonType: 'double', description: 'cost for shipping service' } } } }

      db.createCollection( 'ShippingServiceTransitTimeCost', { validator: val })

       

      Insert the following failed:

      db.ShippingServiceTransitTimeCost.insert({ shippingServiceId: 1, customerPostalCode: "12345", transitDays: 2, depotId: 13, cost: 2.0 })

       

      Change `cost: 2.0` to `cost: 2.1` worked. 

      db.ShippingServiceTransitTimeCost.insert({ shippingServiceId: 1, customerPostalCode: "12345", transitDays: 2, depotId: 13, cost: 2.1 })

       

      The following also worked:

      {{db.ShippingServiceTransitTimeCost.insert({ shippingServiceId: 1, customerPostalCode: "12345", transitDays: 2, depotId: 13, cost: Double('2.0') })}}

      Expected Results

      {{{}}
        acknowledged: true,
      {{  insertedIds: { '0': ObjectId("62c6febcff2ba21ad88c843e") }}}
      {{}}}

      Actual Results

      {{Result: BulkWriteResult {}}
        result: {
          ok: 1,
          writeErrors: [
            WriteError {
              err: {
                index: 0,
                code: 121,
                errmsg: 'Document failed validation',
                errInfo: undefined,
                op: {
                  shippingServiceId: 1,
                  customerPostalCode: '12345',
                  transitDays: 2,
                  depotId: 13,
                  cost: 2,
                  _id: ObjectId("62c6fea3ff2ba21ad88c843d")
      {{          }}}
      {{        }}}
      {{      }}}
          ],
          writeConcernErrors: [],
          insertedIds: [ { index: 0, _id: ObjectId("62c6fea3ff2ba21ad88c843d") } ],
          nInserted: 0,
          nUpserted: 0,
          nMatched: 0,
          nModified: 0,
          nRemoved: 0,
          upserted: [],
      {{    opTime: { ts: Timestamp({ t: 1657208473, i: 1 }), t: Long("11") }}}
      {{  }}}

      h3. Additional Notes

      Any additional information that may be useful to include.

            Assignee:
            Unassigned Unassigned
            Reporter:
            ken.chen@mongodb.com Ken Chen
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: