From fcf96dbb181a2afbab42ddd1e4a1f0fb2dd2061c Mon Sep 17 00:00:00 2001 From: "antony@ltantony.rdg.cyberkinetica.homeunix.net" <> Date: Wed, 10 Dec 2003 04:31:42 +0000 Subject: WorkLog#1323 Deprecate the use of TYPE=... Preferred syntax is ENGINE= --- mysql-test/t/innodb_handler.test | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'mysql-test/t/innodb_handler.test') 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); -- cgit v1.2.1