mysql: calling stored procedure ends before completing

Question

I am connecting to mysql database from azure data studio, however when running an stored procedure

call sp_xxx

And this sp returns several "select", the procedure ends after the first call

Is this an issue?

Thanks

Answer 1

the ADS mysql driver probably does not support multiple result sets. this requires support in the driver and explicit configuration:

https://dev.mysql.com/doc/refman/9.0/en/stored-routines-syntax.html

you could request the feature:

https://github.com/microsoft/azuredatastudio-mysql/tree/main

Answer 2

You should report this to the ADS team directly. ADS is notoriously buggy. You can report this to them via Github. They require a lot of information including the version of ADS you're running. The easiest way to do this is to use the Help > Report Issue menu item. This pops up a simple UX where you enter the information. Then submit and it sends you to Github with most of the data filled out. You then need to complete the information and create the issue where they can respond directly.

Before you do all this you should search their Github issues list. The results window is really buggy in that sometimes it doesn't show any data, sometimes it freezes when you're running other queries, etc. Every "update" seems to break new things so there are a lot of reported bugs around using it.