dolt
dolt copied to clipboard
procedures return nil results is error in mysql
We return nil results for empty procedures, mysql appears to error:
DELIMITER //
CREATE PROCEDURE eof()
BEGIN
DECLARE a, b INT DEFAULT 1;
DECLARE cur1 CURSOR FOR SELECT * FROM t1;
OPEN cur1;
BEGIN
DECLARE EXIT HANDLER FOR SQLEXCEPTION SET a = 7;
tloop: LOOP
FETCH cur1 INTO b;
IF a > 1000 THEN
LEAVE tloop;
END IF;
END LOOP;
END;
CLOSE cur1;
SELECT a;
END;//
call eof()//
ERROR 1329 (02000): No data - zero rows fetched, selected, or processed
No results are returned here becaues SQLEXCEPTION doesn't catch fetch io.EOF.