Update query in mongodb

Question

Suppose I have this document in mongodb collection:

{
  "_id": {
    "playerId": "113069",
    "tournamentId": "197831"
  },
  "__v": 0,
  "playerName": "David WArner",
  "pointsTotal": 426
}

I update it using this update query(using mongoose):

await PointsTotal.findOneAndUpdate(
      {
        _id: {
          playerId: player._id,
          tournamentId: tournamentId,
        }
      },
      {
        $set: {
          playerName: playerName,
          pointsTotal: totalPoints
        },
      },
      {
        upsert: true,
      }
    );
  }

But, if the playerName and totalPoints is same as before updating, will it perform update operation to overwrite these fields and I am able to listen this update in change stream or not?

Joe · Accepted Answer · 2021-11-07 06:34:40Z

1

No, if there is no change to the document MongoDB will not perform a write, there will be no operation in the oplog, and nothing will appear in the change stream.

answered Nov 7, 2021 at 6:34

Joe

29k4 gold badges25 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Update query in mongodb

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related