Feature request: New tag to ignore identity columns on update
lampi87 opened this issue · 0 comments
lampi87 commented
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?