diff options
| author | antony@ltantony.rdg.cyberkinetica.homeunix.net <> | 2003-12-10 04:31:42 +0000 |
|---|---|---|
| committer | antony@ltantony.rdg.cyberkinetica.homeunix.net <> | 2003-12-10 04:31:42 +0000 |
| commit | fcf96dbb181a2afbab42ddd1e4a1f0fb2dd2061c (patch) | |
| tree | 786b29c1b82119fc7dc8cadff03c8bd8607d3deb /mysql-test/t/temp_table.test | |
| parent | 28113396ecc3a4594a6f0075e403407d0e1eb6e7 (diff) | |
| download | mariadb-git-fcf96dbb181a2afbab42ddd1e4a1f0fb2dd2061c.tar.gz | |
WorkLog#1323
Deprecate the use of TYPE=... Preferred syntax is ENGINE=
Diffstat (limited to 'mysql-test/t/temp_table.test')
| -rw-r--r-- | mysql-test/t/temp_table.test | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/t/temp_table.test b/mysql-test/t/temp_table.test index 03b6fa35bfa..2181d3eb74c 100644 --- a/mysql-test/t/temp_table.test +++ b/mysql-test/t/temp_table.test @@ -16,8 +16,8 @@ select * from t2; CREATE TABLE t2 (x int not null, y int not null); alter table t2 rename t1; select * from t1; -create TEMPORARY TABLE t2 type=heap select * from t1; -create TEMPORARY TABLE IF NOT EXISTS t2 (a int) type=heap; +create TEMPORARY TABLE t2 engine=heap select * from t1; +create TEMPORARY TABLE IF NOT EXISTS t2 (a int) engine=heap; # This should give errors !$1050 CREATE TEMPORARY TABLE t1 (a int not null, b char (10) not null); @@ -78,7 +78,7 @@ drop table t1; CREATE TABLE t1 ( d datetime default NULL -) TYPE=MyISAM; +) ENGINE=MyISAM; INSERT INTO t1 VALUES ('2002-10-24 14:50:32'),('2002-10-24 14:50:33'),('2002-10-24 14:50:34'),('2002-10-24 14:50:34'),('2002-10-24 14:50:34'),('2002-10-24 14:50:35'),('2002-10-24 14:50:35'),('2002-10-24 14:50:35'),('2002-10-24 14:50:35'),('2002-10-24 14:50:36'),('2002-10-24 14:50:36'),('2002-10-24 14:50:36'),('2002-10-24 14:50:36'),('2002-10-24 14:50:37'),('2002-10-24 14:50:37'),('2002-10-24 14:50:37'),('2002-10-24 14:50:37'),('2002-10-24 14:50:38'),('2002-10-24 14:50:38'),('2002-10-24 14:50:38'),('2002-10-24 14:50:39'),('2002-10-24 14:50:39'),('2002-10-24 14:50:39'),('2002-10-24 14:50:39'),('2002-10-24 14:50:40'),('2002-10-24 14:50:40'),('2002-10-24 14:50:40'); |