GoodBoyCoder commented on issue #6449: URL: https://github.com/apache/incubator-seata/issues/6449#issuecomment-2043061649
当前版本AT模式的SqlServer在执行Delete场景回滚的时候会默认执行`set identity_insert table_name ON` 以开启主键插入，当表中没有标识列的情况下执行该语句就会抛出上面的问题，目前可以快速解决的方案是为该表建一个额外的标识列 The current version of SqlServer in AT mode will execute `set identity_insert table_name on` by default when executing Delete scenario rollback to enable primary key insertion. When there is no identity column in the table, executing this statement will throw the above problem. The current quick solution is to create an additional identity column for this table. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
