mysql: calling stored procedure ends before completing

Jon Z 100 Reputation points
2024-10-17T15:17:49.5233333+00:00

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

Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
118 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Michael Taylor 54,811 Reputation points
    2024-10-17T15:43:25.2133333+00:00

    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.

    0 comments No comments

  2. Bruce (SqlWork.com) 66,706 Reputation points
    2024-10-18T17:49:45.01+00:00

    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


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.