[MDEV-31415] Implement TRUNCATE TABLE [CONTINUE IDENTITY/RESTART IDENTITY] Created: 2023-06-06  Updated: 2023-06-27

Status: Open
Project: MariaDB Server
Component/s: Data Manipulation - Delete
Fix Version/s: None

Type: Task Priority: Minor
Reporter: Ian Gilfillan Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: sql2016


 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.
Generated at Thu Feb 08 10:23:42 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.