diff options
Diffstat (limited to 'mysql-test/t/isam.test')
-rw-r--r-- | mysql-test/t/isam.test | 14 |
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; |