diff options
Diffstat (limited to 'mysql-test/t/innodb_handler.test')
| -rw-r--r-- | mysql-test/t/innodb_handler.test | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/t/innodb_handler.test b/mysql-test/t/innodb_handler.test index cf6ac9870ce..e8c486caf66 100644 --- a/mysql-test/t/innodb_handler.test +++ b/mysql-test/t/innodb_handler.test @@ -8,7 +8,7 @@ drop table if exists t1,t2; --enable_warnings -create table t1 (a int, b char(10), key a(a), key b(a,b)) type=innodb; +create table t1 (a int, b char(10), key a(a), key b(a,b)) engine=innodb; insert into t1 values (17,"ddd"),(18,"eee"),(19,"fff"),(19,"yyy"), (14,"aaa"),(15,"bbb"),(16,"ccc"),(16,"xxx"), @@ -71,12 +71,12 @@ handler t2 close; handler t1 open as t2; handler t2 read first; -alter table t1 type=innodb; +alter table t1 engine=innodb; --error 1109 handler t2 read first; drop table t1; -CREATE TABLE t1 ( no1 smallint(5) NOT NULL default '0', no2 int(10) NOT NULL default '0', PRIMARY KEY (no1,no2)) TYPE=InnoDB; +CREATE TABLE t1 ( no1 smallint(5) NOT NULL default '0', no2 int(10) NOT NULL default '0', PRIMARY KEY (no1,no2)) ENGINE=InnoDB; INSERT INTO t1 VALUES (1,274),(1,275),(2,6),(2,8),(4,1),(4,2); HANDLER t1 OPEN; HANDLER t1 READ `primary` = (1, 1000); |