Details
-
Task
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
None
Description
The SQL Standard (since at least 2016) supports
code
TRUNCATE TABLE [CONTINUE IDENTITY/RESTART IDENTITY]
code
This determines whether auto_increment counts should be restarted (the current MariaDB behaviour), or continued so as not to re-use the ids that were truncated.