From 864405db7d9bd1c627ca787324e9db81ea9e19bf Mon Sep 17 00:00:00 2001 From: unknown Date: Fri, 30 Jul 2004 14:17:12 +0200 Subject: no_auto_value_on_zero + alter table bug --- mysql-test/t/auto_increment.test | 5 +++++ 1 file changed, 5 insertions(+) (limited to 'mysql-test/t/auto_increment.test') 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; -- cgit v1.2.1