diff options
author | unknown <msvensson@pilot.blaudden> | 2007-04-25 11:13:41 +0200 |
---|---|---|
committer | unknown <msvensson@pilot.blaudden> | 2007-04-25 11:13:41 +0200 |
commit | 329514bb02b5b16146cde9983b71ad930c67add8 (patch) | |
tree | c96cec137b41b7527b879ae1bf074e1217a74d0a /mysql-test/r/alter_table.result | |
parent | 006d9d65788be02d16911c5ca96bfc618615ff56 (diff) | |
parent | c0016e92d71a34f145eccac89189dcf4d1e875aa (diff) | |
download | mariadb-git-329514bb02b5b16146cde9983b71ad930c67add8.tar.gz |
Merge pilot.blaudden:/home/msvensson/mysql/bug25262/my51-bug25262
into pilot.blaudden:/home/msvensson/mysql/mysql-5.1-maint
mysql-test/r/alter_table.result:
Auto merged
mysql-test/t/alter_table.test:
Auto merged
sql/sql_table.cc:
Auto merged
Diffstat (limited to 'mysql-test/r/alter_table.result')
-rw-r--r-- | mysql-test/r/alter_table.result | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/r/alter_table.result b/mysql-test/r/alter_table.result index fa18b58a927..4481b56791f 100644 --- a/mysql-test/r/alter_table.result +++ b/mysql-test/r/alter_table.result @@ -822,6 +822,30 @@ desc t1; Field Type Null Key Default Extra mycol int(10) NO 0 drop table t1; +create table t1(id int(8) primary key auto_increment) engine=heap; +insert into t1 values (null); +insert into t1 values (null); +select * from t1; +id +1 +2 +alter table t1 auto_increment = 50; +alter table t1 engine = myisam; +insert into t1 values (null); +select * from t1; +id +1 +2 +50 +alter table t1 engine = heap; +insert into t1 values (null); +select * from t1; +id +1 +2 +50 +51 +drop table t1; create table t1 (v varchar(32)); insert into t1 values ('def'),('abc'),('hij'),('3r4f'); select * from t1; |