summaryrefslogtreecommitdiff
path: root/mysql-test/t/isam.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/t/isam.test')
-rw-r--r--mysql-test/t/isam.test14
1 files changed, 7 insertions, 7 deletions
diff --git a/mysql-test/t/isam.test b/mysql-test/t/isam.test
index e35ed0dfd4a..f77d29fd20f 100644
--- a/mysql-test/t/isam.test
+++ b/mysql-test/t/isam.test
@@ -8,7 +8,7 @@ drop table if exists t1,t2;
# Test possible problem with rows that are about 65535 bytes long
#
-create table t1 (a tinyint not null auto_increment, b blob not null, primary key (a)) type=isam;
+create table t1 (a tinyint not null auto_increment, b blob not null, primary key (a)) engine=isam;
let $1=100;
disable_query_log;
@@ -28,7 +28,7 @@ drop table t1;
# Test of auto_increment; The test for BDB tables is in bdb.test
#
-create table t1 (a int not null auto_increment,b int, primary key (a)) type=isam;
+create table t1 (a int not null auto_increment,b int, primary key (a)) engine=isam;
insert into t1 values (1,1),(NULL,2),(3,3),(NULL,4);
delete from t1 where a=4 or a=2;
insert into t1 values (NULL,4),(NULL,5),(6,6);
@@ -46,13 +46,13 @@ drop table t1;
# Test of some CREATE TABLE's that should fail
#
--error 1121
-create table t1 (a int,b text, index(a)) type=isam;
+create table t1 (a int,b text, index(a)) engine=isam;
--error 1073
-create table t1 (a int,b text, index(b)) type=isam;
+create table t1 (a int,b text, index(b)) engine=isam;
--error 1075
-create table t1 (ordid int(8) not null auto_increment, ord varchar(50) not null, primary key (ord,ordid)) type=isam;
+create table t1 (ordid int(8) not null auto_increment, ord varchar(50) not null, primary key (ord,ordid)) engine=isam;
--error 1121
-create table t1 (ordid int(8), unique (ordid)) type=isam;
+create table t1 (ordid int(8), unique (ordid)) engine=isam;
drop table if exists t1;
#
@@ -61,7 +61,7 @@ drop table if exists t1;
create table t1 (a int not null primary key, b int not null,c int not null, key(b,c));
insert into t1 values (1,2,2),(2,2,3),(3,2,4),(4,2,4);
-create table t2 type=isam select * from t1;
+create table t2 engine=isam select * from t1;
optimize table t1;
check table t1,t2;
repair table t1,t2;