diff options
| author | unknown <timour@mysql.com> | 2004-12-28 11:57:56 +0200 |
|---|---|---|
| committer | unknown <timour@mysql.com> | 2004-12-28 11:57:56 +0200 |
| commit | 8487aa5abc384de074681f71e67a8b7b0570baf2 (patch) | |
| tree | ef1944be254fd19762ac926af21196cbee1448d9 /mysql-test/r/func_str.result | |
| parent | 47efc5f335d117cd0fbe3d1e633936ae70442933 (diff) | |
| download | mariadb-git-8487aa5abc384de074681f71e67a8b7b0570baf2.tar.gz | |
Fix for BUG#7455.
The fix checks if the trim string argument is NULL. If so, the standard
mandates that the function result must be also NULL.
mysql-test/r/func_str.result:
added test result
mysql-test/t/func_str.test:
Added test for NULL arguments.
sql/item_strfunc.cc:
Test if the trim argument is NULL.
Diffstat (limited to 'mysql-test/r/func_str.result')
| -rw-r--r-- | mysql-test/r/func_str.result | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/r/func_str.result b/mysql-test/r/func_str.result index 1c560dfa8b4..8348ef12b0d 100644 --- a/mysql-test/r/func_str.result +++ b/mysql-test/r/func_str.result @@ -697,3 +697,9 @@ quote(ltrim(concat(' ', 'a'))) select quote(trim(concat(' ', 'a'))); quote(trim(concat(' ', 'a'))) 'a' +select trim(null from 'kate') as "must_be_null"; +must_be_null +NULL +select trim('xyz' from null) as "must_be_null"; +must_be_null +NULL |