- Trigger defined for entity generates DDL which will case parsing error by MySQL. It’s because it requires delimeter changes. For example:
– Create triggers for table t_softlicences
DELIMITER $$
CREATE TRIGGER trg_softlicences_concat AFTER INSERT
ON t_softlicences
FOR EACH ROW
BEGIN
DECLARE a VARCHAR(150);
SELECT .... **;**
END $$
DELIMITER ;
PLease note that DELIMETER command is not ended by regular delimeter character. Curent behaviour of DDL generator would add additional delimeter like this:
DELIMETER;
;
Such syntaxt will cause SQL syntax error (empty command)
Probably you can say, that I can define/change template etc. Maybe yes. But it should be defined by default, because there is no other way to create trigger with any code inside. I guess there is the same issue with functions and stored procedures.
BTW: I know I can enter full trigger def into SQL window and mark ‘Generate SQL Only’.
- I have problems with template editor. basicly I cannot get SAVE button. I saw it once and no one more. Just there is no option to save changes into new or edited template.
There are also some minor problems with rescaling child windows under Win7 Aero (probably related to issue similar to reported resizing workspace one)
best regards
Edited by: Michal.K - added note about potential empty command issue after delimeter