Builtin variable $$NOW is not available in document validation

XMLWordPrintableJSON

    • Type: Bug
    • Resolution: Fixed
    • Priority: Major - P3
    • 7.0.0-rc0, 6.3.0-rc1, 5.0.16, 6.0.6
    • Affects Version/s: 5.0.8
    • Component/s: None
    • None
    • Query Execution
    • Fully Compatible
    • ALL
    • v6.3, v6.0, v5.0
    • Hide 
      db.col1.drop();
db.createCollection("col1", {validator:{"$expr": {$lt: ["$ts", "$$NOW"]}}}); 
db.col1.insert({"ts": new Date(1589617694938)});

       

      Show
      db.col1.drop(); db.createCollection( "col1" , {validator:{ "$expr" : {$lt: [ "$ts" , "$$NOW" ]}}}); db.col1.insert({ "ts" : new Date(1589617694938)});  
    • QE 2023-02-20, QE 2023-03-06
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      Using validation for a collection with following document validator:

       

       

      db.createCollection("col1", {
  validator:{
    "$expr": {
      $lt: ["$ts", "$$NOW"]
    }
  }
});

       

      results with

       

      { ok: 1 }

       

       

      An attempt to insert a document with any value in `ts` field fail validation with following error:

       

      { result:    
  { ok: 1,     
    writeErrors:       
      [ { err:
           { index: 0,
             code: 121,
             errmsg: 'Document failed validation',
             errInfo:
               { failingDocumentId: {},
                details:
                  { operatorName: '$expr',
                   specifiedAs: { '$expr': { '$lt': [ '$ts', '$$NOW' ] } },
                   reason: 'failed to evaluate aggregation expression',
                   details:
                     { code: 51144,
                      codeName: 'Location51144',
                      errmsg: 'Builtin variable \'$$NOW\' is not available' } } },
             op: { ts: 2020-05-16T08:28:14.938Z, _id: {} } } } ],
     writeConcernErrors: [],
     insertedIds: [ { index: 0, _id: {} } ],
     nInserted: 0,
     nUpserted: 0,
     nMatched: 0,
     nModified: 0,
     nRemoved: 0,
     upserted: [] } }

       

       

            Assignee:
            Naama Bareket
            Reporter:
            Alex Blex
            Votes:
            0 Vote for this issue
            Watchers:
            10 Start watching this issue

              Created:
              Updated:
              Resolved: