upper/db

Feature request: New tag to ignore identity columns on update

lampi87 opened this issue · 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?