diff options
| author | unknown <bell@sanja.is.com.ua> | 2004-08-31 10:06:38 +0300 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2004-08-31 10:06:38 +0300 |
| commit | 6e314e047d0acd336954df032cb519101889bd0c (patch) | |
| tree | 5f2f79152aa536016bbf28ae6e6b0e70d5087d25 /mysql-test/r/func_if.result | |
| parent | fa8a74b3ba0fb8b1fed200fba6bbbd4755e1df13 (diff) | |
| download | mariadb-git-6e314e047d0acd336954df032cb519101889bd0c.tar.gz | |
fixed open_and_lock_tables result processing (all open_and_lock_tables revision)
fixed printing of COLLATE operation
(BUG#5155)
mysql-test/r/case.result:
fixed printing of COLLATE operation
mysql-test/r/func_if.result:
fixed printing of COLLATE operation
mysql-test/r/func_in.result:
fixed printing of COLLATE operation
mysql-test/r/func_str.result:
fixed printing of COLLATE operation
mysql-test/r/func_test.result:
fixed printing of COLLATE operation
mysql-test/r/view.result:
VIEW with collation
mysql-test/t/view.test:
VIEW with collation
sql/item_strfunc.cc:
fixed printing of COLLATE operation
sql/item_strfunc.h:
fixed printing of COLLATE operation
sql/sp_head.cc:
fixed open_and_lock_tables result processing
sql/sql_base.cc:
fixed open_and_lock_tables result processing
sql/sql_delete.cc:
fixed open_and_lock_tables result processing
sql/sql_help.cc:
fixed open_and_lock_tables result processing
sql/sql_load.cc:
fixed open_and_lock_tables result processing
sql/sql_parse.cc:
fixed open_and_lock_tables result processing
sql/sql_prepare.cc:
fixed open_and_lock_tables result processing
sql/sql_show.cc:
fixed open_and_lock_tables result processing
sql/sql_update.cc:
fixed open_and_lock_tables result processing
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 36bd9a36d1c..f0445199744 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`,(`test`.`t1`.`st` collate 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 BINARY)) select nullif(u=0, 'test') from t1; nullif(u=0, 'test') NULL |