Bug #79565 Function insert work incorrectly with multiple-type utf8 character
Submitted: 9 Dec 2015 7:11 Modified: 9 Dec 2015 8:30
Reporter: Su Dylan Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: DML Severity:S3 (Non-critical)
Version:5.7.8,5.5.48, 5.6.29, 5.7.9 OS:Any
Assigned to: CPU Architecture:Any

[9 Dec 2015 7:11] Su Dylan
Description:
Output:
=======
mysql> select insert('a中c',4,1,'xyz'), insert('abc',4,1,'xyz');
+---------------------------+-------------------------+
| insert('a中c',4,1,'xyz') | insert('abc',4,1,'xyz') |
+---------------------------+-------------------------+
| a中cxyz                  | abc                     |
+---------------------------+-------------------------+
1 row in set (0.00 sec)

mysql> select version();
+-----------+
| version() |
+-----------+
| 5.7.8-rc  |
+-----------+
1 row in set (0.00 sec)

Problem:
=========
'a中c' is expected for insert('a中c',4,1,'xyz').

How to repeat:
select insert('a中c',4,1,'xyz'), insert('abc',4,1,'xyz');

Suggested fix:
'a中c' is returned for insert('a中c',4,1,'xyz').
[9 Dec 2015 8:30] Umesh Shastry
Hello Su Dylan,

Thank you for the report and test case.

Thanks,
Umesh
[9 Dec 2015 8:31] Umesh Shastry
-- 5.5.48, 5.6.29, 5.7.9 - affected

mysql> select insert('a中c',4,1,'xyz'), insert('abc',4,1,'xyz');
+---------------------------+-------------------------+
| insert('a中c',4,1,'xyz')  | insert('abc',4,1,'xyz') |
+---------------------------+-------------------------+
| a中cxyz                   | abc                     |
+---------------------------+-------------------------+
1 row in set (0.00 sec)