Bug #70603 large result set don't show data
Submitted: 11 Oct 2013 14:11 Modified: 11 Oct 2013 15:50
Reporter: Remigio Zeballos Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Utilities Severity:S2 (Serious)
Version:6.0 Comunity OS:Windows (7, 64bits)
Assigned to: CPU Architecture:Any
Tags: large result set don't show data

[11 Oct 2013 14:11] Remigio Zeballos 
Description:
Hi :
Triying to execute this query in sql editor
SELECT CONCAT("INSERT INTO Atencion_cliente.Fidelizacion_Recordatorio (nroPlaca,codcliente,conductor,contacto,fech_ult_visit,
kmProm,fech_Prog_Reco,kps,modelo,descripcion_modelo,marca,vehClase,costoProxServ,Desc_Prox_Serv,ultLocalVisit,ot_ult_visit,call_center ) 
VALUES ('",nroPlaca,"','",codCliente,"','",REPLACE(conductor,' ','_'),"','",REPLACE(contacto,' ','_'),"','",
CONCAT(auv,'/',muv,'/',duv),"','", kmProm,"','",aps,'/',mps,'/',dps ,"','",kps,"','",modelo,"','",descripcion,
"','",marca,"','",VehClase,"','",Costo_Prox_Serv,"','", Prox_Serv,"','",
CASE WHEN local_ultima='1' THEN '0' ELSE local_ultima END ,"','",ot_ultima,"','JTODCO');")
FROM `datawarehouse`.`tblrecordatnissan` WHERE marca IN ('CHEVROLET','ISUZU') AND VehClase  IN ('CAMION','OMNIBUS');

The result windows said that return 688 rows, but the result query show NULL in each row.
I try to modify the Max field length to a big value but still have the same result.

How to repeat:
Build a query with a big concatenation.

Suggested fix:
Don't limit the result length
[11 Oct 2013 15:20] MySQL Verification Team 
Please run the same query on mysql.exe and check if you get different result. Thanks.
[11 Oct 2013 15:23] Remigio Zeballos 
Found the problem function Concat with a field NULL result in NULL concatenation.
[11 Oct 2013 15:50] MySQL Verification Team 
Chech http://dev.mysql.com/doc/refman/5.5/en/string-functions.html#function_concat-ws is suitable for you. Thanks.