Is it normal for the updatedAt column to always be...
# orm-help
p
Is it normal for the updatedAt column to always be updated even when no data is changed when using upsert: https://www.prisma.io/docs/concepts/components/prisma-client/relation-queries#update-or-create-a-related-record
Copy code
const update = await prisma.post.update({
  where: {
    id: 6,
  },
  data: {
    author: {
      upsert: {
        create: {
          email: '<mailto:bob@prisma.io|bob@prisma.io>',
          name: 'Bob the New User',
        },
        update: {
          email: '<mailto:bob@prisma.io|bob@prisma.io>',
          name: 'Bob the existing user',
        },
      },
    },
  },
})
1
n
Hi Peter 👋 Every time an update query is invoked, the
updatedAt
column will be updated with the current time even if the data being updated is same as existing data. So this would be expected behaviour.