MySQL: Not respecting AUTO_INCREMENT when inserting new records

[maksimovic]

sqlfuzz expects a table to be completely clean, so if a table already contains some data it then fails:

2021/04/24 15:08:26 Error 1062: Duplicate entry '1' for key 'PRIMARY'

In my case, i can't have a completely empty table/database due to various constrains, but I do want to add e.g. 100k new records.

SHOW CREATE TABLE table spits out AUTO_INCREMENT=XX so XX should be the starting point instead of 1.

[maksimovic]

Just checked the target table because it was suspicious to me that I got 4 errors for duplicate PK when I set it to insert 10 records. For some reason, it tried to insert 4 rows with value 1, which exists, but it then did insert 6 new rows starting from the correct AUTO_INCREMENT, which was actually 22 (so I got 6 new rows 22-27). Pretty weird?