From 1f409baf4cb3bca2ee62b40363a2179f0a3b1f88 Mon Sep 17 00:00:00 2001
From: "monty@tik.mysql.fi" <>
Date: Mon, 11 Jun 2001 15:01:28 +0300
Subject: Changed compare in MyISAM to use my_pread() Fixed that @VAR shows all
 decimals Fixed problem with FLUSH TABLES and LOCK TABLE CREATE ... SELECT now
 creates keys later Reset AUTO_INCREMENT order if droping AUTO_INCREMENT key

---
 mysql-test/t/alter_table.test | 11 +++++++++++
 1 file changed, 11 insertions(+)

(limited to 'mysql-test/t/alter_table.test')

diff --git a/mysql-test/t/alter_table.test b/mysql-test/t/alter_table.test
index da98240c2cf..dbfbd4267d8 100644
--- a/mysql-test/t/alter_table.test
+++ b/mysql-test/t/alter_table.test
@@ -71,3 +71,14 @@ ALTER TABLE t1 ADD Column new_col int not null;
 UNLOCK TABLES;
 OPTIMIZE TABLE t1;
 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;
+
-- 
cgit v1.2.1