Some more functions work according to coercibility now:

repeat, reverse, quote, soundex, substring
Test func_str has been extended to check them

1 files changed, 5 insertions, 1 deletions

diff --git a/sql/item_strfunc.h b/sql/item_strfunc.h
index a70c9b39255..31d6c1fe89d 100644
--- a/sql/item_strfunc.h
+++ b/sql/item_strfunc.h
@@ -571,7 +571,11 @@ public:
   Item_func_quote(Item *a) :Item_str_func(a) {}
   const char *func_name() const { return "quote"; }
   String *val_str(String *);
-  void fix_length_and_dec() { max_length= args[0]->max_length * 2 + 2; }
+  void fix_length_and_dec() 
+  { 
+    set_charset(args[0]->charset(), args[0]->coercibility);
+    max_length= args[0]->max_length * 2 + 2; 
+  }
 };
 
 class Item_func_conv_charset :public Item_str_func