BaGet icon indicating copy to clipboard operation
BaGet copied to clipboard

Concurrency conflicts for download counter not detected using SQLite

Open appel1 opened this issue 3 years ago • 0 comments

Was looking at #716 and couldn't reproduce the issue using an SQLite db. I'm not sure, but I think the EF SQLite implementation does not update the specified rowVersion column automatically. You have to add a trigger that updates it yourself in a migration.

To reproduce download a package and check the RowVersion column in the db. It is still the default value, null.

Simulating a concurrency conflict does not trigger a DbUpdateConcurrencyException either.

appel1 avatar Feb 08 '22 10:02 appel1