Cannot delete rows from a temporal history table

jbogard / Respawn

Intelligent database cleaner for integration tests

Apache License 2.0

2.67k stars 134 forks source link

Cannot delete rows from a temporal history table #120

Open mslowin opened 1 year ago

mslowin commented 1 year ago

I have an SQL database with temporal tables that contain the history of changes. When I try to use ResetAsync(), it throws this error. While debugging, I can see that the respawner.DeleteSql property has all the tables I want to be deleted - both regular tables and temporal tables.

chris-smith-steris commented 1 year ago

Did you set CheckTemporalTables = true within RespawnerOptions?

JanEggers commented 4 weeks ago

just stumbled over this. is there any reason not to make CheckTemporalTables = true the default?