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 - Debug stored procedure
Summary: Debug stored procedure
Status: NEW
Alias: None
Product: db
Classification: Unclassified
Component: MySQL (show other bugs)
Version: Dev
Hardware: PC Windows 7
: P3 normal (vote)
Assignee: Libor Fischmeistr
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-10-11 14:23 UTC by Xenos
Modified: 2016-10-11 14:23 UTC (History)
0 users

See Also:
Issue Type: ENHANCEMENT
Exception Reporter:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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.