diff options
Diffstat (limited to 'mysql-test/t/func_if.test')
| -rw-r--r-- | mysql-test/t/func_if.test | 2 |
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; |