Store procedure Error 1064

[Fernando Genao]

This stored procedure doesn't work on the production server but on the developer.

Developer ver: mysql Ver 14.14 Distrib 5.7.23, for Linux (x86_64) using EditLine wrapper

Production Ver: mysql Ver 14.14 Distrib 5.7.23, for Linux (x86_64) using EditLine wrapper


CREATE DEFINER=`root`@`localhost` PROCEDURE `AgentTracking`()
BEGIN
SET @SQL = NULL;
SELECT
GROUP_CONCAT(DISTINCT
CONCAT(
'sum(case when programName = ''',
dt,
''' then 1 else 0 end) AS`',
dt, '`'
)
) INTO @SQL
FROM
(SELECT agentName, programName AS dt
FROM QA.vwTrack
GROUP BY agentName, programName
ORDER BY agentName) d;

SET @SQL= CONCAT('SELECT r.agentName, ', @SQL, '
FROM QA.vwTrack r

GROUP BY r.agentName');

PREPARE stmt FROM @SQL;
EXECUTE stmt;
END