no_auto_value_on_zero + alter table bug

1 files changed, 5 insertions, 0 deletions

diff --git a/mysql-test/t/auto_increment.test b/mysql-test/t/auto_increment.test
index 65770f32476..e5986e6755d 100644
--- a/mysql-test/t/auto_increment.test
+++ b/mysql-test/t/auto_increment.test
@@ -140,6 +140,11 @@ insert into t1(b)values(7);
 select * from t1 order by b;
 alter table t1 modify b mediumint;
 select * from t1 order by b;
+create table t2 (a int);
+insert t2 values (1),(2);
+alter table t2 add b int auto_increment primary key;
+select * from t2;
+drop table t2;
 delete from t1 where a=0;
 update t1 set a=0 where b=5;
 select * from t1 order by b;