Bug #72278 Changing triggers after another change does not recognize it as a change
Submitted: 8 Apr 2014 17:39 Modified: 22 Apr 2014 10:27
Reporter: Juan García Martel Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:6.1.4 OS:Windows (Microsoft Windows 7 Home Premium Edition Service Pack 1 build 7601, 64-bit)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[8 Apr 2014 17:39] Juan García Martel 
Description:
Create a simple trigger for a table apply it. Do not move from the editor. Then edit it adding a comment or a new instruction, if you try to apply changes again no changes are detected so you cannot save changes.

How to repeat:
Create a simple trigger for a table apply it. Do not move from the editor. Then edit it again adding a comment or a new instruction. If you try to apply changes again no changes are detected so you cannot save changes.

Suggested fix:
Change editor change detection algorithm
[8 Apr 2014 22:35] MySQL Verification Team 
Thank you for the bug report. Workaround close editor and open it again with alter table.
[22 Apr 2014 10:27] Marcin Szalowicz 
This is a duplicate of bug #72198