Bug #1514 truncate table not set auto_incerement to 1 on InnoDB tables

• Submitted: 10 Oct 2003 0:30
• Modified: 11 Aug 2005 14:23
• Reporter: [ name withheld ]
• Status: Duplicate
• Category: MySQL Server: InnoDB storage engine
• Severity: S3 (Non-critical)
• Version: 4.1
• OS: Linux (Linux)
• Assigned to: Assigned Account
• CPU Architecture: Any

[10 Oct 2003 0:30] [ name withheld ]

Description:
If I execute a truncate table command on MyISAM tables, the auto_increment value set to 1. But on InnoDB tables not set to 1, it remains the old value. Why?

How to repeat:
It's easy...

[10 Dec 2003 20:40] Michael Widenius

The value of auto_increment is only reset of MyISAM, ISAM and BDB tables, not for InnoDB tables.  I have updated the MySQL manual about this.

We shall look at fixing this in future MySQL versions (Probably 4.1.x or 5.x)

[11 Aug 2005 14:23] Heikki Tuuri

Duplicate of bug #11946