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.
1. Connect to MySQL server. 2. Create "sakila" database. 3. Execute following statement: "show create procedure get_customer_balance". Result: Execution finished with errors and "Error code 1305, SQL state 42000: PROCEDURE get_customer_balance does not exist" error message is shown. The same for inventory_held_by_customer and inventory_in_stock sored procedures. For film_in_stock, film_not_in_stock and rewards_report everything is fine.
The first paramenter of those procedures with problems appears to have a blank name
I can reproduce. Also fails with "show create procedure sakila.get_customer_balance" Here are some odd things: - The procedure shows up in the procedure list under the Procedures folder - select * from information_schema.routines shows the procedures This seems like a bug with MySQL. See http://bugs.mysql.com/bug.php?id=5462, it looks like it may be a JDBC issue. I do notice a pattern - the procedures that fail don't use the 'IN' keyword for in parameters. I'll see if I can create a reproduction outside of Sakila and then will submit a MySQL bug. I'll also see if using the 'IN' keyword is a viable workaround
Doh! The problem is that these are *functions* not procedures. Notice they say "CREATE FUNCTION". 'show create function get_customer_balance' works fine. This can be confusing when they are all listed in the Procedures folder. If we were to be accurate we would have a Procedures folder and a Functions folder, but that would not be very generic. Closing, this is not a bug, just a misunderstanding