Fix auto reversing with insert data #1963
Conversation
|
This looks great. Assuming the build passes I will merge it. Thanks for your patience! Had a few important unexpected family events recently. |
|
Apologies while I was sorting out some build pipeline stuff. It looks like your code has an issue |
1b1e047 to
beaa95a
Compare
|
@jzabroski |
|
@AdrianoRNascimento Your test stub class for auto-reversing broke an unrelated test that was checking to see if we applied all migrations in the assembly - I fixed it and added it to your branch. Re-running the build now and all should pass, then we will merge it. Thanks for your wonderful contribution. |
|
@jzabroski |
When a table has an FK to itself, the current approach of auto-reverting the inserts fails because it tries to delete rows in the same order they were inserted.
As an example, SQL Server generates this error:
To solve this error, deleting the rows in the inverted order they were inserted is appropriate, exactly as it happens with the expressions.