Help - Search - Members - Calendar
Full Version: Bug In Backup Of Triggers
Webyog Forums > SQLyog > SQLyog BETA Discussions
peterlaursen
This is reproduced with 5.12 beta3 but may affect more versions.

Creating a dummy/empty trigger like:

CODE
DELIMITER $$;

DROP TRIGGER  `test`.`mytrig`$$

CREATE TRIGGER `test`.`mytrig` BEFORE INSERT on `test`.`test`
FOR EACH ROW BEGIN
END$$

DELIMITER;$$


both backup tools generate
CODE
CREATE TRIGGER `mytrig` BEFORE INSERT ON `test` FOR EACH ROWBEGIN
END$$


There is a missing space (or better <newline>) in ROWBEGIN !
Ritesh
I have forwarded to Sarat. He will take a look into it and this will be fixed in v5.12.
peterlaursen
BTW .. I also think that the backup tools should soon allow for backup of EVENTS with MySQL 5.1 - partiotions are backed up allready as they are returned with the 'create statement for the table'.

I don't request full-blooded support for events at this time. Only in the backup tools in 'the first run'.

Probably the code is very similar as for SP's ..
Ritesh
Trigger bug fixed in v5.12 BETA developmengt tree. We will probably support Events in v5.2. Not that hard to implement.
peterlaursen
@Ritesh

did you read this discussion: http://www.webyog.com/forums/index.php?showtopic=2119

the 'export' tool has an option to deselect 'drop trigger' statement - the 'backup' powertool has not. Why?
Ritesh
In the third page under 5x Objects, there is an option "Drop Objects". Selecting that will generate the DROP TRIGGER option. There is no separate option to drop triggers etc. individually. Its incorrect. Will be fixed in v5.2.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2008 Invision Power Services, Inc.