DELIMITER ||

CREATE TABLE `test`.`tab1` (c INT);

CREATE PROCEDURE `test`.demo()

BEGIN

	DECLARE `eof` BOOL;

	DECLARE `v` INT;	

	DECLARE `crs` CURSOR FOR

		SELECT `c`

			FROM `test`.`tab1`;

	-- this should handle error...

	DECLARE CONTINUE HANDLER

		FOR NOT FOUND, 1329

		SET eof = TRUE;

	OPEN `crs`;

	`lp`: LOOP

		FETCH `crs` INTO `v`;

		IF `eof` IS TRUE THEN

			LEAVE `lp`;

		END IF;

	END LOOP;

	CLOSE `crs`;

END;

||

DELIMITER ;

MariaDB [(none)]> CALL test.demo();

Query OK, 0 rows affected, 1 warning (0.00 sec)

MariaDB [(none)]> SHOW WARNINGS;

+-------+------+-----------------------------------------------------+

| Level | Code | Message                                             |

+-------+------+-----------------------------------------------------+

| Error | 1329 | No data - zero rows fetched, selected, or processed |

+-------+------+-----------------------------------------------------+

1 row in set (0.00 sec)