Bug #8004 Return incorrect data
Submitted: 19 Jan 2005 10:06 Modified: 19 Jan 2005 13:27
Reporter: Camus Chan Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1.8 or 4.1.9 OS:NT / Linux
Assigned to: CPU Architecture:Any

[19 Jan 2005 10:06] Camus Chan
Description:
I uses concat function which returns incorrect data if the table's character set is uf8

How to repeat:
1. Create a table with character set utf8:
create table t (ename varchar(10)) default charset=utf8

2. Insert data into the table:
insert into t values ('1') ;
insert into t values ('2') ;
insert into t values ('3') ;

3. Submit the following query:
select concat('*', ename) from t ;

This SQL should return '*1', '*2', '*3'. However, it returns '*1', '*12', '*123'

Suggested fix:
No idea.
[19 Jan 2005 13:27] MySQL Verification Team
Duplicate for #7874