Bug In Backup Of Triggers

[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 ) 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.

[Ritesh]

http://www.webyog.com/forums/index.php?sho…view=getnewpost

[Author]

Posts