diff options
| author | timour/tkatchaounov@lamia.home <> | 2006-07-21 13:04:40 +0300 |
|---|---|---|
| committer | timour/tkatchaounov@lamia.home <> | 2006-07-21 13:04:40 +0300 |
| commit | bcf822841b8a938ef90600e8eb26093724af2617 (patch) | |
| tree | b9393caee4a9e94830f70cbcd75f0e00253508c0 /mysql-test/r/func_str.result | |
| parent | 8b7fc77a0f62f2aa5429969fa5f6b012c87849d3 (diff) | |
| parent | 39ada211389098d877f90c051082745aacb37d85 (diff) | |
| download | mariadb-git-bcf822841b8a938ef90600e8eb26093724af2617.tar.gz | |
Merge tkatchaounov@bk-internal.mysql.com:/home/bk/mysql-5.0-opt
into lamia.home:/home/tkatchaounov/autopush/5.0-bug-21007
Diffstat (limited to 'mysql-test/r/func_str.result')
| -rw-r--r-- | mysql-test/r/func_str.result | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/mysql-test/r/func_str.result b/mysql-test/r/func_str.result index a857f5055a2..14da630f61e 100644 --- a/mysql-test/r/func_str.result +++ b/mysql-test/r/func_str.result @@ -33,6 +33,9 @@ instr('hello','HE') instr('hello',binary 'HE') instr(binary 'hello','HE') select position(binary 'll' in 'hello'),position('a' in binary 'hello'); position(binary 'll' in 'hello') position('a' in binary 'hello') 3 0 +select left('hello',null), right('hello',null); +left('hello',null) right('hello',null) +NULL NULL select left('hello',2),right('hello',2),substring('hello',2,2),mid('hello',1,5) ; left('hello',2) right('hello',2) substring('hello',2,2) mid('hello',1,5) he lo el hello |