diff options
author | unknown <msvensson@pilot.blaudden> | 2007-03-21 18:38:08 +0100 |
---|---|---|
committer | unknown <msvensson@pilot.blaudden> | 2007-03-21 18:38:08 +0100 |
commit | c0016e92d71a34f145eccac89189dcf4d1e875aa (patch) | |
tree | 06ed79a78d1e3f3035851d9968c9bc6c7538d2b8 /mysql-test/r/alter_table.result | |
parent | 7c152303c62b4d812552e3dc476f6ada5a307cc4 (diff) | |
parent | 9248b580b96ba9246169b80ea0ea53be5137f6b0 (diff) | |
download | mariadb-git-c0016e92d71a34f145eccac89189dcf4d1e875aa.tar.gz |
Merge pilot.blaudden:/home/msvensson/mysql/bug25262/my50-bug25262
into pilot.blaudden:/home/msvensson/mysql/bug25262/my51-bug25262
mysql-test/r/alter_table.result:
Manual merge
mysql-test/t/alter_table.test:
Manual merge
sql/sql_table.cc:
Manual merge, auto_increment_value variable has moved into "stats"
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 571ac8498b3..7f19ef11b1f 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; |