关于no data - zero rows fetched,selected,or processed

。。。mysql给我的郁闷，也不是一次二次了，但我还是不习惯，继续吐血。
出现这个问题是在写一个存储过程中，用到游标时出现的，在网上查，说是mysql的一个bug( －　－！这


都可以 )
找了一个多小时，最后终于找到解决的方案，就是在定义游标的下面，加上这句
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET P_ID = NULL;


存储过程如下
CREATE DEFINER = 'root'@'%'
PROCEDURE etm_one.P_ManagerWorkInfo(IN P_StartDate VARCHAR(255),
IN P_EndDate VARCHAR(255)
)
BEGIN

DECLARE P_ID INT;
DECLARE P_ParamName VARCHAR(50);
DECLARE P_strSql1, P_strSql2, P_strSql, P_strSql3 TEXT;

DECLARE curs CURSOR FOR
SELECT id
, paramname
FROM
K_SystemParam
WHERE
parentID = 26;


-- 解决mysql Bug:no data - zero rows fetched,selected,or processed
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET P_ID = NULL;


IF (ifnull(P_StartDate, '') = '') THEN
SET P_StartDate = '1900-01-01';
END IF;
IF (ifnull(P_EndDate, '') = '') THEN
SET P_EndDate = '2100-01-01';
ELSE
SET P_EndDate = date_format(date_add(P_EndDate, INTERVAL 1 DAY), '%Y-%m-d');
END IF;
SET P_strSql = '';
SET P_strSql1 = 'select CreatorGuid,createdate,';
SET P_strSql2 = 'select CreatorGuid,createdate,';
SET P_strSql3 = '';
OPEN curs;
FETCH curs INTO P_ID, P_ParamName;
WHILE (P_ID IS NOT NULL)
DO
SET P_strSql1 = concat(P_strSql1, 'ifnull(SUM(', P_ParamName, '),0)', P_ParamName, ',');
SET P_strSql2 = concat(P_strSql2, 'case when ID=', concat(P_ID, ''), ' then num end ',


P_ParamName, ',');
SET P_strSql3 = concat(P_strSql3, ',a.', P_ParamName);
FETCH curs INTO P_ID, P_ParamName;

END WHILE;
CLOSE curs;


/*SELECT P_strSql1;
SELECT P_strSql2;
--SELECT LEFT(P_strSql3,LEN(P_strSql3)-1)*/
SET P_strSql = concat(P_strSql1, '1 aa from (', P_strSql2, '1 aa from
(
select mi.CreatorGuid,date_format(mi.CreateTime,"%Y-%m-%d")


createdate,ks.ID,ks.ParamName,COUNT(*) num from MemberInteraction mi
left join K_SystemParam ks
on ks.id=mi.InteractionType
group by mi.CreatorGuid,ks.ParamName,ks.ID,date_format(mi.CreateTime,"%Y-%m-%d")
) a
)aa
group by CreatorGuid,createdate');


/*print P_strSql*/
SET P_strSql = concat('select km.RealName 顾问名称,d.DepartmentName 所属部


门,p.PositionName 职位,a.CreateDate 跟踪时间', P_strSql3, ' from (', P_strSql,
')a
left join K_Manager km
on a.CreatorGuid=km.ManagerGUID
left join Department d
on km.DepartmentGuid=d.DepartmentGuid
left join Position p
on km.PositionGuid=p.PositionGuid
',
' where a.createdate>="', P_StartDate, '" and a.createdate <"', P_EndDate, '"
order by km.RealName,a.createdate');


SET @P_strSql = P_strSql;
PREPARE result FROM @P_strSql;
EXECUTE result;
-- SELECT P_strSql;
END