summaryrefslogtreecommitdiff
path: root/mysql-test/r/alter_table.result
diff options
context:
space:
mode:
authorunknown <msvensson@pilot.blaudden>2007-04-25 11:13:41 +0200
committerunknown <msvensson@pilot.blaudden>2007-04-25 11:13:41 +0200
commit329514bb02b5b16146cde9983b71ad930c67add8 (patch)
treec96cec137b41b7527b879ae1bf074e1217a74d0a /mysql-test/r/alter_table.result
parent006d9d65788be02d16911c5ca96bfc618615ff56 (diff)
parentc0016e92d71a34f145eccac89189dcf4d1e875aa (diff)
downloadmariadb-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.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 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;