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/r/lock.result | |
| 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/r/lock.result')
| -rw-r--r-- | mysql-test/r/lock.result | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/r/lock.result b/mysql-test/r/lock.result index 68feb9c44d7..2cb9527b94b 100644 --- a/mysql-test/r/lock.result +++ b/mysql-test/r/lock.result @@ -1,5 +1,5 @@ drop table if exists t1,t2; -CREATE TABLE t1 ( `id` int(11) NOT NULL default '0', `id2` int(11) NOT NULL default '0', `id3` int(11) NOT NULL default '0', `dummy1` char(30) default NULL, PRIMARY KEY (`id`,`id2`), KEY `index_id3` (`id3`)) TYPE=MyISAM; +CREATE TABLE t1 ( `id` int(11) NOT NULL default '0', `id2` int(11) NOT NULL default '0', `id3` int(11) NOT NULL default '0', `dummy1` char(30) default NULL, PRIMARY KEY (`id`,`id2`), KEY `index_id3` (`id3`)) ENGINE=MyISAM; insert into t1 (id,id2) values (1,1),(1,2),(1,3); LOCK TABLE t1 WRITE; select dummy1,count(distinct id) from t1 group by dummy1; @@ -23,11 +23,11 @@ CREATE TABLE t1 ( index1 smallint(6) default NULL, nr smallint(6) default NULL, KEY index1(index1) -) TYPE=MyISAM; +) ENGINE=MyISAM; CREATE TABLE t2 ( nr smallint(6) default NULL, name varchar(20) default NULL -) TYPE=MyISAM; +) ENGINE=MyISAM; INSERT INTO t2 VALUES (1,'item1'); INSERT INTO t2 VALUES (2,'item2'); lock tables t1 write, t2 read; |