summaryrefslogtreecommitdiff
path: root/mysql-test/t/func_if.test
diff options
context:
space:
mode:
authorantony@ltantony.rdg.cyberkinetica.homeunix.net <>2003-12-10 04:31:42 +0000
committerantony@ltantony.rdg.cyberkinetica.homeunix.net <>2003-12-10 04:31:42 +0000
commitfcf96dbb181a2afbab42ddd1e4a1f0fb2dd2061c (patch)
tree786b29c1b82119fc7dc8cadff03c8bd8607d3deb /mysql-test/t/func_if.test
parent28113396ecc3a4594a6f0075e403407d0e1eb6e7 (diff)
downloadmariadb-git-fcf96dbb181a2afbab42ddd1e4a1f0fb2dd2061c.tar.gz
WorkLog#1323
Deprecate the use of TYPE=... Preferred syntax is ENGINE=
Diffstat (limited to 'mysql-test/t/func_if.test')
-rw-r--r--mysql-test/t/func_if.test2
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/t/func_if.test b/mysql-test/t/func_if.test
index 7842df4fd0a..e44a7f6d6f9 100644
--- a/mysql-test/t/func_if.test
+++ b/mysql-test/t/func_if.test
@@ -14,7 +14,7 @@ select IF(0,"ERROR","this"),IF(1,"is","ERROR"),IF(NULL,"ERROR","a"),IF(1,2,3)|0,
#
# Test of IF and case-sensitiveness
#
-CREATE TABLE t1 (st varchar(255) NOT NULL, u int(11) NOT NULL) TYPE=MyISAM;
+CREATE TABLE t1 (st varchar(255) NOT NULL, u int(11) NOT NULL) ENGINE=MyISAM;
INSERT INTO t1 VALUES ('a',1),('A',1),('aa',1),('AA',1),('a',1),('aaa',0),('BBB',0);
select if(1,st,st) s from t1 order by s;
select if(u=1,st,st) s from t1 order by s;