diff options
| author | gkodinov/kgeorge@macbook.gmz <> | 2007-01-23 12:34:50 +0200 |
|---|---|---|
| committer | gkodinov/kgeorge@macbook.gmz <> | 2007-01-23 12:34:50 +0200 |
| commit | 17a0207ecee35c82e0a488b900d0e6279a596577 (patch) | |
| tree | ef50ee2680b393a9652b2c98dfe15de22de7f795 /mysql-test/r/func_str.result | |
| parent | c9df1caac83eac107acb0acfecf3b0a950e7ffa5 (diff) | |
| parent | 884713fb08418ae819ba39a5429a3dd18586c423 (diff) | |
| download | mariadb-git-17a0207ecee35c82e0a488b900d0e6279a596577.tar.gz | |
Merge macbook.gmz:/Users/kgeorge/mysql/work/mysql-5.0-opt
into macbook.gmz:/Users/kgeorge/mysql/work/merge-5.1-opt
Diffstat (limited to 'mysql-test/r/func_str.result')
| -rw-r--r-- | mysql-test/r/func_str.result | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/func_str.result b/mysql-test/r/func_str.result index 0496c3eb91f..fea7464f854 100644 --- a/mysql-test/r/func_str.result +++ b/mysql-test/r/func_str.result @@ -1304,6 +1304,18 @@ id select_type table type possible_keys key key_len ref rows filtered Extra Warnings: Note 1003 select `test`.`t1`.`s` AS `s` from `test`.`t1` where (trim(both _latin1'y' from `test`.`t1`.`s`) > _latin1'ab') DROP TABLE t1; +create table t1(f1 varchar(4)); +explain extended select encode(f1,'zxcv') as 'enc' from t1; +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 system NULL NULL NULL NULL 0 const row not found +Warnings: +Note 1003 select encode(`test`.`t1`.`f1`,'zxcv') AS `enc` from `test`.`t1` +explain extended select decode(f1,'zxcv') as 'enc' from t1; +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 system NULL NULL NULL NULL 0 const row not found +Warnings: +Note 1003 select decode(`test`.`t1`.`f1`,'zxcv') AS `enc` from `test`.`t1` +drop table t1; End of 4.1 tests create table t1 (d decimal default null); insert into t1 values (null); |