db icon indicating copy to clipboard operation
db copied to clipboard

Feature request: New tag to ignore identity columns on update

Open lampi87 opened this issue 3 years ago • 0 comments

At the moment identity columns are not ignored on using updater for mssql connection like

q = sess.SQL().
  Update("user").
  Set(user).Where("id = ?", 5)
res, err = q.Exec()

This will lead to an error mssql: Cannot update identity column 'id'. because column "id" is included into update SQL query

UPDATE [user] SET ..., [id] = ?, ... WHERE (id = ?)

Is it possible to add an additional tag like omitupdate or something else to mark "id" column to be ignored?

lampi87 avatar Jan 18 '23 11:01 lampi87