Bug #49287 ALTER TABLE wizard trigger fail
Submitted: 1 Dec 2009 18:26 Modified: 10 Feb 2010 11:13
Reporter: Todd Farmer (OCA) Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S2 (Serious)
Version:5.2 r4643 OS:Windows (XP)
Assigned to: Alexander Musienko CPU Architecture:Any

[1 Dec 2009 18:26] Todd Farmer
The ALTER TABLE wizard allows for creation/manipulation of table triggers, it seems, but:

1.  It fails to show existing triggers.
2.  If one creates a new trigger using this and presses "Apply", nothing happens.
3.  If the trigger is created along with other table definition changes, only the other changes are represented in the resulting DDL script.

It seems that there is no real support for triggers, here.

How to repeat:
Try to use wizard to manage table triggers.
[1 Feb 2010 16:24] Johannes Taxacher
trigger statement now correctly generated. will be included in 5.2.16
[10 Feb 2010 11:13] Tony Bedford
An entry has been added to the 5.2.16 changelog:

In the Alter Table dialog of the SQL Editor, support for triggers appeared to be provided, but underlying functionality was missing.