Error at SQL with a Procedure

已回答

Since i'm learning atm how to use intellij ultimate i have a little problem and i don't know how to fix it and if i can at all. i created a procedure

DELIMITER //
CREATE PROCEDURE TEST()
BEGIN
SELECT *FROM department;
SELECT *FROM employee;
end //

CALL TEST;


and when i call it pop up this message:

[S1000] Attempt to close streaming result set com.mysql.cj.protocol.a.result.ResultsetRowsStreaming@11e4299 
that was not registered. Only one streaming result set may be open and in use per-connection.
Ensure that you have called .close() on any active result sets before attempting more queries.

i understood that only 1 result at a time can be opened because i can edit them also. Is there any way to change this?

0

请先登录再写评论。