procedures return nil results is error in mysql
Open
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.