This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 268470

Summary: Debug stored procedure
Product: db Reporter: Xenos
Component: MySQLAssignee: Libor Fischmeistr <lfischmeistr>
Status: NEW ---    
Severity: normal    
Priority: P3    
Version: Dev   
Hardware: PC   
OS: Windows 7   
Issue Type: ENHANCEMENT Exception Reporter:

Description Xenos 2016-10-11 14:23:09 UTC 
As wrote in the 2008 DB Comments Survey ( http://wiki.netbeans.org/NBDatabaseSurveyComments ), allow debugging any stored procedure (MySQL or, more widely, any SQL) would be a wonderful feature.

Apparently, Visual Studio has such feature ( https://dev.mysql.com/doc/visual-studio/en/visual-studio-debugger.html ).

The debug might only show the executed queries (that would be a good start) and stop on breakpoints.

If possible, as shown in Visual Studio, it would be good to have the variables in scope along with their values, and a list of the returned result set.

We probably won't be able to build a more deep debugging, like showing variable values row after row on queries like `SELECT @rank := @rank+1 FROM table`, but the two first points would be a big plus for NetBeans.