Bug #964 4.1-alpha GROUP_CONCAT bug
Submitted: 31 Jul 2003 7:10 Modified: 31 Jul 2003 7:57
Reporter: Jaime Almeida Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:0.9.2-beta OS:Windows (Windows)
Assigned to: CPU Architecture:Any

[31 Jul 2003 7:10] Jaime Almeida 
Description:
When using MySQLCC for windows, and using a 4.1-alpha server for linux; when I use a GROUP_CONCAT together with a string comparisson function, such as "when address.name LIKE "%Jaime%" " I get gibberish in the CONCAT column.  This fenomenon DOES NOT OCCUR in the command line.
                                                                   

How to repeat:
Here is a sample query: 

SELECT 
MATERIAS.NOMBRE, 
SALONES.GRUPO, 
SALONES.SALON, 
GROUP_CONCAT(SALONES.DIA_SEMANA) AS DIAS,
CONCAT(SALONES.HORA_ENT,"-",SALONES.HORA_SAL) AS HORAS
FROM SALONES JOIN MATERIAS,DATOS_MAESTROS,HORARIOS,DATOS_ALUMNOS
ON 
SALONES.ID_SALON=HORARIOS.ID_SALON AND
SALONES.ID_MATERIA=MATERIAS.ID_MATERIA AND
SALONES.ID_MAESTRO=DATOS_MAESTROS.MID
WHERE DATOS_MAESTROS.APELLIDO_PAT="Almeida"
GROUP BY SALONES.HORA_ENT

The "dias" column returns: 

V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X#                                                                       

V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X#                                                                       

V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X#                                                                       

V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X#                                                                       

V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X# V(s���a�`ZykB3C[�V�waU�ɠ#UM�H�i8�H|��"Gn�:ꄉ^*=��X#                                                                       

Suggested fix:
It must be some string manipulation thig in MySQLCC OR MAYBE the GROUP_CONCAT function.
[31 Jul 2003 7:57] MySQL Verification Team 
Please see Bug #965 also from: jgalmeida@unin.com.mx
PD I reported this as a MySQLCC bug.  Its a server BUG!