db
db copied to clipboard
Feature request: New tag to ignore identity columns on update
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?