From fa31a9950babd887086c20419669b484d813f501 Mon Sep 17 00:00:00 2001
From: unknown <osku@127.(none)>
Date: Wed, 17 Aug 2005 11:00:20 +0300
Subject: Fix bug #11946, truncate not always resetting the auto-increment
 counter in InnoDB tables.

mysql-test/r/innodb.result:
  New tests.
mysql-test/t/innodb.test:
  New tests.
sql/ha_innodb.cc:
  Add reset_auto_increment.
sql/ha_innodb.h:
  Add reset_auto_increment.
sql/handler.h:
  Add reset_auto_increment.
sql/sql_delete.cc:
  Call handler->reset_auto_increment when needed.
---
 mysql-test/r/innodb.result | 23 +++++++++++++++++++++++
 1 file changed, 23 insertions(+)

(limited to 'mysql-test/r/innodb.result')

diff --git a/mysql-test/r/innodb.result b/mysql-test/r/innodb.result
index 69620d5d527..b2c78560562 100644
--- a/mysql-test/r/innodb.result
+++ b/mysql-test/r/innodb.result
@@ -2483,3 +2483,26 @@ delete t1 from t1,t2 where f1=f3 and f4='cc';
 select * from t1;
 f1	f2
 drop table t1,t2;
+CREATE TABLE t1 (
+id INTEGER NOT NULL AUTO_INCREMENT, PRIMARY KEY (id)
+) ENGINE=InnoDB;
+CREATE TABLE t2 (
+id INTEGER NOT NULL,
+FOREIGN KEY (id) REFERENCES t1 (id)
+) ENGINE=InnoDB;
+INSERT INTO t1 (id) VALUES (NULL);
+SELECT * FROM t1;
+id
+1
+TRUNCATE t1;
+INSERT INTO t1 (id) VALUES (NULL);
+SELECT * FROM t1;
+id
+1
+DELETE FROM t1;
+TRUNCATE t1;
+INSERT INTO t1 (id) VALUES (NULL);
+SELECT * FROM t1;
+id
+1
+DROP TABLE t2, t1;
-- 
cgit v1.2.1