From 6ea2c3cd57e5be58bb84b94951b34dc055b178a6 Mon Sep 17 00:00:00 2001
From: unknown <ramil@mysql.com>
Date: Thu, 2 Mar 2006 15:05:55 +0400
Subject: 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
---
 mysql-test/t/sp.test | 23 +++++++++++++++++++++++
 1 file changed, 23 insertions(+)

(limited to 'mysql-test/t/sp.test')

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
@@ -5615,6 +5615,29 @@ drop procedure bug15011|
 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
 #
-- 
cgit v1.2.1