summaryrefslogtreecommitdiff
path: root/mysql-test/r/alter_table.result
diff options
context:
space:
mode:
authorunknown <msvensson@pilot.blaudden>2007-03-21 18:38:08 +0100
committerunknown <msvensson@pilot.blaudden>2007-03-21 18:38:08 +0100
commitc0016e92d71a34f145eccac89189dcf4d1e875aa (patch)
tree06ed79a78d1e3f3035851d9968c9bc6c7538d2b8 /mysql-test/r/alter_table.result
parent7c152303c62b4d812552e3dc476f6ada5a307cc4 (diff)
parent9248b580b96ba9246169b80ea0ea53be5137f6b0 (diff)
downloadmariadb-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.result24
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;