MySQL stored procedures returning multiple result sets only display the first result set

[arnabmunshi-shbl]

Describe the bug
When executing a stored procedure that returns multiple result sets, Antares SQL only displays the first result set. The remaining result sets are not shown.

The same stored procedure returns all result sets correctly when executed in MySQL Workbench.

To Reproduce

1. Connect to a MySQL database using Antares SQL.
2. Execute a stored procedure that returns multiple result sets (multiple SELECT statements).
3. Observe that only the first result set is displayed.
4. Execute the same stored procedure in MySQL Workbench.
5. Observe that all result sets are returned correctly.

Expected behavior
Antares SQL should display all result sets returned by the stored procedure, similar to MySQL Workbench and other MySQL clients.

Screenshots
Providing screenshots for comparing the output from Antares SQL and MySQL Workbench.
MySQL Workbench
Antares SQL

Application (please complete the following information):

• App client: MySQL
• App version: 0.7.35
• Installation source: https://apps.microsoft.com/detail/9NHTB9SQ51R1?hl=en-us&gl=IN&ocid=pdpshare

Environment (please complete the following information):

• OS name: Windows 11 Pro
• OS version: 25H2
• DB name: MySQL
• DB version: 8.0.46-0ubuntu0.24.04.3

Additional context
The stored procedure intentionally returns multiple result sets using multiple SELECT statements.

Example:

CREATE PROCEDURE sp_test()
BEGIN
    SELECT 'First result' AS message;
    SELECT 'Second result' AS message;
    SELECT 'Third result' AS message;
END;

Expected output:

Result Set 1: First result
Result Set 2: Second result
Result Set 3: Third result

Actual behavior in Antares SQL:

• Only Result Set 1 is displayed.

Actual behavior in MySQL Workbench:

• All three result sets are displayed correctly.

I'm not sure whether this is a missing feature or a bug, but it prevents working with stored procedures that intentionally return multiple result sets.