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/func_if.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/func_if.result')
| -rw-r--r-- | mysql-test/r/func_if.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/func_if.result b/mysql-test/r/func_if.result index 64070179395..bea16c07f86 100644 --- a/mysql-test/r/func_if.result +++ b/mysql-test/r/func_if.result @@ -2,7 +2,7 @@ drop table if exists t1; select IF(0,"ERROR","this"),IF(1,"is","ERROR"),IF(NULL,"ERROR","a"),IF(1,2,3)|0,IF(1,2.0,3.0)+0 ; IF(0,"ERROR","this") IF(1,"is","ERROR") IF(NULL,"ERROR","a") IF(1,2,3)|0 IF(1,2.0,3.0)+0 this is a 2 2.0 -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; s |