MySQL Bugs: #62624: Can't create routines.

Bug #62624	Can't create routines.
Submitted:	4 Oct 2011 20:51	Modified:	22 Nov 2011 6:37
Reporter:	Dan Mercier	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	5.2.35	OS:	MacOS
Assigned to:		CPU Architecture:	Any
Tags:	routines procedure

Description:
If i use the link to create a routine it says added successfully and the log shows no errors but when I check the output window it shows error  for apply object alter script
Error: call to empty boost::function

Same code will run in navicat

How to repeat:
Click on add routine.

enter code to 

select * from tableX;

say apply. 

See error in output error.

What exact server version, 5.x.y, are you working with? 

Do you have Show Live Schema Overview option set in Preferences... > SQL Editor? If you don't, try to set it and check if it helps to solve the problem.

screen after applying script shown in comment.

Attachment: Apply SQL Script to Database.jpg (image/jpeg, text), 49.42 KiB.

Also here is the version information of the server.

Variable_name 	Value
protocol_version 	10
version 	5.1.41-3ubuntu12.10-log
version_comment 	(Ubuntu)
version_compile_machine 	x86_64
version_compile_os 	debian-linux-gnu

Here's the sql script that was applied to the db...

USE `solaro_production`;
DROP procedure IF EXISTS `new_routine`;

DELIMITER $$
USE `solaro_production`$$
CREATE PROCEDURE `solaro_production`.`new_routine` ()
BEGIN
select *  from genres;
END$$

DELIMITER ;

I also have this identical bug, WB 5.2.35, OSX 10.7, MySQL server 5.5.9 (MAMP) as well as 5.1.54-1ubuntu4, and 5.1.41-3ubuntu12.10.

It also prevents me from adding foreign keys to tables. Executing the code generated straight into the query editor works fine, however.

Verified just as described after unsetting Show Live Schema Overview option in Preferences... > SQL Editor and restarting Workbench.

I should add that I have Show Live Schema Overview ticked and always have done. Turning it off, restarting WB and then doing the inverse doesn't fix it.

I am having the same issue on Mac OS X Lion with workbench 5.2.35 revision 7915. Setting Show Live Schema Overview to off did not help.

Action: Apply object alter script
Response: Error: call to empty boost::function

when trying to alter a stored procedure.

Can we raise the priority as I cannot find a workaround.

Exactly the same as James Zucker
Mac OS X Lion with workbench 5.2.35 revision 7915.

More on this:
You can Drop the routine (very bad), but not modify, nor create.
When you are trying to modify, once you press apply button, the modification disappear from the window where you are working on.
The message appears to be correct, it says the process was done without problems, but... it is untrue.
Even more... sometimes one of my oldest routines disappear an d the new one "appears" but it is ephemeral, once I made the Call `DB.Routine` the old one appears, the new one vanishes, nothing works and error message appears (something like the requested routine does not exists)
If I try to click apply for a second time after it says "SQL script was successfully applied to the database", the workbench goes to crash.

The same problem in all my schemas, so it is some general in the configuration.

Could it be possible to make a downgrade?

Thanks, and please scale up this problem

Sorry... just a bit more:

I made a downgrade to 5.2.34, Rev 7780, on my OSX Lion and, guess what?

Now it WORKS!!!!

Carlos Soto,

How do I downgrade my MySQL workbench version to fix this like you did?

Thanks!

where can I download 5.2.34?

Hi James and Hacinto,

I usually keep a copy of the previous upgrade of each program I install.
The process did not cost any effort. Just shut down workbench and mamp (or mysql) and install it again.
It asked for keep or overwrite. I took the last one option.

If u need the file tell me where can I download it for you. 24MB ( it is not too big)

Carlos,

Could you send me the file via YouSendIt?

Ok, no problem:
Would you mind to let me know how can I see your e-mail?

Fixed as of 5.2.36:
+        The <guimenu>Create Routine...</guimenu> feature would report
+        that it created a routine, but it did not, and the error was
+        revealed in the output window.