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?

1 comment
Comment actions Permalink

@Akalyptos,

There is an issue https://youtrack.jetbrains.com/issue/DBE-8481 you can follow.

1

Please sign in to leave a comment.