Open-MSS / MSS / 10491594183

70%

push

github

Fix sequences after migrating data to PostgreSQL (#2466)

When inserting rows into PostgreSQL tables and explicitly setting values
for e.g. auto-increment columns, like the IDs, the associated sequences
aren't automatically updated. This means that without explicitly fixing
the sequences PostgreSQL would try to insert new rows with existing
values for the IDs, failing in the process due to unique constraints.

This issue doesn't affect MariaDB nor SQLite. The former automatically
updates auto-increment counters on insert, the latter simply uses the
last rows ID as a starting point.

This change also extends the tests to try adding a new user after the
migration, which should catch this kind of issue.

1 of 6 new or added lines in 1 file covered. (16.67%)

13905 of 19859 relevant lines covered (70.02%)

0.7 hits per line