diff options
| author | unknown <bar@mysql.com> | 2004-08-26 16:31:37 +0500 |
|---|---|---|
| committer | unknown <bar@mysql.com> | 2004-08-26 16:31:37 +0500 |
| commit | 42771f9877c17050a230cdaf8a26afc5d077a712 (patch) | |
| tree | 87bdea54aaf019dbdbc0f7e73a1ff7be7842b4bb /mysql-test/r/func_if.result | |
| parent | c1825f208cafe972f69517c2b164de5ccfb2ab92 (diff) | |
| download | mariadb-git-42771f9877c17050a230cdaf8a26afc5d077a712.tar.gz | |
"SELECT BINARY x" now means "SELECT CAST(x AS BINARY)".
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 4c8a0561b0a..dd916d06372 100644 --- a/mysql-test/r/func_if.result +++ b/mysql-test/r/func_if.result @@ -43,7 +43,7 @@ explain extended select if(u=1,st,binary st) s from t1 where st like "%a%" order id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ALL NULL NULL NULL NULL 7 Using where; Using filesort Warnings: -Note 1003 select if((test.t1.u = 1),test.t1.st,(test.t1.st collate _latin1'BINARY')) AS `s` from test.t1 where (test.t1.st like _latin1'%a%') order by if((test.t1.u = 1),test.t1.st,(test.t1.st collate _latin1'BINARY')) +Note 1003 select if((test.t1.u = 1),test.t1.st,cast(test.t1.st as char charset binary)) AS `s` from test.t1 where (test.t1.st like _latin1'%a%') order by if((test.t1.u = 1),test.t1.st,cast(test.t1.st as char charset binary)) select nullif(u=0, 'test') from t1; nullif(u=0, 'test') NULL |