Within A database transaction, the operating table, first BeginTransaction, and delete data. A, then insert the data B, C, last updated data CommitTransaction at last, the result is only updated data C is successful, A not deleted data, data B has not been inserted, and the code without any error,

Ever encountered such a problem? What reason be?

CodePudding user response:

Before the operation screenshot

According to the order operation

After the operation screenshot

CodePudding user response:

Problem complement: data A, B, C no dependencies

CodePudding user response:

Found the reason, there is query, query after turn off the connection