Bug #72198 updating triggers do not recognize changes
Submitted: 1 Apr 2014 19:38 Modified: 12 Jun 2014 20:49
Reporter: mike coutinho Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:6.1.4 OS:MacOS
Assigned to: CPU Architecture:Any
Tags: triggers

[1 Apr 2014 19:38] mike coutinho 
Description:
I am writing a trigger in the workbench tool.  I have opened a table and went to the trigger tab.  I made changes and the changes went in just fine.  If I continue to make changes and then hit the apply button at the bottom it doesn't recognize any changes as being made to the trigger.  If I close out of the table and open it up again, i can make more changes and have them saved, but I have to do this every time I make changes.  

How to repeat:
I am writing a trigger in the workbench tool.  I have opened a table and went to the trigger tab.  I made changes and the changes went in just fine.  If I continue to make changes and then hit the apply button at the bottom it doesn't recognize any changes as being made to the trigger.  If I close out of the table and open it up again, i can make more changes and have them saved, but I have to do this every time I make changes.
[2 Apr 2014 7:49] MySQL Verification Team 
Hello Mike,

Thank you for the bug report.
Verified as described.

Reproduced with WB 6.1.4(on Win7).

Thanks,
Umesh
[22 Apr 2014 10:27] Marcin Szalowicz 
bug #72278 is a duplicate of this one
[12 Jun 2014 20:49] Philip Olson 
Fixed as of the upcoming MySQL Workbench 6.1.6 release, and here's the changelog entry:

Changes made to a Trigger were not always recognized by the "Apply"
action. 

A workaround was to edit the Trigger, close and
reopen the table, and then continue to make changes before saving.

Thank you for the bug report.