Bug #110124 Alter table edit trigger does not pick up trigger body to apply - 1064
Submitted: 18 Feb 2023 16:57 Modified: 20 Feb 2023 4:16
Reporter: James Ray Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S2 (Serious)
Version:8.0.32 OS:Windows (Microsoft Windows 10 Pro)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[18 Feb 2023 16:57] James Ray
Description:
Operation failed: There was an error while applying the SQL script to the database.
Executing:
DROP TRIGGER IF EXISTS `mydb`.`tbllabor_BU`;

DELIMITER $$
USE `mydb`$$
CREATE DEFINER = `root`@`localhost` TRIGGER `mydb`.`tbllabor_BU` BEFORE UPDATE ON `tbllabor` FOR EACH ROW FOLLOWS `tbllabor_BU_UUSER`
$$
DELIMITER ;

ERROR 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
SQL Statement:
CREATE DEFINER = `root`@`localhost` TRIGGER `mydb`.`tbllabor_BU` BEFORE UPDATE ON `tbllabor` FOR EACH ROW FOLLOWS `tbllabor_BU_UUSER`

How to repeat:
alter table, edit trigger, try to change it and apply changes

Suggested fix:
pick up the actual trigger body to apply
[20 Feb 2023 4:16] MySQL Verification Team
Hello James Ray,

Thank you for the report and feedback.
Verified as described.

regards,
Umesh