Bug #8004 Return incorrect data

• Submitted: 19 Jan 2005 10:06
• Modified: 19 Jan 2005 13:27
• Reporter: Camus Chan
• Status: Duplicate
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 4.1.8 or 4.1.9
• OS: NT / Linux
• 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