Error at SQL with a Procedure
Answered
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?
Please sign in to leave a comment.
@Akalyptos,
There is an issue https://youtrack.jetbrains.com/issue/DBE-8481 you can follow.