summaryrefslogtreecommitdiff
path: root/mysql-test/t/create.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/t/create.test')
-rw-r--r--mysql-test/t/create.test8
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/t/create.test b/mysql-test/t/create.test
index 54166c3b0dc..32565c0e20b 100644
--- a/mysql-test/t/create.test
+++ b/mysql-test/t/create.test
@@ -18,7 +18,7 @@ insert into t1 values (""),(null);
select * from t1;
drop table t1;
-create table t1 (a int not null auto_increment,primary key (a)) type=heap;
+create table t1 (a int not null auto_increment,primary key (a)) engine=heap;
drop table t1;
#
@@ -26,18 +26,18 @@ drop table t1;
#
--error 1146
-create table t2 type=heap select * from t1;
+create table t2 engine=heap select * from t1;
--error 1146
create table t2 select auto+1 from t1;
drop table if exists t1,t2;
--error 1167
create table t1 (b char(0) not null, index(b));
--error 1163
-create table t1 (a int not null,b text) type=heap;
+create table t1 (a int not null,b text) engine=heap;
drop table if exists t1;
--error 1075
-create table t1 (ordid int(8) not null auto_increment, ord varchar(50) not null, primary key (ord,ordid)) type=heap;
+create table t1 (ordid int(8) not null auto_increment, ord varchar(50) not null, primary key (ord,ordid)) engine=heap;
-- error 1044,1
create table not_existing_database.test (a int);