Is Debugging stored procedures at runtime possible?

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
samcov
Posts: 2
Joined: Mon 24 Feb 2020 18:27

Is Debugging stored procedures at runtime possible?

Post by samcov » Mon 24 Feb 2020 18:33

I can debug stored procedures just fine, however, they have no context in the application I'm testing against.

Is there a way to debug while the program is running, only hitting break points when the code is actually invoked by the program?

alexa
Devart Team
Posts: 2881
Joined: Fri 24 Jun 2011 14:17

Re: Is Debugging stored procedures at runtime possible?

Post by alexa » Tue 25 Feb 2020 15:11

Could you please describe this in more detail?

Please also see the Debugging Stored Routine section in the Help documentation.

samcov
Posts: 2
Joined: Mon 24 Feb 2020 18:27

Re: Is Debugging stored procedures at runtime possible?

Post by samcov » Tue 25 Feb 2020 19:49

Yes, it's very simple and happens when debugging code in most IDE's like Visual Studio.

You actually debug a running app when it runs under normal conditions, and hit break points when the user does something real.

In this case I can debug a stored procedure, but not under any real case. In my app, the stored procedures gather information about the user's login credentials that are dynamically set, so I want to see what happens in the real world, not in a simple test situation so I can see what's really going on.

alexa
Devart Team
Posts: 2881
Joined: Fri 24 Jun 2011 14:17

Re: Is Debugging stored procedures at runtime possible?

Post by alexa » Wed 26 Feb 2020 12:10

Thank you for the reply.

We put this functionality to our roadmap for the next product versions.

Post Reply