dolthub / dolthub/dolt

procedures return nil results is error in mysql

Open
#7,475 0 comments 0 reactions 1 assignee Claimed by @zachmu View on GitHub
bug correctness sql
Dominant language
Go
Stars
24.4k
Forks
873
Avg merge
1d 9h
Merged PRs (30d)
121

Description

We return nil results for empty procedures, mysql appears to error:
```sql
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.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.