As of dbForge for MySQL version 8.0.40, the Stored Procedure Editor (and Schema Compare) have started to throw errors when trying to open one of our stored procedures. I have traced it down to the presence of an ALTER TABLE command within the procedure.

Here is a simple procedure that will trigger the error:

DELIMITER $$

DROP PROCEDURE IF EXISTS sp_test$$

CREATE DEFINER=root@localhost PROCEDURE sp_test()
MODIFIES SQL DATA
BEGIN

ALTER TABLE foo RENAME TO bar;

END
$$

DELIMITER ;

Specifically, if you try to open the procedure in the procedure editor, dbForge will display the error message "Unable to parse source text" and refuse to open.

Similar error messages come up when trying to execute a schema comparison that includes affected procedure.s