[7.0.132 beta] Database Explorer - Edit glitch

[7.0.132 beta] Database Explorer - Edit glitch

Tried the following in Toad for MySQL 6.3.0.642 (though I'm not sure it's related). Selecting Edit function on a function in Database Explorer retrieved the drop-create code for the function but it seems somehow incomplete when it comes to being able to run the script.

	Code:
	DROP FUNCTION [mydb].[myfunction] $$$ CREATE DEFINER='whoever'@'wherever' FUNCTION `mydb`.`myfunction` ( xk DECIMAL(16,4), xk_1 DECIMAL(16,4), yk DECIMAL(16,4), yk_1 DECIMAL(16,4), xcsill DECIMAL(16,4) ) RETURNS decimal(16,4) CONTAINS SQL SQL SECURITY DEFINER BEGIN DECLARE ycsill DECIMAL(16,4); SET ycsill = yk_1 + (xcsill - xk_1) / (xk - xk_1) * (yk - yk_1) ; RETURN ycsill; END

It looks like the Edit routine did not do a decent job here, because while the DDL was fetched properly, both setting and resetting the DELIMITER command before and after the relevant parts and the delimiter itself at the end of the code are missing. It also produces the same incomplete structure for procedures as well, and for views too, which is not necessary anyway, as they can be dropped and created using the default ';' as delimiter.

[7.0.132 beta] Database Explorer - Edit glitch 2

Also, the new tab spawned by selecting Edit function/procedure/view does not retain the filter set in its parent Database Explorer which it should, imho. If that was intentional then consider this as a feature request (or at least make it optional).

Thank you. I have logged both issues. In the first issue, it looks like it's missing $$$ after the CREATE statement.

	SysOp wrote:
	In the first issue, it looks like it's missing $$$ after the CREATE statement.

Definitely. And "DELIMITER $$$" at the beginning of the script and "DELIMITER ;" at its end as well. Otherwise it seems to be complaining about not understanding what "$$$" is.