merge

1 files changed, 10 insertions, 1 deletions

diff --git a/mysql-test/t/alter_table.test b/mysql-test/t/alter_table.test
index 25cd0de6325..a47d206932c 100644
--- a/mysql-test/t/alter_table.test
+++ b/mysql-test/t/alter_table.test
@@ -71,7 +71,6 @@ ALTER TABLE t1 ADD Column new_col int not null;
 UNLOCK TABLES;
 OPTIMIZE TABLE t1;
 DROP TABLE t1;
-drop table if exists t1;
 
 #
 # ALTER TABLE ... ENABLE/DISABLE KEYS
@@ -91,3 +90,13 @@ while ($1)
 }
 alter table t1 enable keys;
 drop table t1;
+
+#
+# Drop and add an auto_increment column
+#
+
+create table t1 (i int unsigned not null auto_increment primary key);
+insert into t1 values (null),(null),(null),(null);
+alter table t1 drop i,add i int unsigned not null auto_increment, drop primary key, add primary key (i);
+select * from t1;
+drop table t1;