Error 1329: No data - zero rows fetched, selected, or processed - Even
when all is done right
In the following, i get "Error 1329: No data - zero rows fetched,
selected, or processed", even when all is done correctly. My other
functions work, and this same one used to work well a few days ago.
BEGIN
DECLARE Id INT(10) DEFAULT '0';
DECLARE Elm INT(10) DEFAULT '0';
DECLARE ElmParent INT(10) DEFAULT '0';
DECLARE Type TINYINT(1) DEFAULT '0';
DECLARE Processed TINYINT(1) DEFAULT '0';
DECLARE Country VARCHAR(2) DEFAULT "";
DECLARE updateDone INT DEFAULT 0;
DECLARE Increment TINYINT(1) DEFAULT '0';
-- declare cursor
DEClARE updater CURSOR FOR
SELECT id, klm, parent, type, processed, countryCode FROM votes
where voteProcessed=0;
-- declare NOT FOUND handler
DECLARE CONTINUE HANDLER FOR NOT FOUND SET updateDone = 1;
OPEN updater;
doUpdate: LOOP
FETCH updater INTO Id, Elm, ElmParent, Type, Processed, Country;
IF updateDone =1 THEN
LEAVE doUpdate;
END IF;
IF Type = 0 THEN
SET Increment = 1;
ELSEIF Type = 1 THEN
SET Increment = -1;
END IF;
-- update likes
update likes set votes=votes+Increment where id=Elm and parent =
ElmParent and country=Country;
update votes set voteProcessed = 1 where id=Id;
END LOOP doUpdate;
CLOSE updater;
END
Am I missing something here? I'm using MySQL version 5.5.25
No comments:
Post a Comment