dolt icon indicating copy to clipboard operation
dolt copied to clipboard

procedures return nil results is error in mysql

Open max-hoffman opened this issue 1 year ago • 0 comments

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.

max-hoffman avatar Feb 08 '24 20:02 max-hoffman