Bug #93070 MySQL Shell does not deal with multiple result sets
Submitted: 2 Nov 2018 22:50 Modified: 3 Nov 2018 4:25
Reporter: Sean Davidson Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Shell General / Core Client Severity:S2 (Serious)
Version:8.0.13 OS:Any
Assigned to: CPU Architecture:Any

[2 Nov 2018 22:50] Sean Davidson
Description:
MySQL Shell does not return any other than the first of multiple result sets.

How to repeat:
Server version: 5.7.23 MySQL Community Server (GPL)
No default schema selected; type \use <schema> to set one.
MySQL Shell 8.0.13

Copyright (c) 2016, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type '\help' or '\?' for help; '\quit' to exit.

MySQL▶SQL▶ use test ;
Default schema set to `test`.
Fetching table and column names from `test` for auto-completion... Press ^C to stop.

MySQL▶[test]▶SQL▶ DELIMITER $$
MySQL▶[test]▶SQL▶ CREATE PROCEDURE ret1set ()
               ⋯> BEGIN
               ⋯>   SELECT 'Result Set' AS msg ;
               ⋯> END $$
Query OK, 0 rows affected (0.0010 sec)

MySQL▶[test]▶SQL▶ CREATE PROCEDURE ret2sets ()
               ⋯> BEGIN
               ⋯>   SELECT 'Result Set 1' AS msg ;
               ⋯>   SELECT 'Result Set 2' AS msg ;
               ⋯> END $$
Query OK, 0 rows affected (0.0006 sec)

MySQL▶[test]▶SQL▶ DELIMITER ;
MySQL▶[test]▶SQL▶ CALL ret1set();
+------------+
| msg        |
+------------+
| Result Set |
+------------+
1 row in set (0.0008 sec)
Empty set (0.0008 sec)

MySQL▶[test]▶SQL▶ CALL ret2sets();
+--------------+
| msg          |
+--------------+
| Result Set 1 |
+--------------+
1 row in set (0.0007 sec)
Empty set (0.0007 sec)

MySQL▶[test]▶SQL▶
[3 Nov 2018 4:25] Umesh Shastry
Hello Sean,

Thank you for the report and test case.
Verified as described.

regards,
Umesh