diff options
| author | unknown <bar@myoffice.izhnet.ru> | 2006-07-07 17:06:30 +0500 |
|---|---|---|
| committer | unknown <bar@myoffice.izhnet.ru> | 2006-07-07 17:06:30 +0500 |
| commit | 613cbb621e0e09094b71dafe5ff613dcb1df4bbf (patch) | |
| tree | e06aaf4879d334f421488c1d815ad9b32b7cbc18 /mysql-test/r/func_str.result | |
| parent | 0b399f1d3f7b25cf16c868650edb99d9eb0a1ac7 (diff) | |
| download | mariadb-git-613cbb621e0e09094b71dafe5ff613dcb1df4bbf.tar.gz | |
func_str.result, func_str.test:
Adding test case.
item_strfunc.cc:
bug#11728 string function LEFT, strange undocumented behaviour
Fixing LEFT and RIGHT return NULL if the second
argument is NULL.
sql/item_strfunc.cc:
bug#11728 string function LEFT, strange undocumented behaviour
Fixing LEFT and RIGHT return NULL if the second
argument is NULL.
mysql-test/t/func_str.test:
Adding test case.
mysql-test/r/func_str.result:
Adding test case.
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 1485809ba70..1042840fe04 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 |