diff options
Diffstat (limited to 'mysql-test/r/innodb_handler.result')
| -rw-r--r-- | mysql-test/r/innodb_handler.result | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/r/innodb_handler.result b/mysql-test/r/innodb_handler.result index 1fadc3a61de..a608e5c71ab 100644 --- a/mysql-test/r/innodb_handler.result +++ b/mysql-test/r/innodb_handler.result @@ -1,5 +1,5 @@ drop table if exists t1,t2; -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"), @@ -136,11 +136,11 @@ handler t1 open as t2; handler t2 read first; a b 17 ddd -alter table t1 type=innodb; +alter table t1 engine=innodb; handler t2 read first; ERROR 42S02: Unknown table 't2' in HANDLER 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); |