Loading...

XML

Word

Printable

JSON

Operating System:
ALL
Steps To Reproduce:
Hide

Use Mongo 5.0.6

Run the following commmand to insert a document:
{{> db.runCommand({ "findAndModify" : "collection", "query" : { "_id" : ObjectId("628d26b2f8221751cdd7dcd2") }
, "update" : { "$set" :
{ "name" : "some name" }
}, "new": true, "upsert": true })}}
{{}}

Run the following command to update the document with the same values:{}{{{}> db.runCommand({ "findAndModify" : "collection", "query" : { "_id" : ObjectId("628d26b2f8221751cdd7dcd2") }
, "update" : { "$set" :
{ "name" : "some name" }
}, "new": true, "upsert": true }){}}}
{{}}

Observe the result state:
{{{}lastErrorObject:
Unknown macro: { n}

,{}}}{}
Show
Use Mongo 5.0.6 Run the following commmand to insert a document: {{> db.runCommand({ "findAndModify" : "collection", "query" : { "_id" : ObjectId("628d26b2f8221751cdd7dcd2") } , "update" : { "$set" : { "name" : "some name" } }, "new": true, "upsert": true })}} {{}} Run the following command to update the document with the same values: { } {{{}> db.runCommand({ "findAndModify" : "collection", "query" : { "_id" : ObjectId("628d26b2f8221751cdd7dcd2") } , "update" : { "$set" : { "name" : "some name" } }, "new": true, "upsert": true }){}}} {{}} Observe the result state: {{{}lastErrorObject: Unknown macro: { n} ,{}}}{ }

I've noticed an issue with findAndModify, where updatedExisting always return true when updating a field with the same value.

However, I would expect updatedExisting to be true if the document was upserted or if any modification was done to the existing document. Similar to how the update command output: https://www.mongodb.com/docs/manual/reference/command/update/#mongodb-data-update.nModified

duplicates

SERVER-28145 add ability to obtain modified flag from findOneAndUpdate result

is related to

SERVER-28145 add ability to obtain modified flag from findOneAndUpdate result