diff options
Diffstat (limited to 'mysql-test/r/isam.result')
| -rw-r--r-- | mysql-test/r/isam.result | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/mysql-test/r/isam.result b/mysql-test/r/isam.result index 80d78bc72da..4c698075150 100644 --- a/mysql-test/r/isam.result +++ b/mysql-test/r/isam.result @@ -1,11 +1,11 @@ drop table if exists t1,t2; -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; delete from t1 where (a & 1); select sum(length(b)) from t1; sum(length(b)) 3274494 drop table t1; -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); @@ -29,20 +29,20 @@ a b c 4 4 NULL 6 6 6 drop table t1; -create table t1 (a int,b text, index(a)) type=isam; +create table t1 (a int,b text, index(a)) engine=isam; ERROR 42000: Column 'a' is used with UNIQUE or INDEX but is not defined as NOT NULL -create table t1 (a int,b text, index(b)) type=isam; +create table t1 (a int,b text, index(b)) engine=isam; ERROR 42000: BLOB column 'b' can't be used in key specification with the used table type -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 42000: Incorrect table definition; There can only be one auto column and it must be defined as a key -create table t1 (ordid int(8), unique (ordid)) type=isam; +create table t1 (ordid int(8), unique (ordid)) engine=isam; ERROR 42000: Column 'ordid' is used with UNIQUE or INDEX but is not defined as NOT NULL drop table if exists t1; Warnings: Note 1051 Unknown table '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; Table Op Msg_type Msg_text test.t1 optimize status OK |