DELIMITER $$

CREATE
    PROCEDURE `testSpWithCursor`()
	BEGIN
		BEGIN
			DECLARE `cur` CURSOR FOR SELECT 1;
			OPEN `cur`;
			CLOSE `cur`;
			SELECT 1;
		END;
	END$$

CREATE
    PROCEDURE `testSpWithoutCursor`()
	BEGIN
		BEGIN
			SELECT 1;
		END;
	END$$

DELIMITER ;