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 155362 - Show triggers and functions as well as procedures under a MySQL Connection
Summary: Show triggers and functions as well as procedures under a MySQL Connection
Status: NEW
Alias: None
Product: db
Classification: Unclassified
Component: MySQL (show other bugs)
Version: 6.x
Hardware: All All
: P3 blocker with 2 votes (vote)
Assignee: Libor Fischmeistr
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-12-12 14:58 UTC by Roman Mostyka
Modified: 2016-07-31 05:07 UTC (History)
1 user (show)

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 Roman Mostyka 2008-12-12 14:58:18 UTC 
Show triggers and functions as well as procedures under a MySQL Connection. See Aqua Studio for an example.
Comment 1 Jiri Rechtacek 2009-10-16 14:11:07 UTC 
Reassigned to new owner.
Comment 2 sbrbot 2016-07-27 00:16:41 UTC 
I do have the latest version of NetBeans v8.1 and I still cannot see stored proceures in it. On some tutorial pages online one can see that stored procedures are shown along with tables and views (I can see them in NetBeans too) but in my NetBeans procedures are not shown. I clearly see them in MySQL Workbench.
Comment 3 Milutin Kristofic 2016-07-27 13:30:33 UTC 
This has nothing common with Editor navigation, sending back to db-mysql
Comment 4 matthias42 2016-07-27 16:32:36 UTC 
Restored original parameters.
Comment 5 sbrbot 2016-07-31 05:07:37 UTC 
I think that I found some details that explain my problem. When I started command SHOW PROCEDURE CODE within NetBeans IDE I got the following error message:

"Error code 1289, SQL state HY000: The 'SHOW PROCEDURE|FUNCTION CODE' feature is disabled; you need MySQL built with '--with-debug' to have it working"

I don't know why NetBeans requires this for managing routines (functions and procedures). Workbench works with functions and procedures on the same database without this just fine.