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▶
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▶