diff options
| author | unknown <ramil@mysql.com> | 2006-03-02 15:05:55 +0400 |
|---|---|---|
| committer | unknown <ramil@mysql.com> | 2006-03-02 15:05:55 +0400 |
| commit | 6ea2c3cd57e5be58bb84b94951b34dc055b178a6 (patch) | |
| tree | 330a90ba0dcc96bb8fb821076e6817ff34d916df /mysql-test/t/sp.test | |
| parent | 5af68d301d205fad8c2f87a14db75b7a1dd10365 (diff) | |
| download | mariadb-git-6ea2c3cd57e5be58bb84b94951b34dc055b178a6.tar.gz | |
Fix for bug #17615: invalid handling of function results in UPDATE...SET statement.
sql/item_func.cc:
Fix for bug #17615: invalid handling of function results in UPDATE...SET statement.
- set proper collation
Diffstat (limited to 'mysql-test/t/sp.test')
| -rw-r--r-- | mysql-test/t/sp.test | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/mysql-test/t/sp.test b/mysql-test/t/sp.test index 243c1b413b7..fd79286dd0f 100644 --- a/mysql-test/t/sp.test +++ b/mysql-test/t/sp.test @@ -5616,6 +5616,29 @@ drop table t3| # +# BUG#17615: problem with character set +# +--disable_warnings +drop function if exists bug17615| +--enable_warnings + +create table t3 (a varchar(256) unicode)| + +create function bug17615() returns varchar(256) unicode +begin + declare tmp_res varchar(256) unicode; + set tmp_res= 'foo string'; + return tmp_res; +end| + +insert into t3 values(bug17615())| +select * from t3| + +drop function bug17615| +drop table t3| + + +# # BUG#NNNN: New bug synopsis # #--disable_warnings |