summaryrefslogtreecommitdiff
path: root/mysql-test/t/subselect_innodb.test
diff options
context:
space:
mode:
authorunknown <bell@sanja.is.com.ua>2004-01-17 13:00:46 +0200
committerunknown <bell@sanja.is.com.ua>2004-01-17 13:00:46 +0200
commit2de832dbf99a8796b081419a29cacbeb07cd3871 (patch)
tree89dba87bbf8d55bffb9d2843c235f27e310a5ff8 /mysql-test/t/subselect_innodb.test
parentdea4107141f986aaacb73f348ef48d989a501ca6 (diff)
downloadmariadb-git-2de832dbf99a8796b081419a29cacbeb07cd3871.tar.gz
switched to new syntax (TYPE->ENGINE)
check of memory allocation operation was added mysql-test/r/subselect_innodb.result: switched to new syntax mysql-test/t/subselect_innodb.test: switched to new syntax sql/sql_select.cc: check of memory allocation operation
Diffstat (limited to 'mysql-test/t/subselect_innodb.test')
-rw-r--r--mysql-test/t/subselect_innodb.test4
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/t/subselect_innodb.test b/mysql-test/t/subselect_innodb.test
index c17f3f30e39..affa6301db4 100644
--- a/mysql-test/t/subselect_innodb.test
+++ b/mysql-test/t/subselect_innodb.test
@@ -78,7 +78,7 @@ CREATE TABLE t1 (
c char(3) default NULL,
PRIMARY KEY (id),
KEY t2i1 (b)
-) TYPE=innodb DEFAULT CHARSET=latin1;
+) ENGINE=innodb DEFAULT CHARSET=latin1;
INSERT INTO t1 VALUES (0,0,'GPL'),(1,0,'GPL'),(2,1,'GPL'),(3,2,'GPL');
CREATE TABLE t2 (
id int(11) NOT NULL default '0',
@@ -86,7 +86,7 @@ CREATE TABLE t2 (
c char(3) default NULL,
PRIMARY KEY (id),
KEY t2i (b)
-) TYPE=innodb DEFAULT CHARSET=latin1;
+) ENGINE=innodb DEFAULT CHARSET=latin1;
INSERT INTO t2 VALUES (0,0,'GPL'),(1,0,'GPL'),(2,1,'GPL'),(3,2,'GPL');
select (select max(id) from t2 where b=1 group by b) as x,b from t1 where b=1;
drop table t1,t2;