Base auto value Integer is negative

[Phage]

Hi,

I have created tables and assigned a field with auto value. It used to start with 1 and incremented. However at some point it started to put IDs such as,
-2147483646
-2147483645
…
-2147483641
etc…

Why is it using negative values all of a sudden? How can I fix this issue?

Thanks a lot!

[Phage]

I have found a solution by setting the index increment value with following command:
ALTER TABLE “” ALTER COLUMN ID (I also had a column called ID which was the auto inc. identifier) RESTART WITH 5 (this last number should be 1 bigger than the biggest id in the table)