Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.4.13, 10.5.4
-
None
-
None
-
Linux Debian 10 x86_64
Description
After inserting negative -2 in an auto-incremented column, the new generated serial jumps from 1 to 3, when it should be 2, according to the documentation:
https://mariadb.com/kb/en/auto_increment/#setting-explicit-values
The doc shows examples with positive values, but there is a clear sentence:
If the new value is lower than the current maximum value, the AUTO_INCREMENT value remains unchanged.
Which should include negative explicit values ...